Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DB01C10A19 for ; Wed, 29 Apr 2015 00:33:12 +0000 (UTC) Received: (qmail 29511 invoked by uid 500); 29 Apr 2015 00:33:10 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 29449 invoked by uid 500); 29 Apr 2015 00:33:10 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 29440 invoked by uid 99); 29 Apr 2015 00:33:10 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 29 Apr 2015 00:33:10 +0000 Received: from mail-ie0-f169.google.com (mail-ie0-f169.google.com [209.85.223.169]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 167431A010F for ; Wed, 29 Apr 2015 00:33:09 +0000 (UTC) Received: by iebrs15 with SMTP id rs15so31612719ieb.3 for ; Tue, 28 Apr 2015 17:33:09 -0700 (PDT) X-Received: by 10.107.164.209 with SMTP id d78mr23790672ioj.73.1430267589278; Tue, 28 Apr 2015 17:33:09 -0700 (PDT) MIME-Version: 1.0 Received: by 10.107.14.132 with HTTP; Tue, 28 Apr 2015 17:32:49 -0700 (PDT) From: jun aoki Date: Tue, 28 Apr 2015 17:32:49 -0700 Message-ID: Subject: hive metastore's schematool -upgradeSchema on postgres throws an error on CREATE TABLE PART_COL_STATS To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a114220d097cc490514d21fe9 --001a114220d097cc490514d21fe9 Content-Type: text/plain; charset=UTF-8 Hi hive community, I am new to Hive and it may be a stupid question but let me know if you know the answer. I am attempting to upgrade hive metastore schema from 0.12 to 0.14. The whole log is here [2] At the end, VERSION table shows SCHEMA_VERSION 0.14.0. [1] which was 0.12.0 and it seems successful. However, if you take a closer look at the log, you find an error "Error: ERROR: relation "PART_COL_STATS" already exists" The error seems occured from pre-0-upgrade-0.13.0-to-0.14.0.postgres.sql, which is a sole CREATE TABLE command (e.g. https://github.com/apache/hive/blob/branch-0.14/metastore/scripts/upgrade/postgres/pre-0-upgrade-0.13.0-to-0.14.0.postgres.sql), and it is maybe OK to fail that way since my current postgres already has that table. I never tried but mysql's upgrade scripts has "IF NOT EXISTS" on CREATE TABLE, I think the error won't show up . (e.g. https://github.com/apache/hive/blob/master/metastore/scripts/upgrade/mysql/019-HIVE-7784.mysql.sql ) Questions are (a) is this considered as successful upgrade since pre-0-upgrade...sql is a sole create table? (b) Is this a legitimate bug specific to postgres in the hive product (specifically hive metastore schematool and missing "IF NOT EXIST"?) [1] [root@rhel65-4 database_backup]# ; psql -p10432 -d metastore hive -c'\d "DBS"' ; psql -p10432 -d metastore hive -c'SELECT * FROM "VERSION"' ;psql -p10432 -d metastore hive -c'\d "PART_COL_STATS"' psql -p10432 -d metastore hive -c'SELECT * FROM "VERSION"' VER_ID | SCHEMA_VERSION | VERSION_COMMENT --------+----------------+----------------------------- 1 | 0.14.0 | Hive release version 0.14.0 (1 row) [2] The whole log on upgradeScema [root@rhel65-4 hive]# su -s /bin/bash - hdfs -c 'HIVE_CONF_DIR=/etc/hive/conf.server /usr/phd/current/hive-metastore/bin/schematool -upgradeSchema -dbType postgres -verbose' 15/04/28 16:28:09 WARN conf.HiveConf: HiveConf of name hive.optimize.mapjoin.mapreduce does not exist 15/04/28 16:28:09 WARN conf.HiveConf: HiveConf of name hive.heapsize does not exist 15/04/28 16:28:09 WARN conf.HiveConf: HiveConf of name hive.server2.enable.impersonation does not exist 15/04/28 16:28:09 WARN conf.HiveConf: HiveConf of name hive.auto.convert.sortmerge.join.noconditionaltask does not exist Metastore connection URL: jdbc:postgresql://rhel65-4.localdomain:10432/metastore Metastore Connection Driver : org.postgresql.Driver Metastore connection User: hive Starting upgrade metastore schema from version 0.12.0 to 0.14.0 Upgrade script upgrade-0.12.0-to-0.13.0.postgres.sql Looking for pre-0-upgrade-0.12.0-to-0.13.0.postgres.sql in /usr/phd/3.0.0.0-247/hive/scripts/metastore/upgrade/postgres Connecting to jdbc:postgresql://rhel65-4.localdomain:10432/metastore Connected to: PostgreSQL (version 8.4.18) Driver: PostgreSQL Native Driver (version PostgreSQL 8.4 JDBC4 (build 701)) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:postgresql://rhel65-4.localdomain:104> !autocommit on Autocommit status: true 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE LANGUAGE plpgsql Error: ERROR: language "plpgsql" already exists (state=42710,code=0) Closing: 0: jdbc:postgresql://rhel65-4.localdomain:10432/metastore Warning in pre-upgrade script pre-0-upgrade-0.12.0-to-0.13.0.postgres.sql: Schema script failed, errorcode 2 java.io.IOException: Schema script failed, errorcode 2 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:380) at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:353) at org.apache.hive.beeline.HiveSchemaTool.runPreUpgrade(HiveSchemaTool.java:323) at org.apache.hive.beeline.HiveSchemaTool.doUpgrade(HiveSchemaTool.java:243) at org.apache.hive.beeline.HiveSchemaTool.doUpgrade(HiveSchemaTool.java:217) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:493) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Looking for pre-1-upgrade-0.12.0-to-0.13.0.postgres.sql in /usr/phd/3.0.0.0-247/hive/scripts/metastore/upgrade/postgres Connecting to jdbc:postgresql://rhel65-4.localdomain:10432/metastore Connected to: PostgreSQL (version 8.4.18) Driver: PostgreSQL Native Driver (version PostgreSQL 8.4 JDBC4 (build 701)) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:postgresql://rhel65-4.localdomain:104> !autocommit on Autocommit status: true 0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT 'Upgrading MetaStore schema from 0.12.0 to 0.13.0' +---------------------------------------------------+--+ | ?column? | +---------------------------------------------------+--+ | Upgrading MetaStore schema from 0.12.0 to 0.13.0 | +---------------------------------------------------+--+ 1 row selected (0.02 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT '< HIVE-6386 Database should have an owner >' +----------------------------------------------+--+ | ?column? | +----------------------------------------------+--+ | < HIVE-6386 Database should have an owner > | +----------------------------------------------+--+ 1 row selected (0.007 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> ALTER TABLE "DBS" ADD COLUMN "OWNER_NAME" character varying(128) No rows affected (0.007 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> ALTER TABLE "DBS" ADD COLUMN "OWNER_TYPE" character varying(10) No rows affected (0.006 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT '< HIVE-6458 Add schema upgrade scripts for metastore changes related to permanent functions >' +------------------------------------------------------------------------------------------------+--+ | ?column? | +------------------------------------------------------------------------------------------------+--+ | < HIVE-6458 Add schema upgrade scripts for metastore changes related to permanent functions > | +------------------------------------------------------------------------------------------------+--+ 1 row selected (0.006 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE "FUNCS" ( "FUNC_ID" BIGINT NOT NULL, "CLASS_NAME" VARCHAR(4000), "CREATE_TIME" INTEGER NOT NULL, "DB_ID" BIGINT, "FUNC_NAME" VARCHAR(128), "FUNC_TYPE" INTEGER NOT NULL, "OWNER_NAME" VARCHAR(128), "OWNER_TYPE" VARCHAR(10), PRIMARY KEY ("FUNC_ID") ) No rows affected (0.028 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE UNIQUE INDEX "UNIQUEFUNCTION" ON "FUNCS" ("FUNC_NAME", "DB_ID") No rows affected (0.008 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE INDEX "FUNCS_N49" ON "FUNCS" ("DB_ID") No rows affected (0.004 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> ALTER TABLE ONLY "FUNCS" ADD CONSTRAINT "FUNCS_FK1" FOREIGN KEY ("DB_ID") REFERENCES "DBS" ("DB_ID") DEFERRABLE No rows affected (0.004 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE "FUNC_RU" ( "FUNC_ID" BIGINT NOT NULL, "RESOURCE_TYPE" INTEGER NOT NULL, "RESOURCE_URI" VARCHAR(4000), "INTEGER_IDX" INTEGER NOT NULL, PRIMARY KEY ("FUNC_ID", "INTEGER_IDX") ) No rows affected (0.007 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE INDEX "FUNC_RU_N49" ON "FUNC_RU" ("FUNC_ID") No rows affected (0.005 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> ALTER TABLE ONLY "FUNC_RU" ADD CONSTRAINT "FUNC_RU_FK1" FOREIGN KEY ("FUNC_ID") REFERENCES "FUNCS" ("FUNC_ID") DEFERRABLE No rows affected (0.002 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT '< HIVE-6757 Remove deprecated parquet classes from outside of org.apache package >' +-------------------------------------------------------------------------------------+--+ | ?column? | +-------------------------------------------------------------------------------------+--+ | < HIVE-6757 Remove deprecated parquet classes from outside of org.apache package > | +-------------------------------------------------------------------------------------+--+ 1 row selected (0.001 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> UPDATE "SDS" SET "INPUT_FORMAT" = 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' WHERE "INPUT_FORMAT"= 'parquet.hive.DeprecatedParquetInputFormat' or "INPUT_FORMAT" = 'parquet.hive.MapredParquetInputFormat' No rows affected (0.003 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> UPDATE "SDS" SET "OUTPUT_FORMAT" = 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' WHERE "OUTPUT_FORMAT" = 'parquet.hive.DeprecatedParquetOutputFormat' or "OUTPUT_FORMAT" = 'parquet.hive.MapredParquetOutputFormat' No rows affected (0.001 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> UPDATE "SERDES" SET "SLIB" ='org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' WHERE "SLIB" = 'parquet.hive.serde.ParquetHiveSerDe' No rows affected (0.001 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE TXNS ( TXN_ID bigint PRIMARY KEY, TXN_STATE char(1) NOT NULL, TXN_STARTED bigint NOT NULL, TXN_LAST_HEARTBEAT bigint NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST varchar(128) NOT NULL ) No rows affected (0.009 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE TXN_COMPONENTS ( TC_TXNID bigint REFERENCES TXNS (TXN_ID), TC_DATABASE varchar(128) NOT NULL, TC_TABLE varchar(128), TC_PARTITION varchar(767) DEFAULT NULL ) No rows affected (0.012 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNID bigint, CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(128), CTC_PARTITION varchar(767) ) No rows affected (0.009 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE NEXT_TXN_ID ( NTXN_NEXT bigint NOT NULL ) No rows affected (0.003 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> INSERT INTO NEXT_TXN_ID VALUES(1) 1 row affected (0.004 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE HIVE_LOCKS ( HL_LOCK_EXT_ID bigint NOT NULL, HL_LOCK_INT_ID bigint NOT NULL, HL_TXNID bigint, HL_DB varchar(128) NOT NULL, HL_TABLE varchar(128), HL_PARTITION varchar(767) DEFAULT NULL, HL_LOCK_STATE char(1) NOT NULL, HL_LOCK_TYPE char(1) NOT NULL, HL_LAST_HEARTBEAT bigint NOT NULL, HL_ACQUIRED_AT bigint, HL_USER varchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, PRIMARY KEY(HL_LOCK_EXT_ID, HL_LOCK_INT_ID) ) No rows affected (0.017 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE INDEX HL_TXNID_INDEX ON HIVE_LOCKS USING hash (HL_TXNID) No rows affected (0.003 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE NEXT_LOCK_ID ( NL_NEXT bigint NOT NULL ) No rows affected (0.002 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> INSERT INTO NEXT_LOCK_ID VALUES(1) 1 row affected (0.002 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE COMPACTION_QUEUE ( CQ_ID bigint PRIMARY KEY, CQ_DATABASE varchar(128) NOT NULL, CQ_TABLE varchar(128) NOT NULL, CQ_PARTITION varchar(767), CQ_STATE char(1) NOT NULL, CQ_TYPE char(1) NOT NULL, CQ_WORKER_ID varchar(128), CQ_START bigint, CQ_RUN_AS varchar(128) ) No rows affected (0.023 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT bigint NOT NULL ) No rows affected (0.005 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1) 1 row affected (0.003 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> UPDATE "VERSION" SET "SCHEMA_VERSION"='0.13.0', "VERSION_COMMENT"='Hive release version 0.13.0' where "VER_ID"=1 1 row affected (0.006 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT 'Finished upgrading MetaStore schema from 0.12.0 to 0.13.0' +------------------------------------------------------------+--+ | ?column? | +------------------------------------------------------------+--+ | Finished upgrading MetaStore schema from 0.12.0 to 0.13.0 | +------------------------------------------------------------+--+ 1 row selected (0.001 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> !closeall Closing: 0: jdbc:postgresql://rhel65-4.localdomain:10432/metastore beeline> Completed upgrade-0.12.0-to-0.13.0.postgres.sql Upgrade script upgrade-0.13.0-to-0.14.0.postgres.sql Looking for pre-0-upgrade-0.13.0-to-0.14.0.postgres.sql in /usr/phd/3.0.0.0-247/hive/scripts/metastore/upgrade/postgres Connecting to jdbc:postgresql://rhel65-4.localdomain:10432/metastore Connected to: PostgreSQL (version 8.4.18) Driver: PostgreSQL Native Driver (version PostgreSQL 8.4 JDBC4 (build 701)) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:postgresql://rhel65-4.localdomain:104> !autocommit on Autocommit status: true 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE "PART_COL_STATS" ( "CS_ID" bigint NOT NULL, "DB_NAME" character varying(128) DEFAULT NULL::character varying, "TABLE_NAME" character varying(128) DEFAULT NULL::character varying, "PARTITION_NAME" character varying(767) DEFAULT NULL::character varying, "COLUMN_NAME" character varying(128) DEFAULT NULL::character varying, "COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying, "PART_ID" bigint NOT NULL, "LONG_LOW_VALUE" bigint, "LONG_HIGH_VALUE" bigint, "DOUBLE_LOW_VALUE" double precision, "DOUBLE_HIGH_VALUE" double precision, "BIG_DECIMAL_LOW_VALUE" character varying(4000) DEFAULT NULL::character varying, "BIG_DECIMAL_HIGH_VALUE" character varying(4000) DEFAULT NULL::character varying, "NUM_NULLS" bigint NOT NULL, "NUM_DISTINCTS" bigint, "AVG_COL_LEN" double precision, "MAX_COL_LEN" bigint, "NUM_TRUES" bigint, "NUM_FALSES" bigint, "LAST_ANALYZED" bigint NOT NULL ) Error: ERROR: relation "PART_COL_STATS" already exists (state=42P07,code=0) Closing: 0: jdbc:postgresql://rhel65-4.localdomain:10432/metastore Warning in pre-upgrade script pre-0-upgrade-0.13.0-to-0.14.0.postgres.sql: Schema script failed, errorcode 2 java.io.IOException: Schema script failed, errorcode 2 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:380) at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:353) at org.apache.hive.beeline.HiveSchemaTool.runPreUpgrade(HiveSchemaTool.java:323) at org.apache.hive.beeline.HiveSchemaTool.doUpgrade(HiveSchemaTool.java:243) at org.apache.hive.beeline.HiveSchemaTool.doUpgrade(HiveSchemaTool.java:217) at org.apache.hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:493) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.apache.hadoop.util.RunJar.run(RunJar.java:221) at org.apache.hadoop.util.RunJar.main(RunJar.java:136) Looking for pre-1-upgrade-0.13.0-to-0.14.0.postgres.sql in /usr/phd/3.0.0.0-247/hive/scripts/metastore/upgrade/postgres Connecting to jdbc:postgresql://rhel65-4.localdomain:10432/metastore Connected to: PostgreSQL (version 8.4.18) Driver: PostgreSQL Native Driver (version PostgreSQL 8.4 JDBC4 (build 701)) Transaction isolation: TRANSACTION_READ_COMMITTED 0: jdbc:postgresql://rhel65-4.localdomain:104> !autocommit on Autocommit status: true 0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT 'Upgrading MetaStore schema from 0.13.0 to 0.14.0' +---------------------------------------------------+--+ | ?column? | +---------------------------------------------------+--+ | Upgrading MetaStore schema from 0.13.0 to 0.14.0 | +---------------------------------------------------+--+ 1 row selected (0.001 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE INDEX "PCS_STATS_IDX" ON "PART_COL_STATS" USING btree ("DB_NAME","TABLE_NAME","COLUMN_NAME","PARTITION_NAME") No rows affected (0.009 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> UPDATE "VERSION" SET "SCHEMA_VERSION"='0.14.0', "VERSION_COMMENT"='Hive release version 0.14.0' where "VER_ID"=1 1 row affected (0.003 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT 'Finished upgrading MetaStore schema from 0.13.0 to 0.14.0' +------------------------------------------------------------+--+ | ?column? | +------------------------------------------------------------+--+ | Finished upgrading MetaStore schema from 0.13.0 to 0.14.0 | +------------------------------------------------------------+--+ 1 row selected (0.007 seconds) 0: jdbc:postgresql://rhel65-4.localdomain:104> !closeall Closing: 0: jdbc:postgresql://rhel65-4.localdomain:10432/metastore beeline> Completed upgrade-0.13.0-to-0.14.0.postgres.sql schemaTool completed -- -jun --001a114220d097cc490514d21fe9 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi hive community,

I am new to Hive and= it may be a stupid question but let me know if you know the answer.=C2=A0<= /div>

I am attempting to upgrade hive metastore schema f= rom 0.12 to 0.14. The whole log is here [2]

At the= end, VERSION table shows SCHEMA_VERSION 0.14.0. [1] which was 0.12.0 and i= t seems successful. However, if you take a closer look at the log, you find= an error "Error: ERROR: relation &qu= ot;PART_COL_STATS" already exists"

The error seems occured from=C2=A0pre-0-upgrade-0.13.0-to-0.14.0.postgre= s.sql, which is a sole CREATE TABLE command (e.g.=C2=A0https://github.com/apache/hive/= blob/branch-0.14/metastore/scripts/upgrade/postgres/pre-0-upgrade-0.13.0-to= -0.14.0.postgres.sql), and it is maybe OK to fail that way since my cur= rent postgres already has that table.

I never trie= d but mysql's upgrade scripts has "IF NOT EXISTS" on CREATE T= ABLE, I think the error won't show up . (e.g.=C2=A0https://github.com/apache/hive/blob/master/metastore/script= s/upgrade/mysql/019-HIVE-7784.mysql.sql)=C2=A0


Questions are=C2=A0
(a) is this considered as suc= cessful upgrade since pre-0-upgrade...sql is a sole create table?
(b) Is this a legitimate bug specific to postgres in the hive product (spe= cifically hive metastore schematool and missing "IF NOT EXIST"?)<= /div>




[1]
[root@rhel65-4 database_backup]# ; psql -p10432 -d metastore = hive -c'\d "DBS"' ; psql -p10432 -d metastore hive -c'= ;SELECT * FROM "VERSION"' ;psql -p10432 -d metastore hive -c&= #39;\d "PART_COL_STATS"'
psql -p10432 -d metastore = hive -c'SELECT * FROM "VERSION"'
=C2=A0VER_ID |= SCHEMA_VERSION | =C2=A0 =C2=A0 =C2=A0 VERSION_COMMENT
--------+-= ---------------+-----------------------------
=C2=A0 =C2=A0 =C2= =A0 1 | 0.14.0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 | Hive release version 0.14.0
(1 row)



[2] The whole log on upgradeScema
[root@rhel65-4 h= ive]# su -s /bin/bash - hdfs -c 'HIVE_CONF_DIR=3D/etc/hive/conf.server = /usr/phd/current/hive-metastore/bin/schematool -upgradeSchema -dbType postg= res -verbose'
15/04/28 16:28:09 WARN conf.HiveConf: HiveConf = of name hive.optimize.mapjoin.mapreduce does not exist
15/04/28 1= 6:28:09 WARN conf.HiveConf: HiveConf of name hive.heapsize does not exist
15/04/28 16:28:09 WARN conf.HiveConf: HiveConf of name hive.server= 2.enable.impersonation does not exist
15/04/28 16:28:09 WARN conf= .HiveConf: HiveConf of name hive.auto.convert.sortmerge.join.noconditionalt= ask does not exist
Metastore connection URL: =C2=A0 =C2=A0 =C2=A0= =C2=A0jdbc:postgresql://rhel65-4.localdomain:10432/metastore
Met= astore Connection Driver : =C2=A0 =C2=A0org.postgresql.Driver
Met= astore connection User: =C2=A0 =C2=A0 =C2=A0 hive
Starting upgrad= e metastore schema from version 0.12.0 to 0.14.0
Upgrade script u= pgrade-0.12.0-to-0.13.0.postgres.sql
Looking for pre-0-upgrade-0.= 12.0-to-0.13.0.postgres.sql in /usr/phd/3.0.0.0-247/hive/scripts/metastore/= upgrade/postgres
Connecting to jdbc:postgresql://rhel65-4.localdo= main:10432/metastore
Connected to: PostgreSQL (version 8.4.18)
Driver: PostgreSQL Native Driver (version PostgreSQL 8.4 JDBC4 (bui= ld 701))
Transaction isolation: TRANSACTION_READ_COMMITTED
<= div>0: jdbc:postgresql://rhel65-4.localdomain:104> !autocommit on
<= div>Autocommit status: true
0: jdbc:postgresql://rhel65-4.localdo= main:104> CREATE LANGUAGE plpgsql
Error: ERROR: language "= ;plpgsql" already exists (state=3D42710,code=3D0)

=
Closing: 0: jdbc:postgresql://rhel65-4.localdomain:10432/metastore
Warning in pre-upgrade script pre-0-upgrade-0.12.0-to-0.13.0.postgre= s.sql: Schema script failed, errorcode 2
java.io.IOException: Sch= ema script failed, errorcode 2
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org= .apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.java:380)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.HiveSchemaToo= l.runBeeLine(HiveSchemaTool.java:353)
=C2=A0 =C2=A0 =C2=A0 =C2=A0= at org.apache.hive.beeline.HiveSchemaTool.runPreUpgrade(HiveSchemaTool.jav= a:323)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.Hiv= eSchemaTool.doUpgrade(HiveSchemaTool.java:243)
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 at org.apache.hive.beeline.HiveSchemaTool.doUpgrade(HiveSchemaTo= ol.java:217)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeli= ne.HiveSchemaTool.main(HiveSchemaTool.java:493)
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at sun.reflect.NativeMethodAccessorImp= l.invoke(NativeMethodAccessorImpl.java:57)
=C2=A0 =C2=A0 =C2=A0 = =C2=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodA= ccessorImpl.java:43)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at java.lang.ref= lect.Method.invoke(Method.java:606)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 a= t org.apache.hadoop.util.RunJar.run(RunJar.java:221)
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Looking for pre-1-upgrade-0.12.0-to-0.13.0.postgres.sql in /usr/phd= /3.0.0.0-247/hive/scripts/metastore/upgrade/postgres
Connecting t= o jdbc:postgresql://rhel65-4.localdomain:10432/metastore
Connecte= d to: PostgreSQL (version 8.4.18)
Driver: PostgreSQL Native Drive= r (version PostgreSQL 8.4 JDBC4 (build 701))
Transaction isolatio= n: TRANSACTION_READ_COMMITTED
0: jdbc:postgresql://rhel65-4.local= domain:104> !autocommit on
Autocommit status: true
0= : jdbc:postgresql://rhel65-4.localdomain:104> SELECT 'Upgrading Meta= Store schema from 0.12.0 to 0.13.0'
+------------------------= ---------------------------+--+
| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ?column? =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|
+-------------= --------------------------------------+--+
| Upgrading MetaStore = schema from 0.12.0 to 0.13.0 =C2=A0|
+---------------------------= ------------------------+--+
1 row selected (0.02 seconds)
<= div>0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT '< HIVE= -6386 Database should have an owner >'
+------------------= ----------------------------+--+
| =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ?column? =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
+------------------------------= ----------------+--+
| < HIVE-6386 Database should have an own= er > =C2=A0|
+----------------------------------------------+-= -+
1 row selected (0.007 seconds)
0: jdbc:postgresql://= rhel65-4.localdomain:104> ALTER TABLE "DBS" ADD COLUMN "O= WNER_NAME" character varying(128)
No rows affected (0.007 se= conds)
0: jdbc:postgresql://rhel65-4.localdomain:104> ALTER TA= BLE "DBS" ADD COLUMN "OWNER_TYPE" character varying(10)=
No rows affected (0.006 seconds)
0: jdbc:postgresql://= rhel65-4.localdomain:104> SELECT '< HIVE-6458 Add schema upgrade = scripts for metastore changes related to permanent functions >'
+--------------------------------------------------------------------= ----------------------------+--+
| =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0?column? =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|
+-----------------------------------------------------------------------= -------------------------+--+
| < HIVE-6458 Add schema upgrade= scripts for metastore changes related to permanent functions > =C2=A0|<= /div>
+----------------------------------------------------------------= --------------------------------+--+
1 row selected (0.006 second= s)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE= "FUNCS" ( "FUNC_ID" BIGINT NOT NULL, "CLASS_NAME&= quot; VARCHAR(4000), "CREATE_TIME" INTEGER NOT NULL, "DB_ID&= quot; BIGINT, "FUNC_NAME" VARCHAR(128), "FUNC_TYPE" INT= EGER NOT NULL, "OWNER_NAME" VARCHAR(128), "OWNER_TYPE" = VARCHAR(10), PRIMARY KEY ("FUNC_ID") )
No rows affected= (0.028 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104>= ; CREATE UNIQUE INDEX "UNIQUEFUNCTION" ON "FUNCS" (&quo= t;FUNC_NAME", "DB_ID")
No rows affected (0.008 sec= onds)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE IN= DEX "FUNCS_N49" ON "FUNCS" ("DB_ID")
No rows affected (0.004 seconds)
0: jdbc:postgresql://rhel65-4.= localdomain:104> ALTER TABLE ONLY "FUNCS" ADD CONSTRAINT "= ;FUNCS_FK1" FOREIGN KEY ("DB_ID") REFERENCES "DBS"= ("DB_ID") DEFERRABLE
No rows affected (0.004 seconds)<= /div>
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE &q= uot;FUNC_RU" ( "FUNC_ID" BIGINT NOT NULL, "RESOURCE_TYP= E" INTEGER NOT NULL, "RESOURCE_URI" VARCHAR(4000), "INT= EGER_IDX" INTEGER NOT NULL, PRIMARY KEY ("FUNC_ID", "IN= TEGER_IDX") )
No rows affected (0.007 seconds)
0: = jdbc:postgresql://rhel65-4.localdomain:104> CREATE INDEX "FUNC_RU_N= 49" ON "FUNC_RU" ("FUNC_ID")
No rows aff= ected (0.005 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:1= 04> ALTER TABLE ONLY "FUNC_RU" ADD CONSTRAINT "FUNC_RU_FK= 1" FOREIGN KEY ("FUNC_ID") REFERENCES "FUNCS" (&qu= ot;FUNC_ID") DEFERRABLE
No rows affected (0.002 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT '< H= IVE-6757 Remove deprecated parquet classes from outside of org.apache packa= ge >'
+---------------------------------------------------= ----------------------------------+--+
| =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0?column? =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 |
+----------------------------------= ---------------------------------------------------+--+
| < HI= VE-6757 Remove deprecated parquet classes from outside of org.apache packag= e > =C2=A0|
+-------------------------------------------------= ------------------------------------+--+
1 row selected (0.001 se= conds)
0: jdbc:postgresql://rhel65-4.localdomain:104> UPDATE &= quot;SDS" SET "INPUT_FORMAT" =3D 'org.apache.hadoop.hive= .ql.io.parquet.MapredParquetInputFormat' WHERE "INPUT_FORMAT"= =3D 'parquet.hive.DeprecatedParquetInputFormat' or "INPUT_FORM= AT" =3D 'parquet.hive.MapredParquetInputFormat'
No r= ows affected (0.003 seconds)
0: jdbc:postgresql://rhel65-4.locald= omain:104> UPDATE "SDS" SET "OUTPUT_FORMAT" =3D '= ;org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' WHERE = "OUTPUT_FORMAT" =3D 'parquet.hive.DeprecatedParquetOutputForm= at' =C2=A0or "OUTPUT_FORMAT" =3D 'parquet.hive.MapredParq= uetOutputFormat'
No rows affected (0.001 seconds)
0= : jdbc:postgresql://rhel65-4.localdomain:104> UPDATE "SERDES" = SET "SLIB" =3D'org.apache.hadoop.hive.ql.io.parquet.serde.Par= quetHiveSerDe' WHERE "SLIB" =3D 'parquet.hive.serde.Parqu= etHiveSerDe'
No rows affected (0.001 seconds)
0: jd= bc:postgresql://rhel65-4.localdomain:104> CREATE TABLE TXNS ( TXN_ID big= int PRIMARY KEY, TXN_STATE char(1) NOT NULL, TXN_STARTED bigint NOT NULL, T= XN_LAST_HEARTBEAT bigint NOT NULL, TXN_USER varchar(128) NOT NULL, TXN_HOST= varchar(128) NOT NULL )
No rows affected (0.009 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE TXN_COMPO= NENTS ( TC_TXNID bigint REFERENCES TXNS (TXN_ID), TC_DATABASE varchar(128) = NOT NULL, TC_TABLE varchar(128), TC_PARTITION varchar(767) DEFAULT NULL )
No rows affected (0.012 seconds)
0: jdbc:postgresql://rh= el65-4.localdomain:104> CREATE TABLE COMPLETED_TXN_COMPONENTS ( CTC_TXNI= D bigint, CTC_DATABASE varchar(128) NOT NULL, CTC_TABLE varchar(128), CTC_P= ARTITION varchar(767) )
No rows affected (0.009 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE NEXT_TXN_I= D ( NTXN_NEXT bigint NOT NULL )
No rows affected (0.003 seconds)<= /div>
0: jdbc:postgresql://rhel65-4.localdomain:104> INSERT INTO NEX= T_TXN_ID VALUES(1)
1 row affected (0.004 seconds)
0: jd= bc:postgresql://rhel65-4.localdomain:104> CREATE TABLE HIVE_LOCKS ( HL_L= OCK_EXT_ID bigint NOT NULL, HL_LOCK_INT_ID bigint NOT NULL, HL_TXNID bigint= , HL_DB varchar(128) NOT NULL, HL_TABLE varchar(128), HL_PARTITION varchar(= 767) DEFAULT NULL, HL_LOCK_STATE char(1) NOT NULL, HL_LOCK_TYPE char(1) NOT= NULL, HL_LAST_HEARTBEAT bigint NOT NULL, HL_ACQUIRED_AT bigint, HL_USER va= rchar(128) NOT NULL, HL_HOST varchar(128) NOT NULL, PRIMARY KEY(HL_LOCK_EXT= _ID, HL_LOCK_INT_ID) )
No rows affected (0.017 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE INDEX HL_TXNID_IN= DEX ON HIVE_LOCKS USING hash (HL_TXNID)
No rows affected (0.003 s= econds)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE = TABLE NEXT_LOCK_ID ( NL_NEXT bigint NOT NULL )
No rows affected (= 0.002 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104> = INSERT INTO NEXT_LOCK_ID VALUES(1)
1 row affected (0.002 seconds)=
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE C= OMPACTION_QUEUE ( CQ_ID bigint PRIMARY KEY, CQ_DATABASE varchar(128) NOT NU= LL, CQ_TABLE varchar(128) NOT NULL, CQ_PARTITION varchar(767), CQ_STATE cha= r(1) NOT NULL, CQ_TYPE char(1) NOT NULL, CQ_WORKER_ID varchar(128), CQ_STAR= T bigint, CQ_RUN_AS varchar(128) )
No rows affected (0.023 second= s)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE= NEXT_COMPACTION_QUEUE_ID ( NCQ_NEXT bigint NOT NULL )
No rows af= fected (0.005 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:= 104> INSERT INTO NEXT_COMPACTION_QUEUE_ID VALUES(1)
1 row affe= cted (0.003 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:10= 4> UPDATE "VERSION" SET "SCHEMA_VERSION"=3D'0.13= .0', "VERSION_COMMENT"=3D'Hive release version 0.13.0'= ; where "VER_ID"=3D1
1 row affected (0.006 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT 'Finish= ed upgrading MetaStore schema from 0.12.0 to 0.13.0'
+-------= -----------------------------------------------------+--+
| =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0?column? =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|
+------------------------= ------------------------------------+--+
| Finished upgrading Met= aStore schema from 0.12.0 to 0.13.0 =C2=A0|
+--------------------= ----------------------------------------+--+
1 row selected (0.00= 1 seconds)
0: jdbc:postgresql://rhel65-4.localdomain:104> !clo= seall
Closing: 0: jdbc:postgresql://rhel65-4.localdomain:10432/me= tastore
beeline>
Completed upgrade-0.12.0-to-0.13.0.= postgres.sql
Upgrade script upgrade-0.13.0-to-0.14.0.postgres.sql=
Looking for pre-0-upgrade-0.13.0-to-0.14.0.postgres.sql in /usr/= phd/3.0.0.0-247/hive/scripts/metastore/upgrade/postgres
Connectin= g to jdbc:postgresql://rhel65-4.localdomain:10432/metastore
Conne= cted to: PostgreSQL (version 8.4.18)
Driver: PostgreSQL Native Dr= iver (version PostgreSQL 8.4 JDBC4 (build 701))
Transaction isola= tion: TRANSACTION_READ_COMMITTED
0: jdbc:postgresql://rhel65-4.lo= caldomain:104> !autocommit on
Autocommit status: true
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE TABLE "PART= _COL_STATS" ( "CS_ID" bigint NOT NULL, "DB_NAME" c= haracter varying(128) DEFAULT NULL::character varying, "TABLE_NAME&quo= t; character varying(128) DEFAULT NULL::character varying, "PARTITION_= NAME" character varying(767) DEFAULT NULL::character varying, "CO= LUMN_NAME" character varying(128) DEFAULT NULL::character varying, &qu= ot;COLUMN_TYPE" character varying(128) DEFAULT NULL::character varying= , "PART_ID" bigint NOT NULL, "LONG_LOW_VALUE" bigint, &= quot;LONG_HIGH_VALUE" bigint, "DOUBLE_LOW_VALUE" double prec= ision, "DOUBLE_HIGH_VALUE" double precision, "BIG_DECIMAL_LO= W_VALUE" character varying(4000) DEFAULT NULL::character varying, &quo= t;BIG_DECIMAL_HIGH_VALUE" character varying(4000) DEFAULT NULL::charac= ter varying, "NUM_NULLS" bigint NOT NULL, "NUM_DISTINCTS&quo= t; bigint, "AVG_COL_LEN" double precision, "MAX_COL_LEN"= ; bigint, "NUM_TRUES" bigint, "NUM_FALSES" bigint, &quo= t;LAST_ANALYZED" bigint NOT NULL )
Error: ERROR: relation &q= uot;PART_COL_STATS" already exists (state=3D42P07,code=3D0)
=
Closing: 0: jdbc:postgresql://rhel65-4.localdomain:10432/met= astore
Warning in pre-upgrade script pre-0-upgrade-0.13.0-to-0.14= .0.postgres.sql: Schema script failed, errorcode 2
java.io.IOExce= ption: Schema script failed, errorcode 2
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 at org.apache.hive.beeline.HiveSchemaTool.runBeeLine(HiveSchemaTool.jav= a:380)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.Hiv= eSchemaTool.runBeeLine(HiveSchemaTool.java:353)
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 at org.apache.hive.beeline.HiveSchemaTool.runPreUpgrade(HiveSche= maTool.java:323)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.b= eeline.HiveSchemaTool.doUpgrade(HiveSchemaTool.java:243)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at org.apache.hive.beeline.HiveSchemaTool.doUpgrade(Hi= veSchemaTool.java:217)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.= hive.beeline.HiveSchemaTool.main(HiveSchemaTool.java:493)
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native= Method)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at sun.reflect.NativeMethodA= ccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
=C2=A0 =C2= =A0 =C2=A0 =C2=A0 at sun.reflect.DelegatingMethodAccessorImpl.invoke(Delega= tingMethodAccessorImpl.java:43)
=C2=A0 =C2=A0 =C2=A0 =C2=A0 at ja= va.lang.reflect.Method.invoke(Method.java:606)
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 at org.apache.hadoop.util.RunJar.main(RunJar.ja= va:136)
Looking for pre-1-upgrade-0.13.0-to-0.14.0.postgres.sql i= n /usr/phd/3.0.0.0-247/hive/scripts/metastore/upgrade/postgres
Co= nnecting to jdbc:postgresql://rhel65-4.localdomain:10432/metastore
Connected to: PostgreSQL (version 8.4.18)
Driver: PostgreSQL Na= tive Driver (version PostgreSQL 8.4 JDBC4 (build 701))
Transactio= n isolation: TRANSACTION_READ_COMMITTED
0: jdbc:postgresql://rhel= 65-4.localdomain:104> !autocommit on
Autocommit status: true
0: jdbc:postgresql://rhel65-4.localdomain:104> SELECT 'Upgr= ading MetaStore schema from 0.13.0 to 0.14.0'
+--------------= -------------------------------------+--+
| =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ?column? =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|
+---= ------------------------------------------------+--+
| Upgrading = MetaStore schema from 0.13.0 to 0.14.0 =C2=A0|
+-----------------= ----------------------------------+--+
1 row selected (0.001 seco= nds)
0: jdbc:postgresql://rhel65-4.localdomain:104> CREATE IND= EX "PCS_STATS_IDX" ON "PART_COL_STATS" USING btree (&qu= ot;DB_NAME","TABLE_NAME","COLUMN_NAME","PARTI= TION_NAME")
No rows affected (0.009 seconds)
0: jd= bc:postgresql://rhel65-4.localdomain:104> UPDATE "VERSION" SET= "SCHEMA_VERSION"=3D'0.14.0', "VERSION_COMMENT"= =3D'Hive release version 0.14.0' where "VER_ID"=3D1
=
1 row affected (0.003 seconds)
0: jdbc:postgresql://rhel65-4= .localdomain:104> SELECT 'Finished upgrading MetaStore schema from 0= .13.0 to 0.14.0'
+-------------------------------------------= -----------------+--+
| =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0?column? =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0|<= /div>
+------------------------------------------------------------+--+=
| Finished upgrading MetaStore schema from 0.13.0 to 0.14.0 =C2= =A0|
+-----------------------------------------------------------= -+--+
1 row selected (0.007 seconds)
0: jdbc:postgresql= ://rhel65-4.localdomain:104> !closeall
Closing: 0: jdbc:postgr= esql://rhel65-4.localdomain:10432/metastore
beeline>
Completed upgrade-0.13.0-to-0.14.0.postgres.sql
schemaTool compl= eted

--
-jun
--001a114220d097cc490514d21fe9--