hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prasanth Jayachandran <>
Subject Re: CREATE TABLE throwing error for large number of columns (very long script)
Date Fri, 25 Jul 2014 00:08:24 GMT
What version of hive are you using? What file format are you using?

Prasanth Jayachandran

On Jul 24, 2014, at 5:03 PM, <> <> 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
> 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
> 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.

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.

View raw message