hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hive QA (Jira)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-22546) Postgres schema not using quoted identifiers for certain tables
Date Wed, 04 Dec 2019 08:26:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-22546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16987646#comment-16987646
] 

Hive QA commented on HIVE-22546:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12987380/HIVE-22546.4.patch

{color:red}ERROR:{color} -1 due to build exiting with an error

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/19733/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/19733/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-19733/

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-12-04 08:24:54.967
+ [[ -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-19733/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-12-04 08:24:54.971
+ cd apache-github-source-source
+ git fetch origin
+ git reset --hard HEAD
HEAD is now at 23db35e HIVE-22526 Extract Compiler from Driver (Miklos Gergely, reviewed by
Zoltan Haindrich)
+ 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 23db35e HIVE-22526 Extract Compiler from Driver (Miklos Gergely, reviewed by
Zoltan Haindrich)
+ git merge --ff-only origin/master
Already up-to-date.
+ date '+%Y-%m-%d %T.%3N'
2019-12-04 08:24:56.159
+ rm -rf ../yetus_PreCommit-HIVE-Build-19733
+ mkdir ../yetus_PreCommit-HIVE-Build-19733
+ git gc
+ cp -R . ../yetus_PreCommit-HIVE-Build-19733
+ mkdir /data/hiveptest/logs/PreCommit-HIVE-Build-19733/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-19733
+ exit 1
'
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12987380 - 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.4.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)

Mime
View raw message