hive建立内部表映射hbase_hive中创建hbase映射表

use cmpay_credit;

-- Create external table for USER in HBase

drop table if exists ex_user;

create external table if not exists ex_user(

rowid string,

account_level string,

name string,

boss_brand string,

credit_level string,

birthday string,

cmpay_id string,

fst_consume_day string,

bind_card_type string,

score_identity string,

is_validate string,

is_black_list string,

lastest_active_date string,

score_history_credit string,

register_date string,

score_time string,

user_id string,

admiss_date string,

score_behavior string,

score_social_cycle string,

sex string,

score_performance string,

is_real string,

mobile_no string,

bind_card_amount string,

cur_year_fst_login_day string,

score_total