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

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

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Not A Bug
    • Affects Version/s: None
    • Fix Version/s: 2.3.0, 3.0.0
    • Component/s: Hive
    • Labels:
      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. hive2.log
          41 kB
          Jimson K James
        2. tweets.sql
          7 kB
          Jimson K James

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: