45071

Write from R to Teradata in 3.0

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?

Answer1:

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.

Recommend

  • Unable to create a sub-query
  • R tbats Model Seasonal Customer Flag No Results
  • SQL Convert Week Number to Date (dd/MM)
  • Getting connection property name
  • Pyodbc Issue with Teradata
  • How can I bulk insert?
  • Trying to subtract 5 days from a defined date - Google App Script
  • R: gsub of exact full string with fixed = T
  • Converting date to character format in SQL
  • Codeigniter Routing Regex
  • Specifying field size of Map collection in grails DOM
  • Spark DataFrame equivalent to Pandas Dataframe `.iloc()` method?
  • Populating a DropDownList with text and values
  • What is #:: method
  • how to cancel HostingEnvironment.QueueBackgroundWorkItem
  • Escaping a LIKE pattern or regexp string in Postgres 8.4 inside a stored procedure
  • apply a javascript function to draggable copy
  • Android changing fragment order inside FragmentPagerAdapter
  • pyodbc doesn't report sql server error
  • How can I extract results of aggregate queries in slick?
  • Create DicomImage from scratch using Dcmtk
  • Groovy: Unexpected token “:”
  • Word Open XML Mail Merge
  • Replace value with Factor in r data.table
  • Database structure design with variable amounts of fields
  • PHPUnit_Framework_TestCase class is not available. Fix… - Makegood , Eclipse
  • PHP - How to update data to MySQL when click a radio button
  • Counter field in MS Access, how to generate?
  • Submit form in a displaytag pagination
  • Delete MySQLi record without showing the id in the URL
  • Unanticipated behavior
  • Comma separated Values
  • Error creating VM instance in Google Compute Engine
  • Hits per day in Google Big Query
  • Trying to get generic when generic is not available
  • how does django model after text[] in postgresql [duplicate]
  • costura.fody for a dll that references another dll
  • Observable and ngFor in Angular 2
  • UserPrincipal.Current returns apppool on IIS
  • java string with new operator and a literal