Hive Insert query is failing

Hi, Hive query running on Tez to insert from one table to another is failing with the below error. Both the tables have file format as ORC and all the columns in both the tables are string. Can anyone help on how it can be fixed. Hive version: 1.2.1.2.4 Error message: Vertex failed,

Metastore Schema Upgrade : 'ALTER TABLE' cannot be performed on 'COMPACTION_QUEUE' because it does not exist

Hi I am trying to upgrade metastore schema from 1.2.0 to 2.1.1 using the schematool by command: schematool -dbType derby -upgradeSchemaFrom 1.2.0 Getting an error: SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory] Metastore connection URL: