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")
In td.data.frame("test.csv") :
Teradata table not found. Result is empty data frame.
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.
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.