https://community.cloudera.com/t5/Support-Questions/What-is-col0-in-hive-explain-plan/m-p/191216#M153305 <P><A rel="user" href="https://community.cloudera.com/users/186/sshaw.html" nodeid="186">@Scott Shaw</A></P><P>Thanks Scott. That is what I had assumed but whats interesting is i have 2 tables: Table2 is much larger than 1 based off TableScan.</P><P>Table 1: </P><OL> <LI>|TableScan[TS_0](rows=1 width=53922865152)|</LI></OL><P>and Table 2:</P><OL> <LI>|TableScan[TS_0](rows=1 width=83922865152)|</LI></OL><P>When I do a count(*) group by col0 on table 1. There is only one ID. </P><P>When I do a count(*) group by col0 on table 2 there are about 5-6 ID's but still one that is heavily skewed. </P><P>Table 1 gets OOM error while table 2 doesnt. Any ideas on why this would be happening?</P> Wed, 16 May 2018 00:03:25 GMT crayonml 2018-05-16T00:03:25Z