MemSQL code generation has failed: Failed to codegen
<p>Ihave workstation of 250 gb Ram and 4 tb SSD. The memsql has a table that contains 1 billion records each of which 44 columns with 500 gb data. When I run the following query on that table</p>

<pre><code>SELECT  count(*) ct,name,age FROM research.all_data  group by name having count(*) &gt;100 order by ct desc
</code></pre>

<p>I got the following error </p>

<blockquote>
  <p>MemSQL code generation has failed</p>
</blockquote>

<p>I made a restart to the server and after that I got another error </p>

<blockquote>
  <p>Not enough memory available to complete the current request. The request was not processed</p>
</blockquote>

<p>I gave the server maximum mermory 220 GB and max_table_memory 190 GB. </p>

<p>why that error could happen?</p>

<p>why memsql consuming 140 gb from memory however I am using column store?</p>