【impala】subqueries in or predicates are not supported

impala目前不支持or后面接select子句

形如这种情况：

select *

from tableA

where length(id) = 17

or id in (SELECT id from tableB)

可以写成union的形式

select *

from tableA

where length(id) = 17

union

select *

from tableA

where id in (SELECT id from tableB)