You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Bennie Schut (JIRA)" <ji...@apache.org> on 2011/06/03 18:21:47 UTC

[jira] [Created] (HIVE-2191) Allow optional [inner] on equi-join.

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


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

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Status: Patch Available  (was: Open)

> 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
>
>
> 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

        

[jira] [Commented] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Hudson (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13056893#comment-13056893 ] 

Hudson commented on HIVE-2191:
------------------------------

Integrated in Hive-trunk-h0.21 #799 (See [https://builds.apache.org/job/Hive-trunk-h0.21/799/])
    HIVE-2191. Allow optional [inner] on equi-join (Bennie Schut via jvs)

jvs : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1140748
Files : 
* /hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g
* /hive/trunk/ql/src/test/results/clientpositive/innerjoin.q.out
* /hive/trunk/ql/src/test/queries/clientpositive/innerjoin.q
* /hive/trunk/docs/xdocs/language_manual/joins.xml


> 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

        

[jira] [Commented] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
    [ 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

        

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-2191:
-----------------------------

      Resolution: Fixed
    Hadoop Flags: [Reviewed]
          Status: Resolved  (was: Patch Available)

Committed to trunk.  Thanks Bennie!

> 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

        

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Release Note: Allow optional [inner] on equi-join.
          Status: Patch Available  (was: In Progress)

https://reviews.apache.org/r/852/

I wasn't sure if a test should be added for this. I could copy a normal join test but it would add to the total build time, considering it's just an alias to join. But if a test is preferred I don't mind adding it.

> 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
>
>
> 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

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-2191:
-----------------------------

    Status: Open  (was: Patch Available)

Please add a testcase.

> 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
>
>
> 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

        

[jira] [Commented] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13054973#comment-13054973 ] 

jiraposter@reviews.apache.org commented on HIVE-2191:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/852/
-----------------------------------------------------------

(Updated 2011-06-25 21:34:41.720584)


Review request for hive.


Changes
-------

Added a test


Summary
-------

HIVE-2191: Allow optional [inner] on equi-join.


This addresses bug HIVE-2191.
    https://issues.apache.org/jira/browse/HIVE-2191


Diffs (updated)
-----

  trunk/docs/xdocs/language_manual/joins.xml 1139355 
  trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g 1139355 
  trunk/ql/src/test/queries/clientpositive/innerjoin.q PRE-CREATION 
  trunk/ql/src/test/results/clientpositive/innerjoin.q.out PRE-CREATION 

Diff: https://reviews.apache.org/r/852/diff


Testing
-------


Thanks,

Bennie



> 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
>
>
> 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

        

[jira] [Commented] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13055450#comment-13055450 ] 

jiraposter@reviews.apache.org commented on HIVE-2191:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/852/
-----------------------------------------------------------

(Updated 2011-06-27 10:18:47.688311)


Review request for hive.


Changes
-------

Added an ORDER BY on SELECT to make test deterministic.


Summary
-------

HIVE-2191: Allow optional [inner] on equi-join.


This addresses bug HIVE-2191.
    https://issues.apache.org/jira/browse/HIVE-2191


Diffs (updated)
-----

  trunk/docs/xdocs/language_manual/joins.xml 1139355 
  trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g 1139355 
  trunk/ql/src/test/queries/clientpositive/innerjoin.q PRE-CREATION 
  trunk/ql/src/test/results/clientpositive/innerjoin.q.out PRE-CREATION 

Diff: https://reviews.apache.org/r/852/diff


Testing
-------


Thanks,

Bennie



> 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
>
>
> 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

        

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Attachment: HIVE-2191.1.patch.txt

Created an alias for inner join.

> 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
>
>
> 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

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Attachment: HIVE-2191.3.patch.txt

Added an ORDER BY on SELECT to make test deterministic.

> 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

        

[jira] [Commented] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "jiraposter@reviews.apache.org (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13043967#comment-13043967 ] 

jiraposter@reviews.apache.org commented on HIVE-2191:
-----------------------------------------------------


-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/852/
-----------------------------------------------------------

Review request for hive.


Summary
-------

HIVE-2191: Allow optional [inner] on equi-join.


This addresses bug HIVE-2191.
    https://issues.apache.org/jira/browse/HIVE-2191


Diffs
-----

  trunk/docs/xdocs/language_manual/joins.xml 1131084 
  trunk/ql/src/java/org/apache/hadoop/hive/ql/parse/Hive.g 1131084 

Diff: https://reviews.apache.org/r/852/diff


Testing
-------


Thanks,

Bennie



> 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
>
>
> 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

[jira] [Work started] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on HIVE-2191 started by Bennie Schut.

> 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
>
>
> 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

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Status: Patch Available  (was: Open)

> 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

        

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Attachment: HIVE-2191.2.patch.txt

Added a test.

> 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
>
>
> 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

        

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Attachment:     (was: HIVE-2191.2.patch.txt)

> 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
>
>
> 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

        

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "John Sichi (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

John Sichi updated HIVE-2191:
-----------------------------

    Status: Open  (was: Patch Available)

Need an ORDER BY on SELECT to make test deterministic.

> 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
>
>
> 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

        

[jira] [Updated] (HIVE-2191) Allow optional [inner] on equi-join.

Posted by "Bennie Schut (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Bennie Schut updated HIVE-2191:
-------------------------------

    Attachment: HIVE-2191.2.patch.txt

> 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
>
>
> 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