CREATE TABLE throwing error for large number of columns (very long script)

2014-07-24 Thread azaz.rasool
I am trying to Create a table in Hive. It's a very long script contained large number of columns and also contains complex fields like STRUCT, ARRAY etc. * Cannot create full table in one shot using CREATE TABLE statement so need to first run CREATE and then ALTER * If fields

Re: CREATE TABLE throwing error for large number of columns (very long script)

2014-07-24 Thread Prasanth Jayachandran
What version of hive are you using? What file format are you using? Thanks Prasanth Jayachandran On Jul 24, 2014, at 5:03 PM, azaz.ras...@wipro.com azaz.ras...@wipro.com wrote: I am trying to Create a table in Hive. It’s a very long script contained large number of columns and also contains

Re: CREATE TABLE throwing error for large number of columns (very long script)

2014-07-24 Thread Juan Martin Pampliega
Are you using MySQL or Postgres for the Metastore database? On Jul 24, 2014 9:08 PM, Prasanth Jayachandran pjayachand...@hortonworks.com wrote: What version of hive are you using? What file format are you using? Thanks Prasanth Jayachandran On Jul 24, 2014, at 5:03 PM,