[HIVE-10990] Compatibility Hive-1.2 an hbase-1.0.1.1

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.2.0
• Component/s: Beeline, HBase Handler, HiveServer2
• Assignee: Swarnim Kulkarni
• Reporter: gurmukh singh
• Due: 30/Jun/15
• Created: 12/Jun/15 12:25
• Updated: 08/Sep/15 02:04
• Resolved: 08/Sep/15 02:04

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

Issue Links

• is broken by: HBASE-12046 HTD/HCD setters should be builder-style