Hi Guys,
In this query:
select min(YYY), max(YYY) from XXXX where trim(YYY) is not null and
trim(YYY)<>'';
we expect the following result:
#42684 ZYP7250455
Column 'YYY' is of type 'string' the file format is ORC with Snappy
compression.
However we get:
ZYP7250455
(empty for the minimum), and the only work around is to set:
hive.map.aggr=false;
Any idea what is going on here, I also made sure to update the table stats
using:
analyze table XXXX PARTITION(monthly_capture) compute statistics;
Thanks,
