topic Re: During Join: Unable to allocate enough memory error message in Discussions

During Join: Unable to allocate enough memory error message

jyedlinski1 — Mon, 12 Feb 2018 16:39:13 GMT

When joining tables, get "Unable to allocate enough memory" error or "Join failed". IT told me to ask JMP what to do. Many Thanks.

Re: During Join: Unable to allocate enough memory error message

Kevin_Anderson — Mon, 12 Feb 2018 17:30:29 GMT

Hi, jyedlinski1!

It sounds to me like you need more memory in your computer, but some more information might be helpful.

What type of join are you trying to perform? How big a table (rows and columns) are you trying to join to how big a table? How much memory do you currently have? What version of JMP? What OS?

I would also recommend submitting your question to JMP Support.

Re: During Join: Unable to allocate enough memory error message

jyedlinski1 — Mon, 12 Feb 2018 17:59:33 GMT

Thanks!

Table A: 118 MB, Rows=221341, Col=39

Table B: 146 MB, Rows=236758, Col=45

Re: During Join: Unable to allocate enough memory error message

Peter_Bartell — Mon, 12 Feb 2018 19:23:55 GMT

If in fact insufficient RAM is the culprit, one technique you might want to try, if you are running JMP 13, is JMP 13's Virtual Join capability. One of the attractive design features of this capability is to reduce the memory footprint of two or more JMP data tables that are required for some analysis purpose. Here's a link to the JMP online documentation for the Virtual Join capability:

https://www.jmp.com/support/help/13-2/Virtually_Join_Data_Tables.shtml

Re: During Join: Unable to allocate enough memory error message

Craige_Hales — Mon, 12 Feb 2018 19:57:35 GMT

make sure you are not doing a cartesian join, which would make nrows(a)*nrows(b) rows.