1

2

3

4

5

6

7

8

9

create table hive_test.personnel_info(

cid STRING comment '身份证',

chinese_name STRING comment '中文名称',

english_name STRING comment '英文名称',

birth_date STRING comment '出生日期',

born_addr STRING comment '出生地址',

gender STRING comment '性别',

etl_date STRING comment 'ETL加载日期')

row format delimited fields terminated by '\001'

1

2

3

4

hbase shell<<EOF

create 'hbase_qiu1:personnel_info','user_id','info','data','tags';

put 'hbase_qiu1:personnel_info','rowkey001','f1:col1','value01'

EOF