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

Compatibility Hive-1.2 an hbase-1.0.1.1

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: None
    • Labels:
      None

      Description

      Hive external table works fine with Hbase.

      Hive-1.2 and hbase-1.0.1.1, hadoop-2.5.2

      Not able to create a table from hive in hbase.

      1: jdbc:hive2://edge1.dilithium.com:10000/def> TBLPROPERTIES ("hbase.table.name" = "xyz");
      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hbase.HTableDescriptor.addFamily(Lorg/apache/hadoop/hbase/HColumnDescriptor;)V
      Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hbase.HTableDescriptor.addFamily(Lorg/apache/hadoop/hbase/HColumnDescriptor;)V (state=08S01,code=1)

      [hdfs@edge1 cluster]$ hive
      2015-06-12 17:56:49,952 WARN [main] conf.HiveConf: HiveConf of name hive.metastore.local does not exist

      Logging initialized using configuration in jar:file:/usr/local/cluster/apache-hive-1.2.0-bin/lib/hive-common-1.2.0.jar!/hive-log4j.properties
      SLF4J: Class path contains multiple SLF4J bindings.
      SLF4J: Found binding in [jar:file:/usr/local/cluster/apache-hive-1.2.0-bin/auxlib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: Found binding in [jar:file:/usr/local/cluster/hadoop-2.5.2/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]
      SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
      SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]
      hive> CREATE TABLE hbase_table_1(key int, value string)
      > STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
      > WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf1:val")
      > TBLPROPERTIES ("hbase.table.name" = "xyz");
      FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hbase.HTableDescriptor.addFamily(Lorg/apache/hadoop/hbase/HColumnDescriptor;)V

      =======================

      scan complete in 1535ms
      14 driver classes found
      Compliant Version Driver Class
      no 5.1 com.mysql.jdbc.Driver
      no 5.1 com.mysql.jdbc.NonRegisteringDriver
      no 5.1 com.mysql.jdbc.NonRegisteringReplicationDriver
      no 5.1 com.mysql.jdbc.ReplicationDriver
      yes 1.2 org.apache.calcite.avatica.remote.Driver
      yes 1.2 org.apache.calcite.jdbc.Driver
      yes 1.0 org.apache.commons.dbcp.PoolingDriver
      yes 10.11 org.apache.derby.jdbc.AutoloadedDriver
      yes 10.11 org.apache.derby.jdbc.Driver42
      yes 10.11 org.apache.derby.jdbc.EmbeddedDriver
      yes 10.11 org.apache.derby.jdbc.InternalDriver
      no 1.2 org.apache.hive.jdbc.HiveDriver
      yes 1.0 org.datanucleus.store.rdbms.datasource.dbcp.PoolingDriver
      no 5.1 org.gjt.mm.mysql.Driver

        Attachments

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              swarnim Swarnim Kulkarni Assign to me
              Reporter:
              gurmukhd gurmukh singh

              Dates

              • Due:
                Created:
                Updated:
                Resolved:

                Issue deployment