[
https://issues.apache.org/jira/browse/HIVE-9336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14276491#comment-14276491
]
Hive QA commented on HIVE-9336:
-------------------------------
{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/12691869/HIVE-9336.1.patch
{color:red}ERROR:{color} -1 due to 10 failed/errored test(s), 7311 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestMinimrCliDriver.testCliDriver_index_bitmap_auto
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver_optimize_nullscan
org.apache.hadoop.hive.ql.TestMTQueries.testMTQueries1
org.apache.hive.spark.client.TestSparkClient.testAddJarsAndFiles
org.apache.hive.spark.client.TestSparkClient.testCounters
org.apache.hive.spark.client.TestSparkClient.testErrorJob
org.apache.hive.spark.client.TestSparkClient.testJobSubmission
org.apache.hive.spark.client.TestSparkClient.testMetricsCollection
org.apache.hive.spark.client.TestSparkClient.testRemoteClient
org.apache.hive.spark.client.TestSparkClient.testSimpleSparkJob
{noformat}
Test results:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2356/testReport
Console output:
http://ec2-174-129-184-35.compute-1.amazonaws.com/jenkins/job/PreCommit-HIVE-TRUNK-Build/2356/console
Test logs:
http://ec2-174-129-184-35.compute-1.amazonaws.com/logs/PreCommit-HIVE-TRUNK-Build-2356/
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: 10 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12691869 - PreCommit-HIVE-TRUNK-Build
> Fix Hive throws ParseException while handling Grouping-Sets clauses
> -------------------------------------------------------------------
>
> Key: HIVE-9336
> URL: https://issues.apache.org/jira/browse/HIVE-9336
> Project: Hive
> Issue Type: Bug
> Components: Parser
> Affects Versions: 0.13.1
> Reporter: zhaohm3
> Fix For: 0.14.0
>
> Attachments: Fix-Hive-ParseException-of-Grouping-Sets.htm,
> HIVE-9336.1.patch
>
>
> Currently, when Hive parses GROUPING SETS clauses, and if there are some
> expressions that were composed of two or more common subexpressions, then the
> first element of those expressions can only be a simple Identifier without
> any qualifications, otherwise Hive will throw ParseException during its
> parser stage. Therefore, Hive will throw ParseException while parsing the
> following HQLs:
> drop table test;
> create table test(tc1 int, tc2 int, tc3 int);
>
> explain select test.tc1, test.tc2 from test group by test.tc1, test.tc2
> grouping sets(test.tc1, (test.tc1, test.tc2));
> explain select tc1+tc2, tc2 from test group by tc1+tc2, tc2 grouping
> sets(tc2, (tc1 + tc2, tc2));
>
> drop table test;
> The following contents show some ParseExctption stacktrace:
> 2015-01-07 09:53:34,718 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG method=Driver.run
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,719 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG method=TimeToSubmit
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,721 INFO [main]: ql.Driver
> (Driver.java:checkConcurrency(158)) - Concurrency mode is disabled, not
> creating a lock manager
> 2015-01-07 09:53:34,721 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG method=compile
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,724 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG method=parse
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,724 INFO [main]: parse.ParseDriver
> (ParseDriver.java:parse(185)) - Parsing command: explain select test.tc1,
> test.tc2 from test group by test.tc1, test.tc2 grouping sets(test.tc1,
> (test.tc1, test.tc2))
> 2015-01-07 09:53:34,734 ERROR [main]: ql.Driver
> (SessionState.java:printError(545)) - FAILED: ParseException line 1:105
> missing ) at ',' near '<EOF>'
> line 1:116 extraneous input ')' expecting EOF near '<EOF>'
> org.apache.hadoop.hive.ql.parse.ParseException: line 1:105 missing ) at
> ',' near '<EOF>'
> line 1:116 extraneous input ')' expecting EOF near '<EOF>'
> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:210)
> at org.apache.hadoop.hive.ql.parse.ParseDriver.parse(ParseDriver.java:166)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:404)
> at org.apache.hadoop.hive.ql.Driver.compile(Driver.java:322)
> at org.apache.hadoop.hive.ql.Driver.compileInternal(Driver.java:975)
> at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:1040)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:911)
> at org.apache.hadoop.hive.ql.Driver.run(Driver.java:901)
> at
> org.apache.hadoop.hive.cli.CliDriver.processLocalCmd(CliDriver.java:268)
> at org.apache.hadoop.hive.cli.CliDriver.processCmd(CliDriver.java:220)
> at org.apache.hadoop.hive.cli.CliDriver.processLine(CliDriver.java:423)
> at org.apache.hadoop.hive.cli.CliDriver.executeDriver(CliDriver.java:792)
> at org.apache.hadoop.hive.cli.CliDriver.run(CliDriver.java:686)
> at org.apache.hadoop.hive.cli.CliDriver.main(CliDriver.java:625)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at org.apache.hadoop.util.RunJar.main(RunJar.java:208)
> 2015-01-07 09:53:34,745 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogEnd(135)) - </PERFLOG method=compile
> start=1420595614721 end=1420595614745 duration=24
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,745 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG method=releaseLocks
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,746 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogEnd(135)) - </PERFLOG method=releaseLocks
> start=1420595614745 end=1420595614746 duration=1
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,746 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogBegin(108)) - <PERFLOG method=releaseLocks
> from=org.apache.hadoop.hive.ql.Driver>
> 2015-01-07 09:53:34,746 INFO [main]: log.PerfLogger
> (PerfLogger.java:PerfLogEnd(135)) - </PERFLOG method=releaseLocks
> start=1420595614746 end=1420595614746 duration=0
> from=org.apache.hadoop.hive.ql.Driver>
> But, Hive will not throw ParseException while handling the follwing HQLs:
> drop table test;
> create table test(tc1 int, tc2 int, tc3 int);
>
> explain select tc1, test.tc2 from test group by tc1, test.tc2 grouping
> sets(tc1, (tc1, test.tc2));
> explain select tc1+tc2, tc1 from test group by tc1+tc2, tc1 grouping
> sets(tc1, (tc1, tc1 + tc2));
> explain select test.tc1, test.tc1 + test.tc2 from test group by test.tc1,
> test.tc1 + test.tc2 grouping sets(test.tc1, (test.tc1), (test.tc1 +
> test.tc2));
>
> drop table test;
> For why and how to solve it, see the attachments:
> Fix-Hive-ParseException-of-Grouping-Sets.htm and HIVE-9336.1.patch
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
