A) You haven't mentioned your OS which indicates you haven't followed the 
posting guide noted at the bottom of each email.

B) You cannot load an "unknown" number of rows... although you may not specify 
the number, it is finite and its value can be determined for the purposes of 
debugging your immediate problem by examining your data.in its external 
storage. Please investigate and inform us.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

xin123620 <chengxin....@gmail.com> wrote:

Dear R Users,

I was using R to import five years traffic data, but the error always come
up as shown below. The data frame contains 12 columns and unknown number of
records. Would you have any ideas that how I should deal with this
situation?  Many thanks for any hints.

>wim<-sqlQuery(channel,qry)
Error: cannot allocate vector of size 24.0 Mb
In addition: There were 16 warnings (use warnings() to see them)

>memory.size(max=T)
[1] 1535.62
>memory.size(max=F)
[1]16.24
>gc()
used (Mb) gc trigger (Mb) max used (Mb)
Ncells 141802 3.8 6160587 164.6 5130092 137.0
Vcells 1100479 8.4 200894152 1532.8 184314496 1406.3


Best,
Chengxin


--
View this message in context: 
http://r.789695.n4.nabble.com/Error-cannot-allocate-vector-of-size-tp3629384p3629384.html
Sent from the R help mailing list archive at Nabble.com.

_____________________________________________

R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.


        [[alternative HTML version deleted]]

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to