https://community.cloudera.com/t5/Support-Questions/It-is-possible-insert-data-into-a-table-A-from-another-B-by/m-p/155065#M117504 <P>haha, no worries. I still don't get the question, if you were missing some of the columns in the target table Eugene's link would help. But you don't. You have all of the columns of the target table so I do not get what you are trying to achieve. Your query already works no? If you need to change the order of columns you can just specify them in a different order? </P><P>So what exactly is better in your first query than in your second query apart from adding additional redundant information? </P> Thu, 19 May 2016 01:43:00 GMT bleonhardi 2016-05-19T01:43:00Z