You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Peyman Mohajerian <mo...@gmail.com> on 2014/08/28 22:08:57 UTC

Hive .13 issue with hive.map.aggr=true

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,