[ 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