Hbase笔记_七贤镇

python版本问题
hbase建表语法
phoenix建表语法
【Hbase笔记】primary key 主要作为分区依据，防止出现热点
再web ui里勾选show start key 才会显示
CREATE TABLE IF NOT EXISTS 表名 (?ROWKEY名称数据类型 PRIMARY KEY?? 列蔟名.列名1 数据类型 NOT NULL,?? 列蔟名.列名2 数据类型 NOT NULL,?? 列蔟名.列名3 数据类型);
UPSERT INTO ORDER_DTL VALUES('000001', '已提交', 4070, 1, '4944191', '2020-04-25 12:09:16', '手机;');
双引号表示一个表或者字段
单引号表示字符串
UPSERT INTO ORDER_DTL("id", C1."status") VALUES ('000001', '已付款');
SELECT * FROM ORDER_DTL WHERE "id" = '000001';
? create view if not exists "MOMO_CHAT". "MSG" ("pk" varchar primary key, -- 指定ROWKEY映射到主键"C1"."msg_time" varchar,"C1"."sender_nickyname" varchar,"C1"."sender_account" varchar,"C1"."sender_sex" varchar,"C1"."sender_ip" varchar,"C1"."sender_os" varchar,"C1"."sender_phone_type" varchar,"C1"."sender_network" varchar,"C1"."sender_gps" varchar,"C1"."receiver_nickyname" varchar,"C1"."receiver_ip" varchar,"C1"."receiver_account" varchar,"C1"."receiver_os" varchar,"C1"."receiver_phone_type" varchar,"C1"."receiver_network" varchar,"C1"."receiver_gps" varchar,"C1"."receiver_sex" varchar,"C1"."msg_type" varchar,"C1"."distance" varchar,"C1"."message" varchar);
注意
如果要将列的名字改为小写，需要使用双引号，如下：
l 一旦加了小写，后面都得任何应用该列的地方都得使用双引号，否则将报以下错误：
Error: ERROR 504 (42703): Undefined column. columnName=ORDER_DTL.ID