Month: <span>January 2016</span>

Month: January 2016

UNION ALL returns zero record with aggregate functions in SELECT statement

This article explains how to solve the issue that UNION ALL returns zero record with aggregate functions in SELECT statement The following is the test case: UNION ALL without COUNT function will work as expected: Run the same query without setting hive.mapred.supports.subdirectories and hive.optimize.union.remove to true will give correct result: …

My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!