错误：编译语句时出错：失败：中遇到semanticexception，子级为0（状态=42000，代码=40000）
我是否需要找到一个解决方案来将子查询从on条件中取出？
select
-- a bunch of stuff min,max,sum and case statements
from tbl0 t0
inner join tbl4 t4 on (t4.aKey = t0.aKey)
left outer join tbl1 t1 on (t0.col0 = t1.col0 and t1.someKey in (select t3.aKey from tbl3 t3 where t3.someCode in ('A1','A2','A3')))
where
not(t4.aCode in ('string1' , 'strin2' , 'string3' , 'string4') and t1.someKey is null) and not (t4.bCode in ('string1' , 'string2') and t1.someCol = 0)
1条答案
按热度按时间ars1skjm1#
我在Hive1.1中也遇到了这个错误。
我认为ashishsingh可能有最好的建议：通过在表定义中移动in（select…）语句，将tbl1改为子查询。
您的查询将变成：
select -- a bunch of stuff min,max,sum and case statements from tbl0 t0 inner join tbl4 t4 on (t4.aKey = t0.aKey) left outer join (SELECT col0 FROM tbl1 WHERE somekey IN (SELECT t3.aKey FROM tbl3 t3 WHERE t3.someCode in ('A1','A2','A3'))) t1 on (t0.col0 = t1.col0) where not(t4.aCode in ('string1' , 'strin2' , 'string3' , 'string4') and t1.someKey is null) and not (t4.bCode in ('string1' , 'string2') and t1.someCol = 0)