All Forums Analytics
kfbecker 2 posts Joined 08/12
21 Aug 2012
Connecting to csv in R with the teradataR package

Hi all,

 I am trying to connect to a csv file through ODBC. It looks like R is seeing the directory correctly (no error for tdConnect), but does not see the file within. Does anyone have any thoughts?

 

> tdConnect("bigfile", "uid", "pwd", "db", "odbc")
> tdf=td.data.frame("test.csv")
Warning message:
In td.data.frame("test.csv") :
  Teradata table not found.  Result is empty data frame.

 

Thanks!

ulrich 816 posts Joined 09/09
22 Aug 2012

tdConnect connects to a Teradata database

td.data.frame is querying a Teradata DB NOT FILES....

If you wane read csv files you should open them with native R (like read.table scan) commands.

If it has to be ODBC then check the RODBC package. 

tdConnect will not work in any case for csv files.

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

kfbecker 2 posts Joined 08/12
24 Aug 2012

Ah, thanks so much for the tip. Do you have any suggestions for loading large (>10GB) csv files into R? I am using a machine with 32GB RAM, but still seem to be running into memory limit issues.

ulrich 816 posts Joined 09/09
27 Aug 2012

Can you share some rows of your csv file?

feel free to donate bitcoin:12kgAUHFUqvG2sQgaRBXFhCwyf9HXdkGud

You must sign in to leave a comment.