...
No Format |
---|
CREATE EXTERNAL TABLE hbase_table_2(key int, value string)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = "cf1:val")
TBLPROPERTIES("hbase.table.name" = "some_existing_table", "hbase.mapred.output.outputtable" = "some_existing_table");
|
Again, hbase.columns.mapping
is required (and will be validated against the existing HBase table's column families), whereas hbase.table.name
is optional. The hbase.mapred.output.outputtable
is optional.
Column Mapping
...