odbc

odbc copied to clipboard

odd encoding errors with IBM Informix

4

### Issue Description and Expected Result Example: `dbGetQuery()` returns a bad error msg/truncated? I think this may be due to the length of one of the columns in the query,...

pgensler

nvarchar character encoding in nettezza db

20

### Issue Description and Expected Result When quering nettezza on nvarchar fields, returns strange characters instead of plain UTF-8. The issue occurs only on nvarchar. varchar, date_time and numeric work...

andreaspano

dbAppendTable not adding data to Hive table inside a schema

5

*@bjoerm commented on Jul 3, 2018, 10:53 AM UTC:* Hey guys, Thanks a lot for all the work on connecting R with various databases! I encountered problems when I tried...

ghost

`dbWriteTable()` fails on either append or overwrite for Teradata

1

*@neiljohnramal-teradata commented on Sep 28, 2018, 5:02 AM UTC:* `DBI::dbReadTable` can read tables in Teradata regardless of letter-casing but `dbWriteTable` would fail unless the table name matches completely (case and...

ghost

### Issue Description and Expected Result `dbWriteTable()` when connected to Cassandra 3.11.3 returns the following error: ``` Error in new_result(connection@ptr, statement) : nanodbc/nanodbc.cpp:1344: HY000: [RStudio][CassandraODBC] (15) Error while preparing a...

blairj09

### Issue Description and Expected Result `dbRemoveTable()` when connected to Cassandra 3.11.3 returns the following error: ``` Error: 'DROP TABLE "cars"' nanodbc/nanodbc.cpp:1587: HY000: [RStudio][CassandraODBC] (10) Error while executing a query...

blairj09

### Issue Description and Expected Result `dbWriteTable(overwrite = TRUE)` when connected to Cassandra 3.11.3 returns the following error: ``` Error: 'DROP TABLE "cars"' nanodbc/nanodbc.cpp:1587: HY000: [RStudio][CassandraODBC] (10) Error while executing...

blairj09

Cassandra throws error due to missing primary key

2

### Issue Description and Expected Result Cassandra requires that all tables have a primary key (see [docs](http://cassandra.apache.org/doc/latest/cql/ddl.html?)). When `DataTypes.R` is updated for Cassandra with the following: ```r `odbcDataType.Cassandra` ─ Session...

blairj09

For temporary tables in Teradata, the odbc::odbcListColumns() and DBI::dbListFields functions don't return any records. However, the tables exist and return data for dbReadTable(), dbGetQuery(), and dbListTables(). ``` > dbWriteTable(odbcCon, "testr_tempmtcars",...

nwstephens

Provide a way to prevent the Connections pane from loading

3

The idea is to provide an argument that will prevent `odbc` from activating the RStudio Connections pane, so database servers with a large number of items does not overwhelm the...

edgararuiz-zz