[jira] [Commented] (HIVE-6425) Unable to create external table with 3000+ columns

["Michalis Kongtongk (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-6425?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14124864#comment-14124864 ] 

Michalis Kongtongk commented on HIVE-6425:
------------------------------------------

Hive metastore "SERDE_PARAMS.PARAM_VALUE" column limits to [varchar 4000|https://github.com/apache/hive/blob/trunk/metastore/scripts/upgrade/mysql/hive-schema-0.14.0.mysql.sql#L455]

> Unable to create external table with 3000+ columns
> --------------------------------------------------
>
>                 Key: HIVE-6425
>                 URL: https://issues.apache.org/jira/browse/HIVE-6425
>             Project: Hive
>          Issue Type: Bug
>          Components: Metastore
>    Affects Versions: 0.10.0
>         Environment: Linux, CDH 4.2.0
>            Reporter: Anurag
>              Labels: patch
>         Attachments: Hive_Script.txt
>
>
> While creating an external table in Hive to a table in HBase with 3000+ columns, Hive shows up an error:
> FAILED: Error in metadata: MetaException(message:javax.jdo.JDODataStoreException: Put request failed : INSERT INTO "SERDE_PARAMS" ("PARAM_VALUE","SERDE_ID","PARAM_KEY") VALUES (?,?,?)
> NestedThrowables:
> org.datanucleus.store.rdbms.exceptions.MappedDatastoreException: INSERT INTO "SERDE_PARAMS" ("PARAM_VALUE","SERDE_ID","PARAM_KEY") VALUES (?,?,?) )
> FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)