Connecting to csv in R with the teradataR package

Analytics

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!

Tags (1)
3 REPLIES
Senior Supporter

Re: Connecting to csv in R with the teradataR package

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.

Re: Connecting to csv in R with the teradataR package

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.

Senior Supporter

Re: Connecting to csv in R with the teradataR package

Can you share some rows of your csv file?