hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peyman Mohajerian <mohaj...@gmail.com>
Subject Hive .13 issue with hive.map.aggr=true
Date Thu, 28 Aug 2014 20:08:57 GMT
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,

Mime
View raw message