[
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)
