· 6 years ago · Jun 20, 2019, 07:38 AM
1CREATE EXTERNAL TABLE IF NOT EXISTS hive_on_hbase_table(
2id string,
3date_col string,
4sent_ind string,
5sync_ind string)
6ROW FORMAT SERDE
7'org.apache.hadoop.hive.hbase.HBaseSerDe'
8STORED BY
9'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
10WITH SERDEPROPERTIES (
11"hbase.columns.mapping"=":key,cf:date_col,cf:sent_ind,cf:sync_ind",
12"hbase.column.storage.types"= "-,b,b,b",
13"hbase.table.default.storage.type" = "string",
14"serialization.format"="1")
15TBLPROPERTIES (
16"hbase.table.name"="hbase_table");