We have two tables Stg_1 table and Final table Per day we are generating and adding approx 150GB to the final table . Whenever the Merge operation in performed the update statement is taking really long hours to complete , Since it is hourly job . We cannot accommodate more than 15 to 30 minutes . Options tried . ORC+Bucketed - Both Final and Stage table We cannot update the partition key value in Merge with Hive , hence removed partition which inturn taking long time to complete Error (Updating partition not supported --> Error: Error while compiling statement: FAILED: SemanticException [Error 10292]: Updating values of partition columns is not supported (state=42000,code=10292))