查询hive外表，简单的where name = 'xxxxx'，却会出现不是该值的数据

[U_1653877843946_5466]

查了profile，查询会被改为name <= ‘邢福芬’, name >= ‘邢福芬’

[U_1653877843946_5466]

StarRocks的版本是2.2

[yuchen1019]

麻烦发下对应的hive版本及建表语句

[U_1653877843946_5466]

hive是2.2.1，请问建表语句指的hive端还是sr端？

[yuchen1019]

sr端的 ，麻烦了

[U_1653877843946_5466]

CREATE EXTERNAL TABLE d_manager_ex (
ywy_bm varchar(200) NULL COMMENT “”,
area varchar(200) NULL COMMENT “”,
m_name varchar(200) NULL COMMENT “”,
jobtitle varchar(200) NULL COMMENT “”,
hist_date varchar(200) NULL COMMENT “”,
time_stamp datetime NULL COMMENT “”
) ENGINE=HIVE
COMMENT “业务经理维表-外部表”
PROPERTIES (
“database” = “dim”,
“table” = “d_manager”,
“resource” = “hive_dwd”,
“hive.metastore.uris” = “thrift://192.168.88.120:9083”
);
麻烦您了

[yuchen1019]

好的收到 我先尝试复现下

[dorianzheng]

请问你们是什么文件格式，parquet还是orc？

[U_1653877843946_5466]

文件格式是ORC格式的

[dorianzheng]

I’m not able to reproduce your issue

[U_1653877843946_5466]

What is your hive version？

[U_1653877843946_5466]

该表的同步方式是历史Union all新增，发现结果是把所有新增的都select 出来，历史过滤的数据是没问题的20220531-114022.xlsx (12.4 KB)

[dorianzheng]

@U_1653877843946_5466 my hive version is 3.1.2

[dorianzheng]

@U_1653877843946_5466 Is it ok to query it on hive?

[ithan]

我也遇到了同样的问题，2.4版本 starrocks where 过滤失效