[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-11-12 Thread Sergey Shelukhin (JIRA) 

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

Sergey Shelukhin commented on HIVE-11493:
-

Cherry-pick has conflicts, can you make a backport?

> Predicate with integer column equals double evaluates to false
> --
>
> Key: HIVE-11493
> URL: https://issues.apache.org/jira/browse/HIVE-11493
> Project: Hive
>  Issue Type: Bug
>  Components: Query Planning
>Affects Versions: 0.14.0, 1.0.0, 1.2.0, 1.2.1, 2.0.0
>Reporter: Prasanth Jayachandran
>Assignee: Pengcheng Xiong
>Priority: Blocker
> Fix For: 2.0.0
>
> Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch, 
> HIVE-11493.03.patch, HIVE-11493.04.patch
>
>
> Filters with integer column equals double constant evaluates to false 
> everytime. Negative double constant works fine.
> {code:title=explain select * from orc_ppd where t = 10.0;}
> OK
> Stage-0
>Fetch Operator
>   limit:-1
>   Select Operator [SEL_2]
>  
> outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
>  Filter Operator [FIL_1]
> predicate:false (type: boolean)
> TableScan [TS_0]
>alias:orc_ppd
> {code}
> {code:title=explain select * from orc_ppd where t = -10.0;}
> OK
> Stage-0
>Fetch Operator
>   limit:-1
>   Select Operator [SEL_2]
>  
> outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
>  Filter Operator [FIL_1]
> predicate:(t = (- 10.0)) (type: boolean)
> TableScan [TS_0]
>alias:orc_ppd
> {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-11-11 Thread Laljo John Pullokkaran (JIRA) 

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

Laljo John Pullokkaran commented on HIVE-11493:
---

Yes  this should be back ported.

> Predicate with integer column equals double evaluates to false
> --
>
> Key: HIVE-11493
> URL: https://issues.apache.org/jira/browse/HIVE-11493
> Project: Hive
>  Issue Type: Bug
>  Components: Query Planning
>Affects Versions: 0.14.0, 1.0.0, 1.2.0, 1.2.1, 2.0.0
>Reporter: Prasanth Jayachandran
>Assignee: Pengcheng Xiong
>Priority: Blocker
> Fix For: 2.0.0
>
> Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch, 
> HIVE-11493.03.patch, HIVE-11493.04.patch
>
>
> Filters with integer column equals double constant evaluates to false 
> everytime. Negative double constant works fine.
> {code:title=explain select * from orc_ppd where t = 10.0;}
> OK
> Stage-0
>Fetch Operator
>   limit:-1
>   Select Operator [SEL_2]
>  
> outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
>  Filter Operator [FIL_1]
> predicate:false (type: boolean)
> TableScan [TS_0]
>alias:orc_ppd
> {code}
> {code:title=explain select * from orc_ppd where t = -10.0;}
> OK
> Stage-0
>Fetch Operator
>   limit:-1
>   Select Operator [SEL_2]
>  
> outputColumnNames:["_col0","_col1","_col2","_col3","_col4","_col5","_col6","_col7","_col8","_col9","_col10","_col11","_col12","_col13"]
>  Filter Operator [FIL_1]
> predicate:(t = (- 10.0)) (type: boolean)
> TableScan [TS_0]
>alias:orc_ppd
> {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-25 Thread Lefty Leverenz (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14712546#comment-14712546
 ] 

Lefty Leverenz commented on HIVE-11493:
---

This was backported to branch 1.0 (for 1.0.2), so the Fix Version/s should be 
updated.  See commit d687bfb817b5785e8bc871e89b1832f4540174e2.

Will it also go into branch-1, branch-1.2, and branch-1.1 (for 1.3.0, 1.2.2, 
and 1.1.2 respectively)?

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
  Components: Query Planning
Affects Versions: 0.14.0, 1.0.0, 1.2.0, 1.2.1, 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Fix For: 2.0.0

 Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch, 
 HIVE-11493.03.patch, HIVE-11493.04.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-18 Thread Pengcheng Xiong (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14702125#comment-14702125
 ] 

Pengcheng Xiong commented on HIVE-11493:


Yes.

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
  Components: Query Planning
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Fix For: 2.0.0

 Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch, 
 HIVE-11493.03.patch, HIVE-11493.04.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-13 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14694990#comment-14694990
 ] 

Hive QA commented on HIVE-11493:




{color:green}Overall{color}: +1 all checks pass

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12750201/HIVE-11493.04.patch

{color:green}SUCCESS:{color} +1 9349 tests passed

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4946/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4946/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4946/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12750201 - PreCommit-HIVE-TRUNK-Build

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch, 
 HIVE-11493.03.patch, HIVE-11493.04.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-12 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14693134#comment-14693134
 ] 

Hive QA commented on HIVE-11493:




{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12749930/HIVE-11493.03.patch

{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 9341 tests executed
*Failed tests:*
{noformat}
TestSparkClient - did not produce a TEST-*.xml file
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_infer_const_type
org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testMetastoreProxyUser
org.apache.hadoop.hive.thrift.TestHadoop20SAuthBridge.testSaslWithHiveMetaStore
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4930/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4930/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4930/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 4 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12749930 - PreCommit-HIVE-TRUNK-Build

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch, 
 HIVE-11493.03.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-11 Thread Hari Sankar Sivarama Subramaniyan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681310#comment-14681310
 ] 

Hari Sankar Sivarama Subramaniyan commented on HIVE-11493:
--

[~pxiong] looks like the patch#2 is no longer applying cleanly on the master. 
Can you upload new one.

Thanks
Hari

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-10 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681178#comment-14681178
 ] 

Hive QA commented on HIVE-11493:




{color:green}Overall{color}: +1 all checks pass

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12749659/HIVE-11493.02.patch

{color:green}SUCCESS:{color} +1 9348 tests passed

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4912/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4912/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4912/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12749659 - PreCommit-HIVE-TRUNK-Build

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-10 Thread Hari Sankar Sivarama Subramaniyan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14681182#comment-14681182
 ] 

Hari Sankar Sivarama Subramaniyan commented on HIVE-11493:
--

+1 for patch 2.

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch, HIVE-11493.02.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-08 Thread Hive QA (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14662883#comment-14662883
 ] 

Hive QA commented on HIVE-11493:




{color:red}Overall{color}: -1 at least one tests failed

Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12749167/HIVE-11493.01.patch

{color:red}ERROR:{color} -1 due to 8 failed/errored test(s), 9345 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_infer_const_type
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vectorization_0
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_vectorization_short_regress
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorization_0
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver_vectorization_short_regress
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_vectorization_0
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_vectorization_short_regress
org.apache.hive.hcatalog.streaming.TestStreaming.testTransactionBatchAbort
{noformat}

Test results: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4869/testReport
Console output: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/4869/console
Test logs: 
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-4869/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 8 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12749167 - PreCommit-HIVE-TRUNK-Build

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-06 Thread Prasanth Jayachandran (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14660754#comment-14660754
 ] 

Prasanth Jayachandran commented on HIVE-11493:
--

This happens even when constant propagation and cbo is disabled.

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker

 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-06 Thread Hari Sankar Sivarama Subramaniyan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14661152#comment-14661152
 ] 

Hari Sankar Sivarama Subramaniyan commented on HIVE-11493:
--

The change looks fine. +1 pending tests.

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-06 Thread Pengcheng Xiong (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14661125#comment-14661125
 ] 

Pengcheng Xiong commented on HIVE-11493:


[~hsubramaniyan], thanks a lot for your comments. Actually we do not need to 
cast the value, it is already there. We just need to change 
{code}
if (triedDouble ||
{code}
to
{code}
if (triedDouble 
{code}

 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker

 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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

[jira] [Commented] (HIVE-11493) Predicate with integer column equals double evaluates to false

2015-08-06 Thread Hari Sankar Sivarama Subramaniyan (JIRA) 

[ 
https://issues.apache.org/jira/browse/HIVE-11493?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14661158#comment-14661158
 ] 

Hari Sankar Sivarama Subramaniyan commented on HIVE-11493:
--

nit : you could actually change the comment below to reflect what you are 
actually doing.

{code}
  // however, if we already tried this, or the column is NUMBER 
type and
  // the operator is EQUAL, return false due to the type mismatch
{code}


 Predicate with integer column equals double evaluates to false
 --

 Key: HIVE-11493
 URL: https://issues.apache.org/jira/browse/HIVE-11493
 Project: Hive
  Issue Type: Bug
Affects Versions: 2.0.0
Reporter: Prasanth Jayachandran
Assignee: Pengcheng Xiong
Priority: Blocker
 Attachments: HIVE-11493.01.patch


 Filters with integer column equals double constant evaluates to false 
 everytime. Negative double constant works fine.
 {code:title=explain select * from orc_ppd where t = 10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:false (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}
 {code:title=explain select * from orc_ppd where t = -10.0;}
 OK
 Stage-0
Fetch Operator
   limit:-1
   Select Operator [SEL_2]
  
 outputColumnNames:[_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13]
  Filter Operator [FIL_1]
 predicate:(t = (- 10.0)) (type: boolean)
 TableScan [TS_0]
alias:orc_ppd
 {code}



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