[ https://issues.apache.org/jira/browse/HIVE-15983?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15932219#comment-15932219 ]
Lefty Leverenz commented on HIVE-15983: --------------------------------------- Doc note: The USING keyword needs to be documented in the wiki, with version information. * [Hive Joins | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins] * [Keywords | https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-Keywords,Non-reservedKeywordsandReservedKeywords] Added a TODOC2.2 label. > Support the named columns join > ------------------------------ > > Key: HIVE-15983 > URL: https://issues.apache.org/jira/browse/HIVE-15983 > Project: Hive > Issue Type: Sub-task > Components: SQL > Affects Versions: 2.1.0 > Reporter: Carter Shanklin > Assignee: Pengcheng Xiong > Labels: TODOC2.2 > Fix For: 2.2.0 > > Attachments: HIVE-15983.01.patch, HIVE-15983.02.patch, > HIVE-15983.03.patch, HIVE-15983.04.patch > > > The named columns join is a common shortcut allowing joins on identically > named keys. Example: select * from t1 join t2 using c1 is equivalent to > select * from t1 join t2 on t1.c1 = t2.c1. SQL standard reference: Section 7.7 -- This message was sent by Atlassian JIRA (v6.3.15#6346)