#!/bin/bash
hive -e "
use ${databasename};
drop table if exists ${hivetablename};
create external table if not exists ${hivetablename} (
rowkey string,
kafkatime string,
loadtime string,
offset string
)STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES (\"hbase.columns.mapping\" = \":key,
info:kafkatime,
info:loadtime,
info:offset
\")
TBLPROPERTIES (\"hbase.table.name\" = \"${namespace}:${hbasetablename}\");"
#impala同步
impala-shell -i ${ip} \
--auth_creds_ok_in_clear -l \
-u ${usename} \
--ldap_password_cmd='echo -n ${password}' \
-d '${databasename}' \
-q "
INVALIDATE METADATA ${hivetablename};
"
注意:这里写第二部分,hbase的字段的时候要注意字段的大小写要和Hbase表的一致