You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "xinzhang (JIRA)" <ji...@apache.org> on 2018/01/02 03:50:00 UTC
[jira] [Created] (HIVE-18351) hive vectorize bug ' set
hive.vectorized.execution.enabled=true'
xinzhang created HIVE-18351:
-------------------------------
Summary: hive vectorize bug ' set hive.vectorized.execution.enabled=true'
Key: HIVE-18351
URL: https://issues.apache.org/jira/browse/HIVE-18351
Project: Hive
Issue Type: Bug
Components: hpl/sql
Affects Versions: 1.1.0
Environment: centos6.X cdh5.7 hive-1.1.0-cdh5.7.1
Reporter: xinzhang
hive shell
>set hive.vectorized.execution.enabled=true;
>select * from (SELECT a.created_day send_date, a.task_id, count(*) send_cnt FROM dwd_edm_mail_send_logger_d a WHERE a.pt <='20171228' GROUP BY a.created_day, a.task_id) p1 LEFT OUTER JOIN(SELECT a.task_id, count(CASE WHEN a.behavior=8 THEN 1 ELSE NULL END) hard_bounce_cnt, count(CASE WHEN a.behavior=7 THEN 1 ELSE NULL END) soft_bounce_cnt FROM dwd_edm_mail_bounce_logger_d a WHERE a.pt <='20171228' GROUP BY a.task_id) p2 ON p1.task_id=p2.task_id;
---------------------------------------------------------------------------
OK
2017-12-21 612 3052 612 43 43
2017-12-22 614 3274 614 56 56
2017-12-23 615 2267 615 30 30
2017-12-24 616 2126 616 47 47
2017-12-28 617 3919 617 60 60
---------------------------------------------------------------------------
>set hive.vectorized.execution.enabled=false;
>select * from (SELECT a.created_day send_date, a.task_id, count(*) send_cnt FROM dwd_edm_mail_send_logger_d a WHERE a.pt <='20171228' GROUP BY a.created_day, a.task_id) p1 LEFT OUTER JOIN(SELECT a.task_id, count(CASE WHEN a.behavior=8 THEN 1 ELSE NULL END) hard_bounce_cnt, count(CASE WHEN a.behavior=7 THEN 1 ELSE NULL END) soft_bounce_cnt FROM dwd_edm_mail_bounce_logger_d a WHERE a.pt <='20171228' GROUP BY a.task_id) p2 ON p1.task_id=p2.task_id;
---------------------------------------------------------------------------
OK
2017-12-21 612 3052 612 35 8
2017-12-22 614 3274 614 44 12
2017-12-23 615 2267 615 21 9
2017-12-24 616 2126 616 25 22
2017-12-28 617 3919 617 42 18
---------------------------------------------------------------------------
sum: the second result is right . set hive.vectorized.execution.enabled=true; make the result error.
-------------------
another try.
>SELECT a.created_day send_date, a.task_id, count(*) send_cnt FROM dwd_edm_mail_send_logger_d a WHERE a.pt <='20171228' GROUP BY a.created_day, a.task_id) p1 LEFT OUTER JOIN(SELECT a.task_id, count(CASE WHEN a.behavior=8 THEN 1 END) hard_bounce_cnt, count(CASE WHEN a.behavior=7 THEN 1 END) soft_bounce_cnt FROM dwd_edm_mail_bounce_logger_d a WHERE a.pt <='20171228' GROUP BY a.task_id) p2 ON p1.task_id=p2.task_id;
>set hive.vectorized.execution.enabled=false;
--------------------------------------------------------------------
OK
2017-12-21 612 3052 612 35 8
2017-12-22 614 3274 614 44 12
2017-12-23 615 2267 615 21 9
2017-12-24 616 2126 616 25 22
2017-12-28 617 3919 617 42 18
>set hive.vectorized.execution.enabled=true;
--------------------------------------------------------------------
OK
2017-12-21 612 3052 612 35 8
2017-12-22 614 3274 614 44 12
2017-12-23 615 2267 615 21 9
2017-12-24 616 2126 616 25 22
2017-12-28 617 3919 617 42 18
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)