CODEWITHSUNDEEP
hadoophivehbase
animal
animal

Reputation: 1004

import Hbase to Hive

I am trying to move data from Hbase to Hive . Below is my code

CREATE TABLE hbase_hive(key string, firstname string, age string)
STORED BY ‘org.apache.hadoop.hive.hbase.HBaseStorageHandler’
WITH SERDEPROPERTIES (“hbase.columns.mapping” = “id:firstname,id:age")
TBLPROPERTIES(“hbase.table.name” = “hl”);

but i am getting bellow error

FAILED: ParseException line 2:10 mismatched input 'org' expecting StringLiteral near 'BY' in table file format specification

I don't know what i am missing here. Please help.

Upvotes: 0

Views: 176

Answers (1)

Nirmal Ram
Nirmal Ram

Reputation: 1210

check the single quotes near STORED BY. it is different.

same for double quotes on the next line

If you want to give Hive access to an existing HBase table, use CREATE EXTERNAL TABLE

Upvotes: 1

Related Questions