union error missing all at 'select' near

If you are on a Hive version prior to 1.2, only union all is supported. So you'll have to use union all, and wrap an outer query around it for the distinct: select distinct user from (select user from product1 union all select user from product2...) t https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Union LanguageManual Union - Apache Hive - Apache Software Foundation cwiki.apache.org...

원문링크 : union error missing all at 'select' near