Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18504

Hive is throwing InvalidObjectException(message:Invalid column type name is too long.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Not A Bug
    • None
    • 2.3.0, 3.0.0
    • Hive
    • None

    Description

      Hive in HDP 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

      
      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...
      

       

      [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>
      

      Attachments

        1. tweets.sql
          7 kB
          Jimson K James
        2. hive2.log
          41 kB
          Jimson K James

        Issue Links

          Activity

            People

              ngangam Naveen Gangam
              tomsmaily Jimson K James
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: