[R-sig-DB] calloc error issued by sqlQuery

[Dirk Eddelbuettel]

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 | edd using debian.org | http://dirk.eddelbuettel.com