hive报错Unsupported SubQuery Expression : Correlating expression cannot contain unqualified column

hive报错Unsupported SubQuery Expression : Correlating expression cannot contain unqualified column
错误语句：

select * from a

where a.id IN (SELECT b.id FROM b WHERE b.x='1');

原因：

hive 1.1版本支持in，但是不支持in的子查询

解决：

用left semi join代替in子查询

select * from a

LEFT SEMI JOIN b

ON(a.id=b.id AND b.x='1');