上传csv文件到hdfs
hadoop fs -put hbase.csv /HbasePut
在hbase创建表
将csv文件导入hbase表
hbase org.apache.hadoop.hbase.mapreduce.importTsv -Dimporttsv.separator="," -Dimporttsv.columns=Hbase_ROW_KEY,info:sno,info:sname,info:plt,info:alb,info:age40_60,info:ca,info:age_40,info:smo_his,info:le_woed,info:cap,info:age61_74,info:age74,info:score HbasePut /Hbtest/hbasePut.csv
导入后的表
phoenix创建表的视图
create view "hbasePut"(empid varchar primary key,"info"."sno" varchar,"info"."sname" varchar,"info"."plt" varchar,"info"."alb" varchar,"info"."age40_60" varchar,"info"."ca" varchar,"info"."age<40" varchar,"info"."smo_his" varchar,"info"."le_woed" varchar,"info"."cap" varchar,"info"."age61_74" varchar,"info"."age>74" varchar,"info"."score" varchar);
查询表命令
select * from "hbasePut"
·
