[
https://issues.apache.org/jira/browse/HIVE-23101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17073480#comment-17073480
]
Hive QA commented on HIVE-23101:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12998413/HIVE-23101.2.patch
{color:red}ERROR:{color} -1 due to build exiting with an error
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/21382/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/21382/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-21382/
Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Tests exited with: NonZeroExitCodeException
Command 'bash /data/hiveptest/working/scratch/source-prep.sh' failed with exit
status 1 and output '+ date '+%Y-%m-%d %T.%3N'
2020-04-02 08:04:10.642
+ [[ -n /usr/lib/jvm/java-8-openjdk-amd64 ]]
+ export JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ JAVA_HOME=/usr/lib/jvm/java-8-openjdk-amd64
+ export
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+
PATH=/usr/lib/jvm/java-8-openjdk-amd64/bin/:/usr/local/bin:/usr/bin:/bin:/usr/local/games:/usr/games
+ export 'ANT_OPTS=-Xmx1g -XX:MaxPermSize=256m '
+ ANT_OPTS='-Xmx1g -XX:MaxPermSize=256m '
+ export 'MAVEN_OPTS=-Xmx1g '
+ MAVEN_OPTS='-Xmx1g '
+ cd /data/hiveptest/working/
+ tee /data/hiveptest/logs/PreCommit-HIVE-Build-21382/source-prep.txt
+ [[ false == \t\r\u\e ]]
+ mkdir -p maven ivy
+ [[ git = \s\v\n ]]
+ [[ git = \g\i\t ]]
+ [[ -z master ]]
+ [[ -d apache-github-source-source ]]
+ [[ ! -d apache-github-source-source/.git ]]
+ [[ ! -d apache-github-source-source ]]
+ date '+%Y-%m-%d %T.%3N'
2020-04-02 08:04:10.645
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at 709235c HIVE-23046: Separate housekeeping thread from initiator
flag (Laszlo Pinter, reviewed by Peter Vary)
+ git clean -f -d
Removing standalone-metastore/metastore-server/src/gen/
+ git checkout master
Already on 'master'
Your branch is up-to-date with 'origin/master'.
+ git reset --hard origin/master
HEAD is now at 709235c HIVE-23046: Separate housekeeping thread from initiator
flag (Laszlo Pinter, reviewed by Peter Vary)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2020-04-02 08:04:11.800
+ rm -rf ../yetus_PreCommit-HIVE-Build-21382
+ mkdir ../yetus_PreCommit-HIVE-Build-21382
+ git gc
+ cp -R . ../yetus_PreCommit-HIVE-Build-21382
+ mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-21382/yetus
+ patchCommandPath=/data/hiveptest/working/scratch/smart-apply-patch.sh
+ patchFilePath=/data/hiveptest/working/scratch/build.patch
+ [[ -f /data/hiveptest/working/scratch/build.patch ]]
+ chmod +x /data/hiveptest/working/scratch/smart-apply-patch.sh
+ /data/hiveptest/working/scratch/smart-apply-patch.sh
/data/hiveptest/working/scratch/build.patch
Trying to apply the patch with -p0
error: patch failed:
ql/src/test/queries/clientpositive/topnkey_grouping_sets.q:20
Falling back to three-way merge...
Applied patch to 'ql/src/test/queries/clientpositive/topnkey_grouping_sets.q'
cleanly.
error: patch failed:
ql/src/test/results/clientpositive/llap/topnkey_grouping_sets.q.out:44
Falling back to three-way merge...
Applied patch to
'ql/src/test/results/clientpositive/llap/topnkey_grouping_sets.q.out' cleanly.
error: ql/src/test/results/clientpositive/topnkey_grouping_sets.q.out: does not
exist in index
Trying to apply the patch with -p1
error: src/test/resources/testconfiguration.properties: does not exist in index
error: src/test/queries/clientpositive/topnkey_grouping_sets.q: does not exist
in index
error: src/test/results/clientpositive/llap/topnkey_grouping_sets.q.out: does
not exist in index
error: src/test/results/clientpositive/topnkey_grouping_sets.q.out: does not
exist in index
Trying to apply the patch with -p2
error: test/resources/testconfiguration.properties: does not exist in index
error: test/queries/clientpositive/topnkey_grouping_sets.q: does not exist in
index
error: test/results/clientpositive/llap/topnkey_grouping_sets.q.out: does not
exist in index
error: test/results/clientpositive/topnkey_grouping_sets.q.out: does not exist
in index
The patch does not appear to apply with p0, p1, or p2
+ result=1
+ '[' 1 -ne 0 ']'
+ rm -rf yetus_PreCommit-HIVE-Build-21382
+ exit 1
'
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12998413 - PreCommit-HIVE-Build
> Fix topnkey_grouping_sets
> -------------------------
>
> Key: HIVE-23101
> URL: https://issues.apache.org/jira/browse/HIVE-23101
> Project: Hive
> Issue Type: Sub-task
> Reporter: Krisztian Kasa
> Assignee: Krisztian Kasa
> Priority: Major
> Fix For: 4.0.0
>
> Attachments: HIVE-23101.1.patch, HIVE-23101.2.patch
>
>
> Example:
> {code}
> Client Execution succeeded but contained differences (error code = 1) after
> executing topnkey_grouping_sets.q
> 260c260
> < NULL NULL
> ---
> > NULL 1
> {code}
>
> Test *topnkey_grouping_sets* fails intermittently.
> Queries which project 2 columns but order by only one of them can have more
> than one good result set:
> {code:java}
> CREATE TABLE t_test_grouping_sets(
> a int,
> b int,
> c int
> );
> INSERT INTO t_test_grouping_sets VALUES
> (NULL, NULL, NULL),
> (5, 2, 3),
> (10, 11, 12),
> (NULL, NULL, NULL),
> (NULL, NULL, NULL),
> (6, 2, 1),
> (7, 8, 4), (7, 8, 4), (7, 8, 4),
> (5, 1, 2), (5, 1, 2), (5, 1, 2),
> (NULL, NULL, NULL);
> SELECT a, b FROM t_test_grouping_sets GROUP BY GROUPING SETS ((a, b), (a),
> (b), ()) ORDER BY a LIMIT 10;
> {code}
> {code:java}
> 5 NULL
> 5 2
> 5 1
> 6 2
> 6 NULL
> 7 8
> 7 NULL
> 10 NULL
> 10 11
> NULL 1
> {code}
> {code:java}
> 5 NULL
> 5 2
> 5 1
> 6 2
> 6 NULL
> 7 8
> 7 NULL
> 10 NULL
> 10 11
> NULL NULL
> {code}
> Since we don't order by *b* both result sets are valid.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
