hive操作

CREATE EXTERNAL TABLE accslog(key string,
                              accs_time string,
                              device_face_id string,
                              accs_ctrl_id string,
                              face_idtfy_rate string,
                              key_num string,
                              wechat_openid string,  
                              user_id string,
                              face_age string,
                              accs_type string,
                              create_time bigint)   
   STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'   
   WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,info:accs_time,info:device_face_id,info:accs_ctrl_id,info:face_idtfy_rate,info:key_num,info:wechat_openid,info:user_id,info:face_age,info:accs_type,:timestamp")   
   TBLPROPERTIES ("hbase.table.name" = "accslog");

https://blog.csdn.net/qq_15300683/article/details/80455097

https://blog.csdn.net/leanaoo/article/details/83351240

文件

CREATE TABLE areas1(id string,
                   areaname string,
                   areacode string)
row format delimited
fields terminated by ';';

load data inpath '/wd/area.txt' overwrite into table areas;

hbase

CREATE EXTERNAL TABLE areas(key string,
                           areaname string,
                           areacode string,
                           createtime bigint
                           )
 STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'   
  WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,data:areaname,data:areacode,:timestamp")   
  TBLPROPERTIES ("hbase.table.name" = "areas");

phoenix

# 访问记录
create table "accslog"(
    	"ID" varchar primary key, 
   	    "data"."accs_time" varchar,
    	"data"."create_time" varchar,
        "data"."device_face_id" varchar,
        "data"."accs_ctrl_id" varchar,
        "data"."face_idtfy_rate" varchar,
        "data"."key_num" varchar,
        "data"."wechat_openid" varchar,
        "data"."update_time" varchar,
        "data"."user_id" varchar,
        "data"."face_age" varchar,
        "data"."accs_type" varchar 
)column_encoded_bytes=0;

# 用户表
create table LOT_USERINFO_V2(
	"ID" varchar primary key, 
 	"DATA"."cmmty_nm" varchar,	
     "DATA"."prov_nm" varchar,	
     "DATA"."user_status" varchar,	
     "DATA"."cert_type" varchar,	
     "DATA"."city_nm" varchar,	
     "DATA"."hous_no" varchar,	
     "DATA"."cmmty_id" varchar,	
     "DATA"."create_time" varchar,	
     "DATA"."gender" varchar,	
     "DATA"."id_card" varchar,	
     "DATA"."mobile_no" varchar,	
     "DATA"."birth" varchar,	
     "DATA"."user_nm" varchar,	
     "DATA"."cert_num" varchar,	
     "DATA"."rgst_face_pic" varchar,	
     "DATA"."build_no" varchar,	
     "DATA"."key_num" varchar
)column_encoded_bytes=0;