Hive should support standard (ANSI) cross join syntax:
SELECT a.*, b.*
CROSS JOIN b
see comments on phabricator
Navis can you also please add explain and explain extended. It is actually fairly amazing that cross join just "works" like this to me and covering the explain output in a unit test would make me feel better.
Add explain queries so we can be sure cross join is doing what it is intended to do.
Never mind the last comment. I missed the explain in the patch. +1.
Commit. Thank you Navis.
Integrated in Hive-trunk-hadoop2 #54 (See https://builds.apache.org/job/Hive-trunk-hadoop2/54/)
HIVE-2549 Support standard cross join syntax. Navis Ryu (via egc) (Revision 1357875)
Result = ABORTED
ecapriolo : http://svn.apache.org/viewcvs.cgi/?root=Apache-SVN&view=rev&rev=1357875
This issue is fixed and released as part of 0.10.0 release. If you find an issue which seems to be related to this one, please create a new jira and link this one with new jira.