在 3.0 中从 R 写入 Teradata [英] Write from R to Teradata in 3.0

问题描述

R3.0 与 TeradataR 不兼容，并且没有更新包或发布源代码的计划.

R3.0 is not compatible with TeradataR and there are no plans to update the package or release the source code.

有没有人有代码片段来展示如何将数据帧写入新的或现有的 Teradata 表?

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?

推荐答案

遗憾的是，我了解到不支持批量上传.我必须简单地将数据框的每一行 INSERT 插入到表格中.

Sadly, I learned that bulk uploads are not supported. I had to simply INSERT each line of the data frame into the table.

这很耗时，我将调查 JDBC 连接是否可能更快.

This was time-consuming and I'm going to investigate whether a JDBC connection might be faster.

这篇关于在 3.0 中从 R 写入 Teradata的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！