You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Chao (JIRA)" <ji...@apache.org> on 2015/02/20 17:34:12 UTC

[jira] [Updated] (HIVE-9737) Issue come while creating the table in hbase using java Impla API

     [ https://issues.apache.org/jira/browse/HIVE-9737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Chao updated HIVE-9737:
-----------------------
    Description: 
I am trying to create hbase table using this query
{code}
CREATE TABLE foo4(rowkey STRING, a STRING, b STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,f:c1,f:c2') TBLPROPERTIES ('hbase.table.name' = 'bar4');
{code}
with the help of java Impala api and I am sharing you code link
https://github.com/pauldeschacht/impala-java-client

When I am trying to create table in habse I am facing this issue

{noformat}
AnalysisException: Syntax error in line 2:
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
       ^
Encountered: BY
Expected: AS

CAUSED BY: Exception: Syntax error,HY000,0,false
{noformat}

Please help me what I do?

  was:
I am trying to create hbase table using this query
CREATE TABLE foo4(rowkey STRING, a STRING, b STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,f:c1,f:c2') TBLPROPERTIES ('hbase.table.name' = 'bar4');

with the help of java Impala api and I am sharing you code link
https://github.com/pauldeschacht/impala-java-client

When I am trying to create table in habse I am facing this issue

AnalysisException: Syntax error in line 2:
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
       ^
Encountered: BY
Expected: AS

CAUSED BY: Exception: Syntax error,HY000,0,false

Please help me what I do?


> Issue come while creating the table in hbase using java Impla API
> -----------------------------------------------------------------
>
>                 Key: HIVE-9737
>                 URL: https://issues.apache.org/jira/browse/HIVE-9737
>             Project: Hive
>          Issue Type: Bug
>          Components: Database/Schema
>         Environment: Linux OS, Using Java Impala API with thrift, Cloudera Hbase database
>            Reporter: Mohit Sharma
>            Assignee: Damien Carol
>
> I am trying to create hbase table using this query
> {code}
> CREATE TABLE foo4(rowkey STRING, a STRING, b STRING) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key,f:c1,f:c2') TBLPROPERTIES ('hbase.table.name' = 'bar4');
> {code}
> with the help of java Impala api and I am sharing you code link
> https://github.com/pauldeschacht/impala-java-client
> When I am trying to create table in habse I am facing this issue
> {noformat}
> AnalysisException: Syntax error in line 2:
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
>        ^
> Encountered: BY
> Expected: AS
> CAUSED BY: Exception: Syntax error,HY000,0,false
> {noformat}
> Please help me what I do?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)