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

Compatibility Hive-1.2 an hbase-1.0.1.1

    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

              People

              • Assignee:
                swarnim Swarnim Kulkarni
                Reporter:
                gurmukhd gurmukh singh
              • Votes:
                2 Vote for this issue
                Watchers:
                8 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: