Unsupported SubQuery expression: correlation expression cannot contain unqualified column references

Question

In Hive , the following query is executed:

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

Scheme:

 t1(a,b,c) t2(b,d,e) 

Error Log:

Unsupported SubQuery 'b' expression: The correlation expression cannot contain unqualified column references.

What is a correlative expression? what are the references to unqualified columns? and can you summarize the error here.

Answer 1

You can find someone with the same problem here and the corresponding JIRA ticket .

Based on these answers, I would advise you to try:

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