FAO Posit: Suggested Update to Posit Solution Documentation

We have been migrating to a new server in our organisation using Cloudera drivers for Hive. (This is not a Posit Professional installation).

We stumbled across the known issue here of table prefixes being returned (which had not been an issue on the existing server with older drivers):
Apache Hive – Solutions

Using this the table prefixes are still returned:

con <- DBI::dbConnect(odbc::odbc().
                      ...,
                      SSP_hive.resultset.use.unique.column.names = FALSE)

However, it works with this amendment:

con <- DBI::dbConnect(odbc::odbc().
                      ...,
                      SSP_hive.resultset.use.unique.column.names = "false")

I would suggest adding this possible solution to the documentation.

Thank you for bringing this to our attention, @martin.R !

I've made the relevant update to our documentation.

Kind regards,
Katie

1 Like