[ https://issues.apache.org/jira/browse/HIVE-9737?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mohit Sharma resolved HIVE-9737. -------------------------------- Resolution: Fixed Release Note: Thanks > 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)