[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17026581#comment-17026581 ] Zoltan Chovan commented on HIVE-22663: -- [~kgyrtkirk] quick workaround is to turn on ansi quotes for the mysql connection e.g.: {code:java} jdbc:mysql://localhost:3306/db?sessionVariables=sql_mode=ANSI_QUOTES {code} but a fix is on it's way, although it's a bit difficult to test properly > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.6.patch, HIVE-22663.patch > > Time Spent: 50m > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17026061#comment-17026061 ] Zoltan Haindrich commented on HIVE-22663: - this patch seem to have broke some metastore db support (at least mysql) which was working before... > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.6.patch, HIVE-22663.patch > > Time Spent: 50m > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019388#comment-17019388 ] Peter Vary commented on HIVE-22663: --- +1 > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.6.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17019318#comment-17019318 ] Zoltan Chovan commented on HIVE-22663: -- [~pvary] [~kgyrtkirk] could you take a look? > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.6.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17018476#comment-17018476 ] Hive QA commented on HIVE-22663: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12991214/HIVE-22663.6.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 17877 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/20235/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/20235/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-20235/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12991214 - PreCommit-HIVE-Build > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.6.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17018467#comment-17018467 ] Hive QA commented on HIVE-22663: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 42s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 7s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 29s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 59s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 12s{color} | {color:blue} standalone-metastore/metastore-server in master has 181 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 48s{color} | {color:blue} ql in master has 1531 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 17s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 26s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 53s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 31s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 31s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 23s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 98 new + 486 unchanged - 79 fixed = 584 total (was 565) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 5m 16s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 17s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 13s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 30m 0s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-20235/dev-support/hive-personality.sh | | git revision | master / 24c135d | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-20235/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-20235/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.6.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017542#comment-17017542 ] Hive QA commented on HIVE-22663: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12991093/HIVE-22663.5.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 17877 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.metastore.TestMetastoreHousekeepingLeaderEmptyConfig.testHouseKeepingThreadExistence (batchId=247) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/20212/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/20212/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-20212/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12991093 - PreCommit-HIVE-Build > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17017520#comment-17017520 ] Hive QA commented on HIVE-22663: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 39s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 30s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 37s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 1m 3s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 20s{color} | {color:blue} standalone-metastore/metastore-server in master has 181 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 19s{color} | {color:blue} ql in master has 1531 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 25s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 27s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 2m 1s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 32s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 32s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 23s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 98 new + 486 unchanged - 79 fixed = 584 total (was 565) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 5m 45s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 32m 6s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-20212/dev-support/hive-personality.sh | | git revision | master / bd8fa5c | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-20212/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-20212/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.5.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016497#comment-17016497 ] Hive QA commented on HIVE-22663: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12990948/HIVE-22663.4.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 1 failed/errored test(s), 17876 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_2] (batchId=90) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/20196/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/20196/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-20196/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12990948 - PreCommit-HIVE-Build > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17016465#comment-17016465 ] Hive QA commented on HIVE-22663: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 2m 3s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 38s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 41s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 1m 11s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 22s{color} | {color:blue} standalone-metastore/metastore-server in master has 181 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 30s{color} | {color:blue} ql in master has 1531 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 32s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 30s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 2m 14s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 43s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 43s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 25s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 98 new + 486 unchanged - 79 fixed = 584 total (was 565) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 6m 10s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 25s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 35m 11s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-20196/dev-support/hive-personality.sh | | git revision | master / 3b1138b | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-20196/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-20196/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, > HIVE-22663.4.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17015261#comment-17015261 ] Hive QA commented on HIVE-22663: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12990742/HIVE-22663.3.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 29 failed/errored test(s), 17876 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcid (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcidAllOp (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcidFailure (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcidFailurePart (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationToAcidWithMoveOptimization (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testMigrationWithUpgrade (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcid (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcidAllOp (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcidFailure (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcidFailurePart (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationToAcidWithMoveOptimization (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testMigrationWithUpgrade (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testConcurrentOpDuringBootStrapDumpCreateTableReplay (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testConcurrentOpDuringBootStrapDumpInsertOverwrite (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testConcurrentOpDuringBootStrapDumpInsertReplay (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testIncLoadPenFlagPropAlterDB (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testIncLoadPenFlagWithMoveOptimization (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testOnwerPropagation (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testOnwerPropagationInc (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testTableLevelDumpMigration (batchId=270) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testForParallelBootstrapLoad (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testMetadataOnlyDump (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testNonParallelBootstrapLoad (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testRetryFailure (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testForParallelBootstrapLoad (batchId=272) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testMetadataOnlyDump (batchId=272) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testNonParallelBootstrapLoad (batchId=272) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testRetryFailure (batchId=272) org.apache.hadoop.hive.ql.security.TestStorageBasedMetastoreAuthorizationProviderWithACL.testSimplePrivileges (batchId=296) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/20170/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/20170/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-20170/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 29 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12990742 - PreCommit-HIVE-Build > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL:
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17015228#comment-17015228 ] Hive QA commented on HIVE-22663: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 47s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 0s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 31s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 59s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 20s{color} | {color:blue} standalone-metastore/metastore-server in master has 181 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 0s{color} | {color:blue} ql in master has 1531 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 22s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 28s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 59s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 30s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 30s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 22s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 98 new + 486 unchanged - 79 fixed = 584 total (was 565) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 5m 46s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 23s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 14s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 32m 4s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-20170/dev-support/hive-personality.sh | | git revision | master / 1f541b5 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-20170/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-20170/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.3.patch, HIVE-22663.patch > > Time Spent: 0.5h > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17012632#comment-17012632 ] Zoltan Chovan commented on HIVE-22663: -- [~pvary] could you review? > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.patch > > Time Spent: 10m > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17012136#comment-17012136 ] Hive QA commented on HIVE-22663: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12990414/HIVE-22663.2.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:green}SUCCESS:{color} +1 due to 17859 tests passed Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/20131/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/20131/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-20131/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase {noformat} This message is automatically generated. ATTACHMENT ID: 12990414 - PreCommit-HIVE-Build > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.patch > > Time Spent: 10m > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17012076#comment-17012076 ] Hive QA commented on HIVE-22663: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 39s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 7m 51s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 30s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 0m 59s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 16s{color} | {color:blue} standalone-metastore/metastore-server in master has 181 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 4m 4s{color} | {color:blue} ql in master has 1531 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 23s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 27s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 2m 3s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 36s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 36s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 22s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 98 new + 486 unchanged - 79 fixed = 584 total (was 565) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 5m 33s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 21s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 31m 48s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-20131/dev-support/hive-personality.sh | | git revision | master / 36f58c5 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-20131/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-20131/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Labels: pull-request-available > Attachments: HIVE-22663.2.patch, HIVE-22663.patch > > Time Spent: 10m > Remaining Estimate: 0h > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling >
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010552#comment-17010552 ] Zoltan Chovan commented on HIVE-22663: -- Sure, I'll create a PR. Unfortunately the failing tests seem to be related, I'm currently working on fixing those. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22663.patch > > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17010541#comment-17010541 ] Ashutosh Bapat commented on HIVE-22663: --- I looked at the patch. The patch is huge so didn't go into the details. Can you please create a PR so that it's easy to review and provide comments on particular changes if necessary? I have only one comment right now. Please handle the table names in a fashion similar to MetaStoreDirectSql.java. In this case, we might want to go a step further and handle column names in the same fashion. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22663.patch > > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: jdbc:hive2://localhost:1> create > database dumpdb with dbproperties ('repl.source.for'='1,2,3');ERROR : FAILED: > Hive Internal Error: org.apache.hadoop.hive.ql.lockmgr.LockException(Error > communicating with the > metastore)org.apache.hadoop.hive.ql.lockmgr.LockException: Error > communicating with the metastore at > org.apache.hadoop.hive.ql.lockmgr.DbTxnManager.commitTxn(DbTxnManager.java:541) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:687) > at > org.apache.hadoop.hive.ql.Driver.releaseLocksAndCommitOrRollback(Driver.java:653) > at org.apache.hadoop.hive.ql.Driver.runInternal(Driver.java:969) > ... stack trace clipped > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) > at java.lang.Thread.run(Thread.java:748)Caused by: > MetaException(message:Unable to update transaction database > org.postgresql.util.PSQLException: ERROR: relation > "materialization_rebuild_locks" does not exist Position: 13 at > org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440) > at > org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183) > at > org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308) > at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441) at > org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365) at > This happens because the table names in all the queries in TxnHandler.java > (including the one at 1312, which causes this stack trace) are not quoting > the table names. All the tablenames and column names should be quoted there. > Just the change in HIVE-22546 won't suffice. -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009178#comment-17009178 ] Hive QA commented on HIVE-22663: Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12990010/HIVE-22663.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 28 failed/errored test(s), 17852 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcid (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcidAllOp (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcidFailure (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationManagedToAcidFailurePart (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testIncrementalLoadMigrationToAcidWithMoveOptimization (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplTableMigrationWithJsonFormat.testMigrationWithUpgrade (batchId=271) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcid (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcidAllOp (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcidFailure (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationManagedToAcidFailurePart (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testIncrementalLoadMigrationToAcidWithMoveOptimization (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigration.testMigrationWithUpgrade (batchId=260) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testConcurrentOpDuringBootStrapDumpCreateTableReplay (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testConcurrentOpDuringBootStrapDumpInsertOverwrite (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testConcurrentOpDuringBootStrapDumpInsertReplay (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testIncLoadPenFlagPropAlterDB (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testIncLoadPenFlagWithMoveOptimization (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testOnwerPropagation (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testOnwerPropagationInc (batchId=270) org.apache.hadoop.hive.ql.parse.TestReplicationWithTableMigrationEx.testTableLevelDumpMigration (batchId=270) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testForParallelBootstrapLoad (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testMetadataOnlyDump (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testNonParallelBootstrapLoad (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigration.testRetryFailure (batchId=262) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testForParallelBootstrapLoad (batchId=272) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testMetadataOnlyDump (batchId=272) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testNonParallelBootstrapLoad (batchId=272) org.apache.hadoop.hive.ql.parse.TestStatsReplicationScenariosMigrationNoAutogather.testRetryFailure (batchId=272) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/20083/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/20083/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-20083/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 28 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12990010 - PreCommit-HIVE-Build > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >
[jira] [Commented] (HIVE-22663) Quote all table and column names or do not quote any
[ https://issues.apache.org/jira/browse/HIVE-22663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=17009152#comment-17009152 ] Hive QA commented on HIVE-22663: | (x) *{color:red}-1 overall{color}* | \\ \\ || Vote || Subsystem || Runtime || Comment || || || || || {color:brown} Prechecks {color} || | {color:green}+1{color} | {color:green} @author {color} | {color:green} 0m 0s{color} | {color:green} The patch does not contain any @author tags. {color} | || || || || {color:brown} master Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 1m 6s{color} | {color:blue} Maven dependency ordering for branch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 8m 22s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 26s{color} | {color:green} master passed {color} | | {color:green}+1{color} | {color:green} checkstyle {color} | {color:green} 1m 2s{color} | {color:green} master passed {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 1m 12s{color} | {color:blue} standalone-metastore/metastore-server in master has 181 extant Findbugs warnings. {color} | | {color:blue}0{color} | {color:blue} findbugs {color} | {color:blue} 3m 53s{color} | {color:blue} ql in master has 1531 extant Findbugs warnings. {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 18s{color} | {color:green} master passed {color} | || || || || {color:brown} Patch Compile Tests {color} || | {color:blue}0{color} | {color:blue} mvndep {color} | {color:blue} 0m 26s{color} | {color:blue} Maven dependency ordering for patch {color} | | {color:green}+1{color} | {color:green} mvninstall {color} | {color:green} 1m 57s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} compile {color} | {color:green} 1m 28s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javac {color} | {color:green} 1m 28s{color} | {color:green} the patch passed {color} | | {color:red}-1{color} | {color:red} checkstyle {color} | {color:red} 0m 21s{color} | {color:red} standalone-metastore/metastore-server: The patch generated 98 new + 486 unchanged - 79 fixed = 584 total (was 565) {color} | | {color:green}+1{color} | {color:green} whitespace {color} | {color:green} 0m 0s{color} | {color:green} The patch has no whitespace issues. {color} | | {color:green}+1{color} | {color:green} findbugs {color} | {color:green} 5m 26s{color} | {color:green} the patch passed {color} | | {color:green}+1{color} | {color:green} javadoc {color} | {color:green} 1m 19s{color} | {color:green} the patch passed {color} | || || || || {color:brown} Other Tests {color} || | {color:green}+1{color} | {color:green} asflicense {color} | {color:green} 0m 15s{color} | {color:green} The patch does not generate ASF License warnings. {color} | | {color:black}{color} | {color:black} {color} | {color:black} 30m 47s{color} | {color:black} {color} | \\ \\ || Subsystem || Report/Notes || | Optional Tests | asflicense javac javadoc findbugs checkstyle compile | | uname | Linux hiveptest-server-upstream 3.16.0-4-amd64 #1 SMP Debian 3.16.43-2+deb8u5 (2017-09-19) x86_64 GNU/Linux | | Build tool | maven | | Personality | /data/hiveptest/working/yetus_PreCommit-HIVE-Build-20083/dev-support/hive-personality.sh | | git revision | master / 8776087 | | Default Java | 1.8.0_111 | | findbugs | v3.0.0 | | checkstyle | http://104.198.109.242/logs//PreCommit-HIVE-Build-20083/yetus/diff-checkstyle-standalone-metastore_metastore-server.txt | | modules | C: standalone-metastore/metastore-server ql U: . | | Console output | http://104.198.109.242/logs//PreCommit-HIVE-Build-20083/yetus.txt | | Powered by | Apache Yetushttp://yetus.apache.org | This message was automatically generated. > Quote all table and column names or do not quote any > > > Key: HIVE-22663 > URL: https://issues.apache.org/jira/browse/HIVE-22663 > Project: Hive > Issue Type: Bug > Components: HiveServer2, Standalone Metastore >Affects Versions: 4.0.0 >Reporter: Ashutosh Bapat >Assignee: Zoltan Chovan >Priority: Major > Attachments: HIVE-22663.patch > > > The change in HIVE-22546 is causing following stack trace when I run Hive > with PostgreSQL as backend db for the metastore. > 0: jdbc:hive2://localhost:1> create database dumpdb with > ('repl.source.for'='1,2,3');0: jdbc:hive2://localhost:1> create database > dumpdb with ('repl.source.for'='1,2,3');Error: Error while compiling > statement: FAILED: ParseException line 1:28 missing KW_DBPROPERTIES at '(' > near '' (state=42000,code=4)0: