[
https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16984733#comment-16984733
]
Hive QA commented on HIVE-22546:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12987064/HIVE-22546.3.patch
{color:red}ERROR:{color} -1 due to build exiting with an error
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/19665/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19665/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19665/
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'
2019-11-29 04:09:53.507
+ [[ -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-19665/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'
2019-11-29 04:09:53.511
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at ab71e5a HIVE-22280: Q tests for partitioned temporary tables
(Laszlo Pinter via 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 ab71e5a HIVE-22280: Q tests for partitioned temporary tables
(Laszlo Pinter via Peter Vary)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2019-11-29 04:09:54.385
+ rm -rf ../yetus_PreCommit-HIVE-Build-19665
+ mkdir ../yetus_PreCommit-HIVE-Build-19665
+ git gc
+ cp -R . ../yetus_PreCommit-HIVE-Build-19665
+ mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-19665/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
error: patch failed:
standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql:1829
Falling back to three-way merge...
error: patch failed:
standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql:1829
error:
standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql:
patch does not apply
error: patch failed: pom.xml:104
Falling back to three-way merge...
Applied patch to 'pom.xml' with conflicts.
error: hive-site.xml: does not exist in index
error: conf/llap/hive-site.xml: does not exist in index
error: scripts/upgrade/hive/upgrade-3.1.0-to-4.0.0.hive.sql: does not exist in
index
error: metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql:
does not exist in index
error:
metastore-server/src/main/sql/postgres/upgrade-3.2.0-to-4.0.0.postgres.sql:
does not exist in index
fatal: git diff header lacks filename information when removing 2 leading
pathname components (line 5)
The patch does not appear to apply with p0, p1, or p2
+ result=1
+ '[' 1 -ne 0 ']'
+ rm -rf yetus_PreCommit-HIVE-Build-19665
+ exit 1
'
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12987064 - PreCommit-HIVE-Build
> Postgres schema not using quoted identifiers for certain tables
> ---------------------------------------------------------------
>
> Key: HIVE-22546
> URL: https://issues.apache.org/jira/browse/HIVE-22546
> Project: Hive
> Issue Type: Bug
> Components: Database/Schema
> Affects Versions: 4.0.0
> Reporter: Zoltan Chovan
> Assignee: Zoltan Chovan
> Priority: Major
> Attachments: HIVE-22546.2.patch, HIVE-22546.3.patch, HIVE-22546.patch
>
>
> In the latest postgresql schema
> (standalone-metastore/metastore-server/src/main/sql/postgres/hive-schema-4.0.0.postgres.sql)
> the following tables have lowercase table and column names:
> {code:java}
> aux_table
> compaction_queue
> completed_compactions
> completed_txn_components
> hive_locks
> materialization_rebuild_locks
> min_history_level
> next_compaction_queue_id
> next_lock_id
> next_txn_id
> next_write_id
> repl_txn_map
> runtime_stats
> txn_components
> txn_to_write_id
> txns
> write_set{code}
> As these tables are referenced from the Hive sys database, the queries to
> these tables will fail with a "Table not found" error.
> The problem is that the table and column names are not enclosed in quotes, so
> postgres will turn these identifiers into lowercase.
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
