Hive should support standard (ANSI) cross join syntax:
SELECT a.*, b.*
CROSS JOIN b
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.
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
Commit. Thank you Navis.
Never mind the last comment. I missed the explain in the patch. +1.
Add explain queries so we can be sure cross join is doing what it is intended to do.
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.
see comments on phabricator