On 3 June 2012 at 12:04, Idit Buch wrote:
| Hi,
| 
| I'm using R version 2.14.1 on Linux (Centos) and trying to issue a "select * 
from ..." query using sqlQuery(...).
| I then receive the following error:
| Error in odbcQuery(channel, query, rows_at_time) :
|   Calloc could not allocate memory (18446744073709551616 of 22816 bytes)

[...]
 
| Any idea ?

Yes. Your query appears to generate a result set which would be 

     18446744073709551616

bytes large.  So I suggest you change your query with suitable 'where ...' or
'limit N' clauses.

Dirk

-- 
Dirk Eddelbuettel | e...@debian.org | http://dirk.eddelbuettel.com

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db

Reply via email to