HIVE-17721 : with Postgres rdbms for metastore and dbnotification enabled, hive DDL SQL query fails (Anishek Agarwal reviewed by Thejas Nair)
Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/e46e473e Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/e46e473e Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/e46e473e Branch: refs/heads/hive-14535 Commit: e46e473effbcd84951d9023ae973b1c135e7b0b9 Parents: caf3330 Author: Anishek Agarwal <[email protected]> Authored: Mon Oct 9 11:00:36 2017 +0530 Committer: Anishek Agarwal <[email protected]> Committed: Mon Oct 9 11:00:36 2017 +0530 ---------------------------------------------------------------------- .../src/java/org/apache/hadoop/hive/metastore/ObjectStore.java | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/e46e473e/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java ---------------------------------------------------------------------- diff --git a/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java b/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java index b5e4bf0..ed1c9bc 100644 --- a/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java +++ b/metastore/src/java/org/apache/hadoop/hive/metastore/ObjectStore.java @@ -8525,7 +8525,7 @@ public class ObjectStore implements RawStore, Configurable { } private void lockForUpdate() throws MetaException { - String selectQuery = "select NEXT_EVENT_ID from NOTIFICATION_SEQUENCE"; + String selectQuery = "select \"NEXT_EVENT_ID\" from \"NOTIFICATION_SEQUENCE\""; String selectForUpdateQuery = sqlGenerator.addForUpdateClause(selectQuery); new RetryingExecutor(hiveConf, () -> { Query query = pm.newQuery("javax.jdo.query.SQL", selectForUpdateQuery);
