https://community.cloudera.com/t5/Support-Questions/It-is-possible-insert-data-into-a-table-A-from-another-B-by/m-p/155060#M117499 <P>The columns and orders just need to match. Not sure about the question.</P><P>Let's assume </P><P>Table A ( daily data ) </P><P>col a, col b, col c, col dt</P><P>Table B ( fact table with subset of columns reordered ) </P><P>col c, col a partitioned by dt </P><P>So if you know the date is only today you can just select the columns you need in the order you need them:</P><P>INSERT INTO B PARTITION (dt=1805 ) SELECT c,a from A;</P><P>or if you want dynamic partitoning you need to add the partition column at the end:</P><P>INSERT INTO B PARTITION (dt ) SELECT c,a,dt from A; </P> Thu, 19 May 2016 00:27:06 GMT bleonhardi 2016-05-19T00:27:06Z