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
Stephen Sprague 2014-03-12, 20:38
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: