[jira] [Commented] (HIVE-15200) Support setOp in subQuery with parentheses

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

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

Hive QA commented on HIVE-15200:
--------------------------------



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

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

{color:red}ERROR:{color} -1 due to 80 failed/errored test(s), 10665 tests executed
*Failed tests:*
{noformat}
TestSparkCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=104)
	[skewjoin_union_remove_2.q,avro_decimal_native.q,skewjoinopt8.q,bucketmapjoin_negative3.q,union32.q,stats6.q,groupby2_map.q,stats_only_null.q,insert_into3.q,join18_multi_distinct.q,vectorization_6.q,cross_join.q,stats9.q,timestamp_1.q,join24.q]
TestSparkCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=128)
	[union_remove_15.q,bucket_map_join_tez1.q,groupby7_noskew.q,bucketmapjoin1.q,subquery_multiinsert.q,auto_join8.q,auto_join6.q,groupby2_map_skew.q,lateral_view_explode2.q,join28.q,load_dyn_part1.q,skewjoinopt17.q,skewjoin_union_remove_1.q,union_remove_20.q,bucketmapjoin5.q]
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join4] (batchId=63)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join5] (batchId=65)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join6] (batchId=77)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join7] (batchId=24)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join8] (batchId=77)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[druid_basic2] (batchId=10)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_bigdata] (batchId=31)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[groupby_position] (batchId=35)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input14] (batchId=69)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input14_limit] (batchId=55)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input17] (batchId=33)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input18] (batchId=16)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input20] (batchId=12)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input33] (batchId=54)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input34] (batchId=16)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input35] (batchId=53)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input36] (batchId=13)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input37] (batchId=68)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input38] (batchId=12)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input5] (batchId=12)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join4] (batchId=58)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join5] (batchId=62)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join6] (batchId=67)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join7] (batchId=4)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[join8] (batchId=43)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[nonreserved_keywords_input37] (batchId=27)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partcols1] (batchId=57)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_transform] (batchId=68)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_union] (batchId=42)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[rcfile_bigdata] (batchId=19)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[rcfile_null_value] (batchId=25)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[regexp_extract] (batchId=48)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[setop_subq] (batchId=5)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subq] (batchId=39)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[subquery_alias] (batchId=22)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[transform_ppr1] (batchId=13)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[transform_ppr2] (batchId=39)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[union] (batchId=4)
org.apache.hadoop.hive.cli.TestContribCliDriver.testCliDriver[java_mr_example] (batchId=218)
org.apache.hadoop.hive.cli.TestContribCliDriver.testCliDriver[serde_typedbytes2] (batchId=218)
org.apache.hadoop.hive.cli.TestContribCliDriver.testCliDriver[serde_typedbytes3] (batchId=218)
org.apache.hadoop.hive.cli.TestContribCliDriver.testCliDriver[serde_typedbytes4] (batchId=218)
org.apache.hadoop.hive.cli.TestContribCliDriver.testCliDriver[serde_typedbytes5] (batchId=218)
org.apache.hadoop.hive.cli.TestContribCliDriver.testCliDriver[serde_typedbytes] (batchId=218)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[transform_ppr1] (batchId=131)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[transform_ppr2] (batchId=133)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[cluster] (batchId=141)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[columnstats_part_coltype] (batchId=148)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[join_acid_non_acid] (batchId=150)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[union_fast_stats] (batchId=145)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[scriptfile1] (batchId=158)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainanalyze_2] (batchId=91)
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver[scriptfile1] (batchId=82)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[cte_with_in_subquery] (batchId=83)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[right_side_join] (batchId=83)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[subq_insert] (batchId=83)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[auto_join4] (batchId=122)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[auto_join5] (batchId=123)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[auto_join7] (batchId=103)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_bigdata] (batchId=106)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[groupby_position] (batchId=108)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[input14] (batchId=125)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[input17] (batchId=107)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[input18] (batchId=100)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join4] (batchId=119)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join5] (batchId=121)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join6] (batchId=124)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join7] (batchId=94)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[join8] (batchId=112)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[ppd_transform] (batchId=125)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[rcfile_bigdata] (batchId=101)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[scriptfile1] (batchId=127)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[transform_ppr1] (batchId=98)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[transform_ppr2] (batchId=110)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[union] (batchId=93)
org.apache.hadoop.hive.ql.tool.TestLineageInfo.testSimpleQuery2 (batchId=265)
org.apache.hadoop.hive.ql.tool.TestLineageInfo.testSimpleQuery3 (batchId=265)
org.apache.hadoop.hive.ql.tool.TestLineageInfo.testSimpleQuery4 (batchId=265)
{noformat}

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

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

This message is automatically generated.

ATTACHMENT ID: 12839211 - PreCommit-HIVE-Build

> Support setOp in subQuery with parentheses
> ------------------------------------------
>
>                 Key: HIVE-15200
>                 URL: https://issues.apache.org/jira/browse/HIVE-15200
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>         Attachments: HIVE-15200.01.patch
>
>
> {code}
> explain select key from ((select key from src) union (select key from src))subq;
> {code}
> will throw
> {code}
> FAILED: ParseException line 1:47 cannot recognize input near 'union' '(' 'select' in subquery source
> {code}



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