Re: large sql file creating large num of columns

2012-01-16 Thread ameet chaubal
e my_table position=22 and it's waiting there at SemanticAnalyzer...   Sincerely, Ameet From: Bejoy Ks To: "u...@hive.apache.org" ; Edward Capriolo ; ameet chaubal Sent: Monday, January 16, 2012 10:24 AM Subject: Re: large sql file creating large nu

large sql file creating large num of columns

2012-01-16 Thread ameet chaubal
Hi All, I have a SQL file of size 30mb which is a single create table statement with about 800,000 columns, hence the size. I am trying to execute it using hive -f . Initially, hive ran the command with 256mb heap size and gave me an OOM error. I increased the heap size using export HADOOP_H