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
);
注意
如果要将列的名字改为小写,需要使用双引号,如下:
[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-RfNHPR2x-1648089831254)(file:///C:\Users\Administrator\AppData\Local\Temp\ksohtml\wpsD7.tmp.jpg)]
l 一旦加了小写,后面都得任何应用该列的地方都得使用双引号,否则将报以下错误:
图片转存中…(img-RfNHPR2x-1648089831254)]
l 一旦加了小写,后面都得任何应用该列的地方都得使用双引号,否则将报以下错误:
Error: ERROR 504 (42703): Undefined column. columnName=ORDER_DTL.ID