不支持具有不相等相关谓词的聚合子查询

Question

我是Impala的新手-当我们连接下面的两个表时，我们收到以下错误消息。黑斑羚不支持>关于相关子问题-关于我们如何做到的任何建议

CREATE TABLE database.test_dve (
campo1 INT,
campo2 TIMESTAMP,
campo3 INT
)
STORED AS PARQUET;
insert into database.test_dve values(1,'2019-09-30',1);
insert into database.test_dve values(2,'2019-09-30',1);
insert into database.test_dve values(3,'2019-09-30',1);
CREATE TABLE database.test_dve2 (
campo1 INT,
campo2 TIMESTAMP
)
STORED AS PARQUET;
insert into database.test_dve2 values(1,'2019-10-30');
select *
from database.test_dve a
WHERE 0 >= (SELECT count(*) FROM database.test_dve2 b
WHERE a.campo1 = b.campo1
AND CAST(from_timestamp(a.campo2, 'yyyyMM') as INT) >= CAST(from_timestamp(b.campo2, 'yyyyMM') as INT)
);

错误消息

[HY000][Cloudera][ImpalaODBC](110(在Impala中执行查询时出错：[HY000]：AnalysisException：不支持具有不相等相关谓词的聚合子查询：CAST(from_timestamp(a.camo2，'yyyyMM'(AS INT(>=CAST(从_时间戳(b.campo2，'yyyyMM'(AS INT(

感谢

Answer 1

尝试将其替换为not exists:

select *
from database.test_dve a
WHERE NOT EXISTS (SELECT 1
FROM database.test_dve2 b
WHERE a.campo1 = b.campo1 AND
CAST(from_timestamp(a.campo2, 'yyyyMM') as INT) >= CAST(from_timestamp(b.campo2, 'yyyyMM') as INT)
);