[
https://issues.apache.org/jira/browse/HIVE-20208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16549464#comment-16549464
]
Hive QA commented on HIVE-20208:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12932193/order_by_position_alias.patch
{color:red}ERROR:{color} -1 due to build exiting with an error
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/12698/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12698/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12698/
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'
2018-07-19 16:06:04.220
+ [[ -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-12698/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'
2018-07-19 16:06:04.227
+ cd apache-github-source-source
+ git fetch origin
>From https://github.com/apache/hive
9eb8f17..6d15ce4 master -> origin/master
+ git reset --hard HEAD
HEAD is now at 9eb8f17 HIVE-20201: Hive HBaseHandler code should not use
deprecated Base64 implementation (Mike Drob, reviewed by Naveen Gangam)
+ git clean -f -d
+ git checkout master
Already on 'master'
Your branch is behind 'origin/master' by 1 commit, and can be fast-forwarded.
(use "git pull" to update your local branch)
+ git reset --hard origin/master
HEAD is now at 6d15ce4 HIVE-19360: CBO: Add an "optimizedSQL" to QueryPlan
object (Gopal V, reviewed by Jesus Camacho Rodriguez)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2018-07-19 16:06:06.364
+ rm -rf ../yetus_PreCommit-HIVE-Build-12698
+ mkdir ../yetus_PreCommit-HIVE-Build-12698
+ git gc
+ cp -R . ../yetus_PreCommit-HIVE-Build-12698
+ mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-12698/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
fatal: patch fragment without header at line 1: @@ -13640,7 +13640,7 @@ public
void processPositionAlias(ASTNode ast) throws SemanticException {
fatal: patch fragment without header at line 1: @@ -13640,7 +13640,7 @@ public
void processPositionAlias(ASTNode ast) throws SemanticException {
fatal: patch fragment without header at line 1: @@ -13640,7 +13640,7 @@ public
void processPositionAlias(ASTNode ast) throws SemanticException {
The patch does not appear to apply with p0, p1, or p2
+ result=1
+ '[' 1 -ne 0 ']'
+ rm -rf yetus_PreCommit-HIVE-Build-12698
+ exit 1
'
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12932193 - PreCommit-HIVE-Build
> order by position alias do not work
> -----------------------------------
>
> Key: HIVE-20208
> URL: https://issues.apache.org/jira/browse/HIVE-20208
> Project: Hive
> Issue Type: Bug
> Components: Hive
> Reporter: xulongfetion
> Assignee: Vineet Garg
> Priority: Blocker
> Labels: patch-available
> Attachments: order_by_position_alias.patch
>
>
> the order by position alias do not work if there's more than one position
> alias. For query like
> "select a, b, c from table1 order by 1, 2;", hive will report column not
> found error.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
