Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> full outer join result

Copy link to this message
Re: full outer join result
well. i had some free time to search it.  from here:
http://www.postgresql.org/docs/9.3/static/sql-select.html#SQL-UNION you'll
see the default is indeed UNION DISTINCT.  so changing it to UNION ALL
you'll get different results - are they the ones you're expecting?
On Wed, Mar 12, 2014 at 9:36 AM, Stephen Sprague <[EMAIL PROTECTED]> wrote: