Well, i give up, i will use the command that works....heheh thanks to all... ... View more

Somehow, thats it i want, redundancy, only to improve the display command. Im reading the Eugene's link right now. ... View more

i will try explain what i want. case 1: INSERT INTO TABLE db_h_gss.tb_h_teste_insert PARTITION (cod_index=1) SELECT CAST(teste_1 AS VARCHAR(200)), CAST(teste_2 AS VARCHAR(200)), CAST(teste_3 AS VARCHAR(200)) FROM db_h_gss.tb_h_teste_orig; This command works, but i cant see which column "teste_1"(tb_h_teste_orig) corresponds in target table(tb_h_teste_insert) case 2 : INSERT INTO TABLE db_h_gss.tb_h_teste_insert values( teste_1, teste_2, teste_3, PARTITION (cod_index=1) ) from SELECT CAST(teste_1 AS VARCHAR(200)), CAST(teste_2 AS VARCHAR(200)), CAST(teste_3 AS VARCHAR(200)) FROM db_h_gss.tb_h_teste_orig ; 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. Sorry my english, but my spanish is worse. thanks again ... View more

I already did the insert, this command worked : INSERT OVERWRITE TABLE db_h_gss.tb_h_teste_insert PARTITION (cod_index=1) SELECT CAST(teste_1 AS VARCHAR(200)), CAST(teste_2 AS VARCHAR(200)), CAST(teste_3 AS VARCHAR(200)) FROM db_h_gss.tb_h_teste_orig limit 100; But, now, im looking another way to insert data in target table(tb_h_teste_insert), where I show the fields\columns in the target table and the fields\columns corresponding of the source table. Thanks again. ... View more

Thanks Leonard, but, that is my problem, im looking a way to insert specifying the fields\columns in the target table. It is to improve the display command. The idea is to show that: Column A in target table corresponds to column A in table orig Thanks again. ... View more