为了更快的定位您的问题，请提供以下信息，谢谢
【详述】问题详细描述
【背景】通过SR的paimon catalog跑tpch测试，就报错
【业务影响】
【是否存算分离】
【StarRocks版本】例如：3.2.6
【集群规模】例如：3fe（1 follower+2observer）+3be（fe与be混部）
【机器信息】CPU虚拟核/内存/网卡，例如：48C/64G/万兆
【联系方式】
【附件】
mysql> select
-> supp_nation,
-> cust_nation,
-> l_year,
-> sum(volume) as revenue
-> from
-> (
-> select
-> n1.n_name as supp_nation,
-> n2.n_name as cust_nation,
-> extract(year from l_shipdate) as l_year,
-> l_extendedprice * (1 - l_discount) as volume
-> from
-> paimon.paimon_db.paimon_supplier,
-> paimon.paimon_db.paimon_lineitem,
-> paimon.paimon_db.paimon_orders,
-> paimon.paimon_db.paimon_customer,
-> paimon.paimon_db.paimon_nation n1,
-> paimon.paimon_db.paimon_nation n2
-> where
-> s_suppkey = l_suppkey
-> and o_orderkey = l_orderkey
-> and c_custkey = o_custkey
-> and s_nationkey = n1.n_nationkey
-> and c_nationkey = n2.n_nationkey
-> and (
-> (n1.n_name = ‘FRANCE’ and n2.n_name = ‘GERMANY’)
-> or (n1.n_name = ‘GERMANY’ and n2.n_name = ‘FRANCE’)
-> )
-> and l_shipdate between date ‘1995-01-01’ and date ‘1996-12-31’
-> ) as shipping
-> group by
-> supp_nation,
-> cust_nation,
-> l_year
-> order by
-> supp_nation,
-> cust_nation,
-> l_year;
ERROR 1064 (HY000): only found column statistics: {18: l_shipdate, 53: cast, 13: l_extendedprice, 54: cast, 14: l_discount}, but missing statistic of col: 8: l_orderkey.
select-paimon.log (75.2 KB)
mysql> explain costs select
-> nation,
-> o_year,
-> sum(amount) as sum_profit
-> from
-> (
-> select
-> n_name as nation,
-> extract(year from o_orderdate) as o_year,
-> l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
-> from
-> paimon.paimon_db.paimon_part,
-> paimon.paimon_db.paimon_supplier,
-> paimon.paimon_db.paimon_lineitem,
-> paimon.paimon_db.paimon_partsupp,
-> paimon.paimon_db.paimon_orders,
-> paimon.paimon_db.paimon_nation
-> where
-> s_suppkey = l_suppkey
-> and ps_suppkey = l_suppkey
-> and ps_partkey = l_partkey
-> and p_partkey = l_partkey
-> and o_orderkey = l_orderkey
-> and s_nationkey = n_nationkey
-> and p_name like ‘%green%’
-> ) as profit
-> group by
-> nation,
-> o_year
-> order by
-> nation,
-> o_year desc;
ERROR 1064 (HY000): only found column statistics: {18: l_partkey, 19: l_suppkey, 21: l_quantity, 22: l_extendedprice, 23: l_discount, 55: cast, 58: cast, 59: cast}, but missing statistic of col: 17: l_orderkey.
查询paimon和iceberg都有这个问题，麻烦老师看一下是哪里的问题？