hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/Joins" by ZhengShao
Date Tue, 24 Feb 2009 21:46:14 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.

The following page has been changed by ZhengShao:
http://wiki.apache.org/hadoop/Hive/LanguageManual/Joins

------------------------------------------------------------------------------
    | ( table_references )
  
  join_condition:
-     ON equality_expression
+     ON equality_expression ( AND equality_expression )*
  
  equality_expression: 
      expression = expression
@@ -35, +35 @@

  {{{ 
    SELECT a.* FROM a JOIN b ON (a.id = b.id) 
  }}}
+ {{{ 
+   SELECT a.* FROM a JOIN b ON (a.id = b.id AND a.department = b.department) 
+ }}}
-   is a valid join, however
+   are both valid joins, however
  {{{
    SELECT a.* FROM a JOIN b ON (a.id <> b.id)
  }}}

Mime
View raw message