hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2191) Allow optional [inner] on equi-join.
Date Mon, 27 Jun 2011 21:56:47 GMT

    [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055790#comment-13055790
] 

John Sichi commented on HIVE-2191:
----------------------------------

+1.  Will commit when tests pass.  (For future reference, you should put the ORDER BY on the
SELECT which does the fetch diffed by the test, not the INSERT.  In this case it's OK since
it's a SELECT *, which is currently guaranteed to fetch in table order.)


> Allow optional [inner] on equi-join.
> ------------------------------------
>
>                 Key: HIVE-2191
>                 URL: https://issues.apache.org/jira/browse/HIVE-2191
>             Project: Hive
>          Issue Type: Improvement
>          Components: Query Processor
>            Reporter: Bennie Schut
>            Assignee: Bennie Schut
>            Priority: Trivial
>             Fix For: 0.8.0
>
>         Attachments: HIVE-2191.1.patch.txt, HIVE-2191.2.patch.txt, HIVE-2191.3.patch.txt
>
>
> Lot's of databases including mysql support an optional "inner" keyword to explicitely
select an equi-join.
> As shown in the mysql docs: http://dev.mysql.com/doc/refman/5.1/en/join.html
> For completeness/portability we should allow this.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message