Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, :

[Asad Ejaz]

User is trying to put data into HDFS from R. For this he is using RODBC connection. Connection is working fine. But when when user is trying to run sqlSave() it is throwing error. We have tried multiple workarounds (create the table in Hive/impala first, specifying the varTypes) but it did not succeed. Checked with table colulmns as well but no luck. For workaround we dropped the table and tried again with new created table but still issue is the same.
Error is
Error in odbcUpdate(channel, query, mydata, coldata[m, ], test = test, :
missing columns in 'data'

 

Version for R is R 3.2.2 Open Source.

Any help for this is highly appreciated.

[adev...@microsoft.com]

Hi, Asad

Without a reproducible example it will be difficult to resolve this problem.  You don't post the code you are using, making it difficult to comment - since we don't know what you are actually trying.

You also don't seem to be using RRO, so the question seems somewhat off topic.

However, since you are trying to write to HDFS, have you tried to use the rhdfs package (https://github.com/RevolutionAnalytics/rhdfs)?

Good luck

Andrie