这个只是展示的时候有空格，实际存储没有空格，这个展示的行为是跟MySQL一致的。
如果没有空格,我同样三条数据,用不同的查询条件,会有不同的查询结果怎么解释呢?
注意:这张表的模型是主键模型,orderid,paid_time_date,product_id是主键
哪个版本？建表语句贴一下？
版本 3.0.0
| cdouyin_order_pay | CREATE TABLE cdouyin_order_pay (
orderid varchar(500) NOT NULL COMMENT “”,
paid_time_date datetime NOT NULL COMMENT “”,
productid varchar(200) NOT NULL COMMENT “”,
channel_talent_id varchar(200) NOT NULL COMMENT “”,
product_id varchar(500) NULL COMMENT “”,
institution_id bigint(20) NULL COMMENT “”,
service_rate decimal64(9, 2) NULL COMMENT “”,
estimate_service_income decimal64(9, 2) NULL COMMENT “”,
actual_service_income double NULL COMMENT “”,
tech_service_fee_rate decimal64(9, 2) NULL COMMENT “”,
tech_service_fee decimal64(9, 2) NULL COMMENT “”,
settled_tech_service_fee double NULL COMMENT “”,
institution_name varchar(500) NULL COMMENT “”,
activity_id int(11) NULL COMMENT “”,
is_gen_service_rate int(11) NULL COMMENT “”,
second_activity_id int(11) NULL COMMENT “”,
second_commission_rate int(11) NULL COMMENT “”,
second_estimated_commission int(11) NULL COMMENT “”,
second_institution_id bigint(20) NULL COMMENT “”,
second_institution_name varchar(500) NULL COMMENT “”,
second_real_commission int(11) NULL COMMENT “”,
settlement_time int(11) NULL COMMENT “”,
refund_time int(11) NULL COMMENT “”,
pay_status int(11) NULL COMMENT “”,
productname varchar(500) NULL COMMENT “”,
paid_time int(11) NOT NULL COMMENT “”,
pay_amount decimal64(9, 2) NULL COMMENT “”,
settlement_amount double NULL COMMENT “”,
shortid varchar(500) NULL COMMENT “”,
nickname varchar(500) NULL COMMENT “”,
final_payment_time int(11) NULL COMMENT “”,
deposit_amount int(11) NULL COMMENT “”,
shopid int(11) NULL COMMENT “”,
shopname varchar(500) NULL COMMENT “”,
buy_count int(11) NULL COMMENT “”,
author_openid varchar(500) NULL COMMENT “”,
author_buyin_id varchar(500) NULL COMMENT “”,
product_img varchar(500) NULL COMMENT “”,
update_time int(11) NULL COMMENT “”,
app_name varchar(500) NULL COMMENT “”,
colonel_type int(11) NULL COMMENT “”,
media_type varchar(200) NULL COMMENT “”,
partner_id varchar(200) NULL COMMENT “”,
channel_id varchar(200) NULL COMMENT “”,
shop_id varchar(200) NULL COMMENT “”,
partner_team_id varchar(200) NULL COMMENT “”,
channel_team_id varchar(200) NULL COMMENT “”,
partner_branch_id varchar(200) NULL COMMENT “”,
channel_branch_id varchar(200) NULL COMMENT “”,
partner_group_id varchar(200) NULL COMMENT “”,
channel_group_id varchar(200) NULL COMMENT “”,
final_service_rate decimal64(9, 2) NULL COMMENT “”,
final_service_income decimal64(9, 2) NULL COMMENT “”,
system_multiple int(11) NULL COMMENT “”,
weight_multiple decimal64(9, 2) NULL COMMENT “”,
achievements_order_multiple decimal64(9, 2) NULL COMMENT “”,
is_gen_order_multiple int(11) NULL COMMENT “”,
partner_remark varchar(500) NULL COMMENT “”,
channel_remark varchar(500) NULL COMMENT “”,
order_type int(11) NULL COMMENT “”,
updated_at int(11) NULL COMMENT “”,
pay_goods_amount decimal64(9, 2) NULL COMMENT “”,
mchannel_id int(11) NULL COMMENT “用户运营id”,
mchannel_name varchar(765) NULL COMMENT “用户运营昵称”,
mchannel_team_id int(11) NULL COMMENT “用户运营所在团队id”,
mchannel_branch_id int(11) NULL COMMENT “用户运营所在分部id”,
mchannel_group_id int(11) NULL COMMENT “用户运营所在分组id”,
achievement_type int(11) NULL COMMENT “业绩类型”,
matched_by int(11) NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(orderid, paid_time_date, productid)
COMMENT “OLAP”
PARTITION BY date_trunc(‘day’, paid_time_date)
DISTRIBUTED BY HASH(productid) BUCKETS 81
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “true”,
“replicated_storage” = “true”,
“compression” = “LZ4”
); |