[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-28 Thread Vineet Garg (JIRA) 

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

Vineet Garg commented on HIVE-16838:


[~ashutoshc] I have made sure that it is expected. I have updated the golden 
file and have uploaded new patch. Rest of the test failures are un-related.

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch, HIVE-16838.5.patch, 
> HIVE-16838.6.patch, HIVE-16838.7.patch, HIVE-16838.8.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-28 Thread Vineet Garg (JIRA) 

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

Vineet Garg commented on HIVE-16838:


Not sure, looking into it

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch, HIVE-16838.5.patch, 
> HIVE-16838.6.patch, HIVE-16838.7.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-28 Thread Ashutosh Chauhan (JIRA) 

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

Ashutosh Chauhan commented on HIVE-16838:
-

In latest test run, there is a change in plan for test subquery_in_having.q. 
Expected?

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch, HIVE-16838.5.patch, 
> HIVE-16838.6.patch, HIVE-16838.7.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-28 Thread Hive QA (JIRA) 

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

Hive QA commented on HIVE-16838:




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

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 11 failed/errored test(s), 10850 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[insert_overwrite_local_directory_1]
 (batchId=238)
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[materialized_view_create_rewrite]
 (batchId=238)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in_having] 
(batchId=55)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_smb_main]
 (batchId=150)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] 
(batchId=233)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testBootstrapFunctionReplication
 (batchId=217)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testCreateFunctionIncrementalReplication
 (batchId=217)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testCreateFunctionWithFunctionBinaryJarsOnHDFS
 (batchId=217)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema
 (batchId=178)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema
 (batchId=178)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation 
(batchId=178)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5803/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5803/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5803/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 11 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12874773 - PreCommit-HIVE-Build

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch, HIVE-16838.5.patch, 
> HIVE-16838.6.patch, HIVE-16838.7.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-27 Thread Ashutosh Chauhan (JIRA) 

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

Ashutosh Chauhan commented on HIVE-16838:
-

+1 pending tests

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch, HIVE-16838.5.patch, 
> HIVE-16838.6.patch, HIVE-16838.7.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-21 Thread Hive QA (JIRA) 

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

Hive QA commented on HIVE-16838:




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

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 18 failed/errored test(s), 10841 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[insert_overwrite_local_directory_1]
 (batchId=237)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_3] (batchId=52)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_4] (batchId=25)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in_having] 
(batchId=55)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notexists] 
(batchId=85)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lineage3] 
(batchId=153)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_in]
 (batchId=156)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_multi]
 (batchId=147)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_notin]
 (batchId=157)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_smb_main]
 (batchId=149)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] 
(batchId=232)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_in] 
(batchId=127)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testBootstrapFunctionReplication
 (batchId=216)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testCreateFunctionIncrementalReplication
 (batchId=216)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testCreateFunctionWithFunctionBinaryJarsOnHDFS
 (batchId=216)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema
 (batchId=177)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema
 (batchId=177)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation 
(batchId=177)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5726/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5726/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5726/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 18 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12873974 - PreCommit-HIVE-Build

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch, HIVE-16838.5.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-21 Thread Hive QA (JIRA) 

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

Hive QA commented on HIVE-16838:




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

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 19 failed/errored test(s), 10827 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_3] (batchId=52)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_4] (batchId=25)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in_having] 
(batchId=55)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notexists] 
(batchId=85)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_llap_counters]
 (batchId=143)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lineage3] 
(batchId=153)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_in]
 (batchId=156)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_multi]
 (batchId=147)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_notin]
 (batchId=157)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[tez_smb_main]
 (batchId=149)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query14] 
(batchId=232)
org.apache.hadoop.hive.cli.TestSparkCliDriver.org.apache.hadoop.hive.cli.TestSparkCliDriver
 (batchId=101)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_in] 
(batchId=127)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testBootstrapFunctionReplication
 (batchId=216)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testCreateFunctionIncrementalReplication
 (batchId=216)
org.apache.hadoop.hive.ql.parse.TestReplicationScenariosAcrossInstances.testCreateFunctionWithFunctionBinaryJarsOnHDFS
 (batchId=216)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema
 (batchId=177)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema
 (batchId=177)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation 
(batchId=177)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5724/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5724/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5724/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 19 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12873974 - PreCommit-HIVE-Build

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch, HIVE-16838.5.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-11 Thread Vineet Garg (JIRA) 

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

Vineet Garg commented on HIVE-16838:


Link to  Review Board attached/linked

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-08 Thread Hive QA (JIRA) 

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

Hive QA commented on HIVE-16838:




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

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 4 failed/errored test(s), 10822 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[create_merge_compressed]
 (batchId=237)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] 
(batchId=140)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr]
 (batchId=145)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query78] 
(batchId=232)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5592/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5592/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5592/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 12872160 - PreCommit-HIVE-Build

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch, HIVE-16838.4.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-07 Thread Hive QA (JIRA) 

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

Hive QA commented on HIVE-16838:




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

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 7 failed/errored test(s), 10820 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_sortmerge_join_2] 
(batchId=46)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] 
(batchId=140)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[columnstats_part_coltype]
 (batchId=157)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_if_expr]
 (batchId=145)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] 
(batchId=99)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query23] 
(batchId=232)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query78] 
(batchId=232)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5572/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5572/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5572/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 7 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12871926 - PreCommit-HIVE-Build

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch, 
> HIVE-16838.3.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

[jira] [Commented] (HIVE-16838) Improve plans for subqueries with non-equi co-related predicates

2017-06-07 Thread Hive QA (JIRA) 

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

Hive QA commented on HIVE-16838:




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

{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 26 failed/errored test(s), 10820 tests 
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[materialized_view_create_rewrite]
 (batchId=237)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constprog_partitioner] 
(batchId=68)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_3] (batchId=51)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[masking_4] (batchId=25)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_exists] 
(batchId=39)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_exists_having] 
(batchId=3)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_in_having] 
(batchId=55)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notexists] 
(batchId=85)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notexists_having]
 (batchId=80)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_notin_having] 
(batchId=47)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_unqualcolumnrefs]
 (batchId=17)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_mapjoin_reduce] 
(batchId=74)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic] 
(batchId=140)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[explainuser_1]
 (batchId=151)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[lineage3] 
(batchId=153)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_notin]
 (batchId=157)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_scalar]
 (batchId=152)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_select]
 (batchId=151)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[subquery_views]
 (batchId=146)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_mapjoin_reduce]
 (batchId=159)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[constprog_partitioner]
 (batchId=169)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query78] 
(batchId=232)
org.apache.hadoop.hive.cli.TestPerfCliDriver.testCliDriver[query94] 
(batchId=232)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_exists] 
(batchId=117)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[subquery_in] 
(batchId=127)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vector_mapjoin_reduce]
 (batchId=134)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/5564/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/5564/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-5564/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
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: 26 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12871769 - PreCommit-HIVE-Build

> Improve plans for subqueries with non-equi co-related predicates
> 
>
> Key: HIVE-16838
> URL: https://issues.apache.org/jira/browse/HIVE-16838
> Project: Hive
>  Issue Type: Sub-task
>  Components: Logical Optimizer
>Reporter: Vineet Garg
>Assignee: Vineet Garg
>  Labels: sub-query
> Attachments: HIVE-16838.1.patch, HIVE-16838.2.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)