Hive, mail # user - Re: Issue with Hive and table with lots of column - 2014-01-30, 19:51
 Search Hadoop and all its subprojects:

Switch to Threaded View
Copy link to this message
-
Re: Issue with Hive and table with lots of column
oh. thinking some more about this i forgot to ask some other basic
questions.

a) what storage format are you using for the table (text, sequence, rcfile,
orc or custom)?   "show create table <table>" would yield that.

b) what command is causing the stack trace?

my thinking here is rcfile and orc are column based (i think) and if you
don't select all the columns that could very well limit the size of the
"row" being returned and hence the size of the internal ArrayList.  OTOH,
if you're using "select *", um, you have my sympathies. :)
On Thu, Jan 30, 2014 at 11:33 AM, Stephen Sprague <[EMAIL PROTECTED]>wrote:
 
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB