Member since
11-14-2016
6
Posts
1
Kudos Received
0
Solutions
01-23-2017
09:26 PM
This fixed the issue, appreciate it!
... View more
01-23-2017
09:09 PM
Hello. I am trying to copy an existing table from Hive to a new table in HBase with the following query: -------------------------------------------------- CREATE TABLE hbase_lineitem (part_key int, item_id int, category_id int, dept_id int, quantity int, price double, discount double, tax double, flag_1 string, flag_2 string) STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":part_key,lineitem:item_id,lineitem:category_id,lineitem:dept_id,lineitem:quantity,lineitem:price,lineitem:discount,lineitem:tax,lineitem:flag_1,lineitem:flag_2"); INSERT OVERWRITE TABLE hbase_lineitem SELECT * FROM lineitem; --------------------------------------------------- However, I am receiving the following error: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: MetaException(message:org.apache.hadoop.hive.serde2.SerDeException org.apache.hadoop.hive.hbase.HBaseSerDe: columns has 10 elements while hbase.columns.mapping has 11 elements (counting the key if implicit)) I only count 10 elements in both of my lists, so can anyone help me figure out what mistake I am making? Thanks.
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Hive