Hi @colorsoflife    Consider using CTE is possible, with the sequence as below for your references. This is Hive script incorporate into Ozzie workflow.   set hive.exec.dynamic.partition=true; set hive.exec.dynamic.partition.mode=nonstrict; with test_CTE as (select * from table1), testone_CTE as (select col1, col2, col3 from test_CTE) insert into table mytablename partition(biz_dt) select col1 as name1, col2 as name2, col3 as name3 from testOne_CTE   ... View more

This could be permission issue. you can see  the hive server2 log for the error. Log will be in /var/log/hive on the node to which you connect the hive  ... View more

@Alan Gates This is continued from previous post: I have made required changes in hive-site.xml on datanode, but when i restarted hive service from ambari changes are not reflecting in hive-site.xml it takes previous working configuration. ... View more

It is not working for me. Can you let me know if i'm doing anything wrong?? test4 is a table partitioned on lname and is ORC format. the partition I'm trying to merge has just 2 small files. ALTER TABLE test4 PARTITION (lname='vr') CONCATENATE; ... View more