[ https://issues.apache.org/jira/browse/HIVE-18504?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16334702#comment-16334702 ]
Eugene Koifman commented on HIVE-18504: --------------------------------------- 2.6.3 looks like HDP version > Hive is throwing InvalidObjectException(message:Invalid column type name is > too long. > ------------------------------------------------------------------------------------- > > Key: HIVE-18504 > URL: https://issues.apache.org/jira/browse/HIVE-18504 > Project: Hive > Issue Type: Bug > Components: Hive > Reporter: Jimson K James > Assignee: Naveen Gangam > Priority: Major > Fix For: 2.3.0, 3.0.0 > > Attachments: hive2.log, tweets.sql > > > Hive 2.6.3 is still throwing InvalidObjectException(message:Invalid column > type name is too long. > Please find attached the create table query. For more details please refer to > HIVE-15249 > {code:java} > FAILED: Execution Error, return code 1 from > org.apache.hadoop.hive.ql.exec.DDLTask. > InvalidObjectException(message:Invalid column type name length 2980 exceeds > max allowed length 2000, type > struct<contributors:string,coordinates:string,created_at:string,display_text_range:array<smallint>,entities:struct<hashtags:array<struct<indices:array<tinyint>,text:string>>,symbols:array... > {code} > > {code:java} > [root@sandbox-hdp hive-json]# hive --version > Hive 1.2.1000.2.6.3.0-235 > Subversion > git://ctr-e134-1499953498516-254436-01-000004.hwx.site/grid/0/jenkins/workspace/HDP-parallel-centos6/SOURCES/hive > -r 5f360bda08bb5489fbb3189b5aeaaf58029ed4b5 > Compiled by jenkins on Mon Oct 30 02:48:31 UTC 2017 > From source with checksum 94298cc1f5f5bf0f3470f3ea2e92d646 > [root@sandbox-hdp hive-json]# beeline > Beeline version 1.2.1000.2.6.3.0-235 by Apache Hive > beeline> !connect > jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 > Connecting to > jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 > Enter username for > jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: > hive > Enter password for > jdbc:hive2://sandbox-hdp.hortonworks.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: > **** > Connected to: Apache Hive (version 1.2.1000.2.6.3.0-235) > Driver: Hive JDBC (version 1.2.1000.2.6.3.0-235) > Transaction isolation: TRANSACTION_REPEATABLE_READ > 0: jdbc:hive2://sandbox-hdp.hortonworks.com:2> > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)