@john doe use STORED AS ORC instead of RCFILE also, use CTAS to create a table from one table first, then do on the second table INSERT INTO TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] (z,y) select_statement1 FROM from_statement; see if that improves performance, I know it's 2 steps but interesting use case. ... View more