Version:2.1.5
使用查询时,查询计划未展示倒排索引使用信息。
建表语句:
CREATE TABLE `profile_zy_oneid` (
`identity_code` VARCHAR(128) NULL COMMENT '身份类型',
`identity_value` VARCHAR(128) NULL COMMENT '身份值',
`hash_partition_id` BIGINT NOT NULL COMMENT '分区字段',
`oneid` BIGINT NULL COMMENT 'oneid',
`biz_time` DATETIME NULL COMMENT '身份业务时间',
`create_time` DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '系统创建时间',
`update_time` DATETIME NULL DEFAULT CURRENT_TIMESTAMP COMMENT '系统更新时间',
INDEX idx_oneid (`oneid`) USING INVERTED COMMENT 'oneid索引'
) ENGINE=OLAP
UNIQUE KEY(`identity_code`, `identity_value`)
COMMENT '压测图谱_中移'
DISTRIBUTED BY HASH(`identity_code`, `identity_value`) BUCKETS 16
PROPERTIES (
"replication_allocation" = "tag.location.default: 2",
"min_load_replica_num" = "-1",
"is_being_synced" = "false",
"storage_medium" = "hdd",
"storage_format" = "V2",
"inverted_index_storage_format" = "V1",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"store_row_column" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false",
"group_commit_interval_ms" = "10000",
"group_commit_data_bytes" = "134217728",
"enable_mow_light_delete" = "false"
);
查询
explain SELECT * from profile_zy_oneid pzo where oneid = 200000000046843923 ;
查询计划
PLAN FRAGMENT 0
OUTPUT EXPRS:
identity_code[#10]
identity_value[#11]
hash_partition_id[#12]
oneid[#13]
biz_time[#14]
create_time[#15]
update_time[#16]
PARTITION: UNPARTITIONED
HAS_COLO_PLAN_NODE: false
VRESULT SINK
MYSQL_PROTOCAL
1:VEXCHANGE
offset: 0
distribute expr lists: identity_code[#10], identity_value[#11]
PLAN FRAGMENT 1
PARTITION: HASH_PARTITIONED: identity_code[#0], identity_value[#1]
HAS_COLO_PLAN_NODE: false
STREAM DATA SINK
EXCHANGE ID: 01
UNPARTITIONED
0:VOlapScanNode(162)
TABLE: cdp_tech_load_test.profile_zy_oneid(profile_zy_oneid), PREAGGREGATION: ON
PREDICATES: (oneid[#3] = 200000000046843923) AND (__DORIS_DELETE_SIGN__[#7] = 0)
partitions=1/1 (profile_zy_oneid)
tablets=16/16, tabletList=73972712,73972715,73972718 ...
cardinality=189100441, avgRowSize=0.0, numNodes=1
pushAggOp=NONE
final projections: identity_code[#0], identity_value[#1], hash_partition_id[#2], oneid[#3], biz_time[#4], create_time[#5], update_time[#6]
final project output tuple id: 1
Statistics
planed with unknown column statistics