建表语句如下：
CREATE TABLE ras.ras_trans_notify_t5017_cust_info_h (
cust_core_no varchar(24),
acct varchar(70),
cust_no varchar(64)
)
DUPLICATE KEY(cust_core_no, acct)
DISTRIBUTED BY HASH(cust_core_no,acct,cust_no) BUCKETS 64
PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"bloom_filter_columns" = "cust_core_no, acct"
);
explain查询结果如下：
PLAN FRAGMENT 0
OUTPUT EXPRS:
cust_core_no[#0]
acct[#1]
cust_no[#2]
PARTITION: UNPARTITIONED
HAS_COLO_PLAN_NODE: false
VRESULT SINK
MYSQL_PROTOCAL
1:VEXCHANGE
offset: 0
distribute expr lists: cust_core_no[#0], acct[#1]
PLAN FRAGMENT 1
PARTITION: HASH_PARTITIONED: cust_core_no[#0], acct[#1]
HAS_COLO_PLAN_NODE: false
STREAM DATA SINK
EXCHANGE ID: 01
UNPARTITIONED
0:VOlapScanNode(82)
TABLE: ras.ras_trans_notify_t5017_cust_info_h(ras_trans_notify_t5017_cust_info_h), PREAGGREGATION: ON
PREDICATES: ((cust_core_no[#0] = '100154523479') AND (acct[#1] = '6214633131041086108'))
partitions=1/1 (ras_trans_notify_t5017_cust_info_h)
tablets=1/64, tabletList=5993495
cardinality=1958378, avgRowSize=0.0, numNodes=1
pushAggOp=NONE
