R3.0 is not compatible with
TeradataR and there are no plans to update the package or release the source code.
Does anyone have a code snippet that shows how to write a dataframe to a new or existing Teradata table?
sql <- "CREATE TABLE teradata.aaa (yr BIGINT, ct BIGINT, tax BIGINT)" tbl <- sqlQuery(ch, sql) # Creates a table, works # What syntax to insert a dataframe 'myData' into this table?
Sadly, I learned that bulk uploads are not supported. I had to simply
INSERT each line of the data frame into the table.
This was time-consuming and I'm going to investigate whether a JDBC connection might be faster.