不受支持的子查询表达式:关联表达式不能包含不合格的列引用 [英] Unsupported SubQuery Expression : Correlating expression cannot contain unqualified column references

问题描述

在 Hive 中，以下查询失败:

In Hive the following query fails :

  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;

架构:

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

错误日志:

不支持的子查询表达式b":关联表达式不能包含不合格的列引用.

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

什么是相关表达式?什么是不合格的列引用?你能概括一下这里的错误吗..

What is correlating expression? what are unqualified column references ? and can you generalize the error here ..

推荐答案

你可以找到有同样问题的人 这里 和相应的JIRA门票.

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

基于这些答案，我建议您尝试:

Based on those 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;

这篇关于不受支持的子查询表达式:关联表达式不能包含不合格的列引用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！