[jira] [Commented] (HIVE-15057) Support other types of operators (other than SELECT)

["Hive QA (JIRA)" <ji...@apache.org>]

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

Hive QA commented on HIVE-15057:
--------------------------------



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

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

{color:red}ERROR:{color} -1 due to 24 failed/errored test(s), 10740 tests executed
*Failed tests:*
{noformat}
TestSparkCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=111)
	[vectorization_16.q,load_dyn_part5.q,join_casesensitive.q,transform_ppr2.q,join23.q,groupby7_map_skew.q,ppd_outer_join5.q,create_merge_compressed.q,louter_join_ppr.q,sample9.q,smb_mapjoin_16.q,vectorization_not.q,having.q,ppd_outer_join1.q,union_remove_12.q]
org.apache.hadoop.hive.cli.TestCliDriver.org.apache.hadoop.hive.cli.TestCliDriver (batchId=50)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample2] (batchId=5)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample4] (batchId=15)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample6] (batchId=60)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample7] (batchId=60)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[sample9] (batchId=38)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[transform_ppr2] (batchId=134)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] (batchId=92)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[auto_join28] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[auto_join4] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[bucketmapjoin11] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby1_map] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join17] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join34] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join_nullsafe] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[load_dyn_part11] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[mergejoins_mixed] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[nullgroup] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[skewjoinopt11] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[sort] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[stats8] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[table_access_keys_stats] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union17] (batchId=123)
{noformat}

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

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: 24 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12841173 - PreCommit-HIVE-Build

> Support other types of operators (other than SELECT)
> ----------------------------------------------------
>
>                 Key: HIVE-15057
>                 URL: https://issues.apache.org/jira/browse/HIVE-15057
>             Project: Hive
>          Issue Type: Sub-task
>          Components: Logical Optimizer, Physical Optimizer
>            Reporter: Chao Sun
>            Assignee: Chao Sun
>         Attachments: HIVE-15057.1.patch, HIVE-15057.2.patch
>
>
> Currently only SELECT operators are supported for nested column pruning. We should add support for other types of operators so the optimization can work for complex queries.



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