https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154503#M116959 <P>Ah, good to know. Thanks.</P> Wed, 08 Feb 2017 03:52:31 GMT dhalik 2017-02-08T03:52:31Z https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154499#M116955 <P>Hive metastore schema upgrade from 2.0.0 to 2.1.0 is failing complaining about creation of key_constraints table at "NOT".</P><PRE>etastore connection URL: jdbc:postgresql://dbhost:5432/hive Metastore Connection Driver : org.postgresql.Driver Metastore connection User: hive Starting upgrade metastore schema from version 1.2.0 to 2.1.0 Upgrade script upgrade-1.2.0-to-1.2.1000.postgres.sql Completed upgrade-1.2.0-to-1.2.1000.postgres.sql Upgrade script upgrade-1.2.1000-to-2.0.0.postgres.sql Completed upgrade-1.2.1000-to-2.0.0.postgres.sql Upgrade script upgrade-2.0.0-to-2.1.0.postgres.sql Error: ERROR: syntax error at or near "NOT" Position: 17 (state=42601,code=0)</PRE> Tue, 31 Jan 2017 23:06:31 GMT https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154499#M116955 sriramdboss 2017-01-31T23:06:31Z https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154500#M116956 <P>Figured out the issue. We are running postgres on 8.4. </P><P>The create table if not exists "key constraints" was failing: </P><P>reason: create table if not exists is not supported in postgresql 8.4</P><P>need to change the 033-HIVE-13076.postgres.sql should do the trick.</P><P>waiting for the confirmation. </P> Wed, 01 Feb 2017 02:10:05 GMT https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154500#M116956 sriramdboss 2017-02-01T02:10:05Z https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154501#M116957 <P>Did you end up opening a bug with support on this? I ran into the same issue. Removing the "IF NOT EXISTS" got me past it, but I want to make sure it's reported for future versions. RHEL 6 still comes with 8.4.</P> Wed, 08 Feb 2017 03:29:52 GMT https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154501#M116957 dhalik 2017-02-08T03:29:52Z https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154502#M116958 <A rel="user" href="https://community.cloudera.com/users/10261/dhalik.html" nodeid="10261">@David Halik</A><P>This is not a Bug, basically the 'Releases notes for HDP 2.5.3' does information for the supported metastore databases.</P><P><A href="http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.5.3/bk_release-notes/content/ch01s02s03.html">Release_MR</A></P> Wed, 08 Feb 2017 03:43:36 GMT https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154502#M116958 ssubhas 2017-02-08T03:43:36Z https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154503#M116959 <P>Ah, good to know. Thanks.</P> Wed, 08 Feb 2017 03:52:31 GMT https://community.cloudera.com/t5/Support-Questions/Hive-metastore-upgrade-from-2-0-0-to-2-1-0-failed-Postgres/m-p/154503#M116959 dhalik 2017-02-08T03:52:31Z