question Re: upgrade hive schema failed in Support Questions

question Re: upgrade hive schema failed in Support Questions https://community.cloudera.com/t5/Support-Questions/upgrade-hive-schema-failed/m-p/51294#M5926 with your command, it shows:17/02/22 10:19:19 WARN conf.HiveConf: HiveConf of name hive.metastore.local does not exist Metastore connection URL:        jdbc:derby:;databaseName=metastore_db;create=true Metastore Connection Driver :    org.apache.derby.jdbc.EmbeddedDriver Metastore connection User:       APP Hive distribution version:       1.1.0 org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. *** schemaTool failed *** so we would go for hive 1.1.0, and the old version is 0.13. I'm not sure whether it matters. and besides, i can see the error from the log where it hit: <PRE>jdbc:mysql://10.214.1.244:3306/metastore> CREATE TABLE IF NOT EXISTS `PART_CO L_STATS` ( `CS_ID` bigint(20) NOT NULL, `DB_NAME` varchar(128) CHARACTER SET lat in1 COLLATE latin1_bin NOT NULL, `TABLE_NAME` varchar(128) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `PARTITION_NAME` varchar(767) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, `COLUMN_NAME` varchar(128) CHARACTER SET latin1 COL LATE latin1_bin NOT NULL, `COLUMN_TYPE` varchar(128) CHARACTER SET latin1 COLLAT E latin1_bin NOT NULL, `PART_ID` bigint(20) NOT NULL, `LONG_LOW_VALUE` bigint(20 ), `LONG_HIGH_VALUE` bigint(20), `DOUBLE_HIGH_VALUE` double(53,4), `DOUBLE_LOW_V ALUE` double(53,4), `BIG_DECIMAL_LOW_VALUE` varchar(4000) CHARACTER SET latin1 C OLLATE latin1_bin, `BIG_DECIMAL_HIGH_VALUE` varchar(4000) CHARACTER SET latin1 C OLLATE latin1_bin, `NUM_NULLS` bigint(20) NOT NULL, `NUM_DISTINCTS` bigint(20), `AVG_COL_LEN` double(53,4), `MAX_COL_LEN` bigint(20), `NUM_TRUES` bigint(20), `N UM_FALSES` bigint(20), `LAST_ANALYZED` bigint(20) NOT NULL, PRIMARY KEY (`CS_ID` ), CONSTRAINT `PART_COL_STATS_FK` FOREIGN KEY (`PART_ID`) REFERENCES `PARTITIONS ` (`PART_ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 0: jdbc:mysql://10.214.1.244:3306/metastore> CREATE INDEX PCS_STATS_IDX ON PART_ COL_STATS (DB_NAME,TABLE_NAME,COLUMN_NAME,PARTITION_NAME)</PRE><PRE>Exit code: 1</PRE> i think the marked sql script is where it hit error. do you have any idea about the mysql script? thanks in advance. Wed, 22 Feb 2017 02:33:04 GMT jjiang 2017-02-22T02:33:04Z