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 AshishThusoo:
http://wiki.apache.org/hadoop/Hive/LanguageManual/LanguageManual/Joins

The comment on the change is:
The syntax for Joins

------------------------------------------------------------------------------
- Describe Hive/LanguageManual/LanguageManual/Joins here.
+ {{{
+ join_table:
+     table_reference JOIN table_factor [join_condition]
+   | table_reference {LEFT|RIGHT|FULL} [OUTER] JOIN table_reference 
join_condition
  
+ table_reference:
+     table_factor
+   | join_table
+ 
+ table_factor:
+     tbl_name [alias]
+   | table_subquery alias
+   | ( table_references )
+ 
+ join_condition:
+     ON equality_expression
+ 
+ equality_expression: 
+     expression = expression
+ }}}
+ 

Reply via email to