https://community.cloudera.com/t5/Support-Questions/It-is-possible-insert-data-into-a-table-A-from-another-B-by/m-p/155064#M117503 <P>i will try explain what i want.</P><P><STRONG>case 1:</STRONG></P><P>INSERT INTO TABLE db_h_gss.tb_h_teste_insert </P><P>PARTITION (cod_index=1) </P><P>SELECT </P><P>CAST(teste_1 AS VARCHAR(200)), CAST(teste_2 AS VARCHAR(200)), CAST(teste_3 AS VARCHAR(200)) </P><P>FROM db_h_gss.tb_h_teste_orig;</P><P>This command works, but i cant see which column "teste_1"(tb_h_teste_orig) corresponds in target table(tb_h_teste_insert)</P><P><STRONG>case 2 :</STRONG></P><P>INSERT INTO TABLE db_h_gss.tb_h_teste_insert </P><P> values( </P><P> teste_1, teste_2, teste_3, PARTITION (cod_index=1)</P><P> ) </P><P>from </P><P>SELECT </P><P>CAST(teste_1 AS VARCHAR(200)), </P><P> CAST(teste_2 AS VARCHAR(200)), </P><P> CAST(teste_3 AS VARCHAR(200))</P><P> FROM db_h_gss.tb_h_teste_orig ;</P><P>This command doesnt work, but, you can see that i'm trying insert in "teste_1"(target table) the column "teste_1" from tb_h_teste_orig.</P><P>Sorry my english, but my spanish is worse.</P><P>thanks again</P> Thu, 19 May 2016 01:36:44 GMT getterf 2016-05-19T01:36:44Z