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 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 are just primitive fields (even if large in numbers) then > we can Create the table in parts (First running CREATE statement and then > running few ALTER statements) > · However In few cases, we have very large STRUCT fields inside the > table. Each STRUCT contains large number of columns. STRUCT cannot be created > separately by running ALTER statements because by default ALTER works at > field level and not inside a complex field like STRUCT > > When we tried to replace the column of Struct type (with few number of > columns) to Struct type (with more number of columns) – Error message > appeared : FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. Unable to alter table. > > Is it a limitation from metastore (MySQL/Postgres) or something which can be > tweaked in Hive configuration? > > Thanks & Regards, > Azaz Rasool > Mobile (US) : +1 917 691 6266 > Mobile (India) : +91 776 097 4826 > http://lnkd.in/_BDmdK > > The information contained in this electronic message and any attachments to > this message are intended for the exclusive use of the addressee(s) and may > contain proprietary, confidential or privileged information. If you are not > the intended recipient, you should not disseminate, distribute or copy this > e-mail. Please notify the sender immediately and destroy all copies of this > message and any attachments. > > WARNING: Computer viruses can be transmitted via email. The recipient should > check this email and any attachments for the presence of viruses. The company > accepts no liability for any damage caused by any virus transmitted by this > email. > > www.wipro.com > -- CONFIDENTIALITY NOTICE NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is confidential, privileged and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, you are hereby notified that any printing, copying, dissemination, distribution, disclosure or forwarding of this communication is strictly prohibited. If you have received this communication in error, please contact the sender immediately and delete it from your system. Thank You.
