Impala JOIN语句

支持的JOIN列表:

Self-joins
Inner joins
Outer joins
Equijoins and Non-Equijoins

Semi-joins:
Anti-joins


不支持的JOIN:


不支持的JOIN:
Natural joins
原因:
 
Impala不支持自然连接运算符,这是为了避免不一致或庞大的结果集。自然连接去掉了ON和USING子句,而是自动连接左表
和右表中具有相同名称的所有列。对于快速发展的数据结构(如Hadoop中通常使用的数据结构),不建议使用这种查询。
因此,Impala不支持自然连接语法,当向表中添加或从表中删除列时,这种语法会产生不同的查询结果。

官方解释原文:
Impala does not support the NATURAL JOIN operator, again to avoid inconsistent or huge result sets. 
Natural joins do away with the ON and USING clauses, and instead automatically join on all columns with 
the same names in the left-hand and right-hand tables. This kind of query is not recommended for 
rapidly evolving data structures such as are typically used in Hadoop. Thus, Impala does not support the
 NATURAL JOIN syntax, which can produce different query results as columns are added to or removed from tables.

 

参考:

http://impala.apache.org/docs/build/html/topics/impala_joins.html

https://docs.cloudera.com/runtime/7.2.2/impala-sql-reference/topics/impala-joins.html

https://docs.cloudera.com/runtime/7.2.2/impala-sql-reference/topics/impala-hints.html

已标记关键词 清除标记
©️2020 CSDN 皮肤主题: 技术工厂 设计师:CSDN官方博客 返回首页