python版本问题
hbase建表语法
phoenix建表语法
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