starocks创建hudi catalog,rt表查询where条件没生效

【详述】问题详细描述 :

starrocks创建hudi catalog,rt表查询where条件没生效,ro表没问题
【背景】做过哪些操作?
CREATE EXTERNAL CATALOG hudi_catalog_hms
PROPERTIES
(
“type” = “hudi”,
“hive.metastore.type” = “hive”,
“hive.metastore.uris” = “thrift://xxx:9083”
);

【业务影响】
影响比较大,hudi的compaction对于更新频率较低的表不一定生效,所以我们使用Mor格式的rt表,where查询是非常常见的场景。
【StarRocks版本】例如:sr 3.0.1 hudi 0.13.1
【集群规模】例如:3fe+3be
【联系方式】社区群6-564016339@qq.com
【附件】


麻烦发一下带where条件的explain costs + sql结果

PLAN FRAGMENT 0
OUTPUT EXPRS:1: _hoodie_commit_time | 2: _hoodie_commit_seqno | 3: _hoodie_record_key | 4: _hoodie_partition_path | 5: _hoodie_file_name | 6: id | 7: name | 8: age | 9: address
PARTITION: UNPARTITIONED

RESULT SINK

1:EXCHANGE
limit: 200

PLAN FRAGMENT 1
OUTPUT EXPRS:
PARTITION: RANDOM

STREAM DATA SINK
EXCHANGE ID: 01
UNPARTITIONED

0:HudiScanNode
TABLE: cdc_input_user6_rt
NON-PARTITION PREDICATES: 7: name = ‘xb’
MIN/MAX PREDICATES: 10: name <= ‘xb’, 11: name >= ‘xb’
partitions=1/1
cardinality=200
avgRowSize=9.0
numNodes=0
limit: 200

看上面截图,是like可以查出来,但是=查不出来是吧?name like ‘%xb%’ 的结果发下,select hex(name),hex(‘xb’) from $tb_rt where name like ‘%xb%’

看起来hudi里面的name字段值有特殊字符?我这边也是验证’xb’的hex值是7862

有结论了辛苦同步下哈,谢谢

2.5正常