Displaying 2 results from an estimated 2 matches for "xmx4g".
Did you mean:
xmx1g
2013 Jul 22
1
problem loading large xlsx file into r
Hi,
I am facing trouble when trying to read large xlsx file into R. please find the code and error below. The file I was trying to read has 36,500 rows X 188 col, ~ 37 MB size.
> options( java.parameters = "-Xmx4g" )
> library(xlsx)
Loading required package: xlsxjars
Loading required package: rJava
> cftc = read.xlsx("d:\\Krishna\\Research\\CFTC_COT\\cftcdata.xlsx", 1)
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.O...
2013 Sep 06
1
Java exception error (Jcheck) while running an R script
...w.com/questions/12476044/r-how-to-clear-memory-used-by-rjava
the problem seems similar but there is no reply.
Since it mentions a memory problem, based on this post
http://www.bramschoenmakers.nl/en/node/726 i tried to change the available java
memory by using
> options(java.parameters = "-Xmx4g" )
It didn't work out. (Possibly is not related, but i had to try something).
I would like to point out that i am loading to the script an excel file (through
xlsx), making some calculations with the use of 'data.table' and 'sqldf'
packages and then writing the results to...