[jira] [Commented] (HIVE-12534) Date functions with vectorization is returning wrong results

2015-12-15 Thread Matt McCline (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-12534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15059090#comment-15059090
 ] 

Matt McCline commented on HIVE-12534:
-

There are a bunch of tests that include vectorization of the year and month 
functions in vectorized_date_funcs.q and that test passes with 
hive.vectorized.execution.mapjoin.native.fast.hashtable.enabled=false.

And with hive.vectorized.execution.mapjoin.native.fast.hashtable.enabled=true.

(Tests run on master)

I need a repro.

> Date functions with vectorization is returning wrong results
> 
>
> Key: HIVE-12534
> URL: https://issues.apache.org/jira/browse/HIVE-12534
> Project: Hive
>  Issue Type: Bug
>  Components: Vectorization
>Reporter: Rajesh Balamohan
>Assignee: Matt McCline
>Priority: Critical
> Attachments: p26_explain.txt, plan.txt
>
>
> {noformat}
> select c.effective_date, year(c.effective_date), month(c.effective_date) from 
> customers c where c.customer_id = 146028;
> hive> set hive.vectorized.execution.enabled=true;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  0   0
> hive> set hive.vectorized.execution.enabled=false;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  201511
> {noformat}
> \cc [~gopalv], [~sseth], [~sershe]



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

[jira] [Commented] (HIVE-12534) Date functions with vectorization is returning wrong results

2015-12-15 Thread Matt McCline (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-12534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15059092#comment-15059092
 ] 

Matt McCline commented on HIVE-12534:
-

Assigning to [~rajesh.balamohan]

> Date functions with vectorization is returning wrong results
> 
>
> Key: HIVE-12534
> URL: https://issues.apache.org/jira/browse/HIVE-12534
> Project: Hive
>  Issue Type: Bug
>  Components: Vectorization
>Reporter: Rajesh Balamohan
>Assignee: Matt McCline
>Priority: Critical
> Attachments: p26_explain.txt, plan.txt
>
>
> {noformat}
> select c.effective_date, year(c.effective_date), month(c.effective_date) from 
> customers c where c.customer_id = 146028;
> hive> set hive.vectorized.execution.enabled=true;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  0   0
> hive> set hive.vectorized.execution.enabled=false;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  201511
> {noformat}
> \cc [~gopalv], [~sseth], [~sershe]



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

[jira] [Commented] (HIVE-12534) Date functions with vectorization is returning wrong results

2015-12-08 Thread Sergey Shelukhin (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-12534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15047579#comment-15047579
 ] 

Sergey Shelukhin commented on HIVE-12534:
-

[~rajesh.balamohan] can you update this or file a new bug for that please?

> Date functions with vectorization is returning wrong results
> 
>
> Key: HIVE-12534
> URL: https://issues.apache.org/jira/browse/HIVE-12534
> Project: Hive
>  Issue Type: Bug
>  Components: Vectorization
>Reporter: Rajesh Balamohan
>Priority: Critical
> Attachments: plan.txt
>
>
> {noformat}
> select c.effective_date, year(c.effective_date), month(c.effective_date) from 
> customers c where c.customer_id = 146028;
> hive> set hive.vectorized.execution.enabled=true;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  0   0
> hive> set hive.vectorized.execution.enabled=false;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  201511
> {noformat}
> \cc [~gopalv], [~sseth], [~sershe]



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

[jira] [Commented] (HIVE-12534) Date functions with vectorization is returning wrong results

2015-12-01 Thread Rajesh Balamohan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-12534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15033380#comment-15033380
 ] 

Rajesh Balamohan commented on HIVE-12534:
-

HIve-12479 fixes the query mentioned in this bug. But it returned wrong results 
with another query involving date.. Will attach the plan shortly.  Setting "set 
hive.vectorized.execution.reduce.enabled=false;" / "set 
hive.vectorized.execution.enabled=false" fixes the problem

> Date functions with vectorization is returning wrong results
> 
>
> Key: HIVE-12534
> URL: https://issues.apache.org/jira/browse/HIVE-12534
> Project: Hive
>  Issue Type: Bug
>  Components: Vectorization
>Reporter: Rajesh Balamohan
>Priority: Critical
> Attachments: plan.txt
>
>
> {noformat}
> select c.effective_date, year(c.effective_date), month(c.effective_date) from 
> customers c where c.customer_id = 146028;
> hive> set hive.vectorized.execution.enabled=true;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  0   0
> hive> set hive.vectorized.execution.enabled=false;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  201511
> {noformat}
> \cc [~gopalv], [~sseth], [~sershe]



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

[jira] [Commented] (HIVE-12534) Date functions with vectorization is returning wrong results

2015-11-30 Thread Sergey Shelukhin (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-12534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15032379#comment-15032379
 ] 

Sergey Shelukhin commented on HIVE-12534:
-

[~mmccline] fyi

> Date functions with vectorization is returning wrong results
> 
>
> Key: HIVE-12534
> URL: https://issues.apache.org/jira/browse/HIVE-12534
> Project: Hive
>  Issue Type: Bug
>  Components: Vectorization
>Reporter: Rajesh Balamohan
>
> {noformat}
> select c.effective_date, year(c.effective_date), month(c.effective_date) from 
> customers c where c.customer_id = 146028;
> hive> set hive.vectorized.execution.enabled=true;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  0   0
> hive> set hive.vectorized.execution.enabled=false;
> hive> select c.effective_date, year(c.effective_date), 
> month(c.effective_date) from customers c where c.customer_id = 146028;
> 2015-11-19  201511
> {noformat}
> \cc [~gopalv], [~sseth], [~sershe]



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