TPCH性能测试,ORC存储格式查询语句有报错

【详述】按照官方文档TPCH性能测试,Hive 外部表建表(tpch_hive_csv)数据insert into Hive 外部表建表(tpch_hive_orc)后创建hive_catalog,使用StarRocks的Mysql进行22条sql查询,能正常查询tpch_hive_csv表,查询tpch_hive_orc有报错:
(1)Q2报错:
ERROR 1064 (HY000): Type mismatch: orc BIGINT to native VARCHAR(25). file = hdfs://node1.com:8020/user/hive/warehouse/tpch_hive_orc.db/region/delta_0000001_0000001_0000/bucket_00000: file = hdfs://node1.com:8020/user/hive/warehouse/tpch_hive_orc.db/region/delta_0000001_0000001_0000/bucket_00000
(2)Q3报错:
ERROR 1064 (HY000): Type mismatch: orc BIGINT to native DATE. file = hdfs://node1.com:8020/user/hive/warehouse/tpch_hive_orc.db/orders/delta_0000001_0000001_0000/bucket_00017: file = hdfs://node1.com:8020/user/hive/warehouse/tpch_hive_orc.db/orders/delta_0000001_0000001_0000/bucket_00017
(3)Q4报错:
ERROR 1064 (HY000): Not support to convert orc’s type from struct<o_orderkey:int,o_custkey:int,o_orderstatus:varchar(1),o_totalprice:double,o_orderdate:date,o_orderpriority:varchar(15),o_clerk:varchar(15),o_shippriority:int,o_comment:varchar(79)> to VARCHAR(15), filename = hdfs://node1.com:8020/user/hive/warehouse/tpch_hive_orc.db/orders/delta_0000001_0000001_0000/bucket_00094: file = hdfs://node1.com:8020/user/hive/warehouse/tpch_hive_orc.db/orders/delta_0000001_0000001_0000/bucket_00094
【背景】按照TPCH性能步骤测试
【StarRocks版本】3.1.0
【集群规模】2fe(1 follower+1observer)+2be(fe与be混部)
【机器信息】96C/256G/万兆
【附件】