hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "yinsong (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-15083) tez hsql response different from mr
Date Fri, 28 Oct 2016 09:08:58 GMT

     [ https://issues.apache.org/jira/browse/HIVE-15083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

yinsong updated HIVE-15083:
---------------------------
    Priority: Critical  (was: Major)

> tez hsql response different from mr 
> ------------------------------------
>
>                 Key: HIVE-15083
>                 URL: https://issues.apache.org/jira/browse/HIVE-15083
>             Project: Hive
>          Issue Type: Bug
>          Components: Clients
>    Affects Versions: 1.2.1
>         Environment: centos5.6,hdp2.4.2.0,hadoop2.7.1,hive1.2.1
>            Reporter: yinsong
>            Priority: Critical
>
> newdb.dwd_devices_ds stored as orc
> hsql like this:
> select count(t.lattice_id)
> from
> (select a.lattice_id,
>         case when sum(a.box_count) = 0 then 0 else (sum(a.max_box_orders+a.medium_box_orders+a.min_box_orders+a.ice_box_orders)/sum(a.box_count))
end as c_order_rate
> from
> (select lattice_id,device_id,box_count,max_box_orders,medium_box_orders,min_box_orders,ice_box_orders
from newdb.dwd_devices_ds where device_id NOT IN (1060988,1047539,1043597,1033836,1019976,1019941,1019391,1000019,1000018,4306,1000018,1000019,1001681,1006552,1019391,1019941,1019976,1031750,1033836,1043597,1047539,1047549,1060312,1060988,1061884,1062811)

>      and  (deleted_at is null) and day >= '2016-09-26' and day <= '2016-10-25')
a
> left join
> (select distinct device_id from newdb.dwd_devices_ds where deleted_at is not null and
day >= '2016-09-26' and day <= '2016-10-25') as b on a.device_id = b.device_id
> where b.device_id is null
> group by a.lattice_id) t
> where c_order_rate<0.05
> hive on tez result:12815
> hive on mr result:12530
> hive on mr result  Should be correct



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message