Hadoop Hive Correlating expression cannot contain unqualified column references

Question

I have this schema in Hive:

table1(a,b,c)
table2(b,d,e)

And I am running this Query: 

Select a,b,c from table where a in (0,100) AND b in (select b from table2
 where d>2 GROUP BY 1 ) LIMIT 1;

But I get this error:

Unsupported SubQuery Expression 'b': Correlating expression cannot contain unqualified column references.

Answer 1

Try the following command and see if it works:

Select a,b,c from table1 where a in (0,100) AND table1.b in (select b from table2
  where d>2 GROUP BY 1 ) LIMIT 1;