使用查询时,查询计划未展示倒排索引使用信息

Viewed 26

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
2 Answers

可以通过profile查看下Filtered对应的指标:Query Profile

查询计划是不显示index的使用的,index的使用是在执行阶段BE 根据本地文件的信息,自动使用的。