Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3962710E87 for ; Wed, 26 Aug 2015 17:02:46 +0000 (UTC) Received: (qmail 28366 invoked by uid 500); 26 Aug 2015 17:02:46 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 28337 invoked by uid 500); 26 Aug 2015 17:02:46 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 28327 invoked by uid 99); 26 Aug 2015 17:02:46 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 26 Aug 2015 17:02:46 +0000 Date: Wed, 26 Aug 2015 17:02:46 +0000 (UTC) From: "Nick Dimiduk (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-10990) Compatibility Hive-1.2 an hbase-1.0.1.1 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-10990?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14715155#comment-14715155 ] Nick Dimiduk commented on HIVE-10990: ------------------------------------- FYI [~enis], [~apurtell]. > Compatibility Hive-1.2 an hbase-1.0.1.1 > --------------------------------------- > > Key: HIVE-10990 > URL: https://issues.apache.org/jira/browse/HIVE-10990 > Project: Hive > Issue Type: Bug > Components: Beeline, HBase Handler, HiveServer2 > Affects Versions: 1.2.0 > Reporter: gurmukh singh > Assignee: Swarnim Kulkarni > > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)