https://community.cloudera.com/t5/Support-Questions/It-is-possible-insert-data-into-a-table-A-from-another-B-by/m-p/155057#M117496 <P>Hello,</P><P>I want execute the follow sql :</P><P>INSERT INTO TABLE db_h_gss.tb_h_teste_insert values( teste_2, teste_3, teste_1, 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 limit 10;</P><P>It's possible, insert with subquery? This command doesnt work, i tried many ways and none worked.</P><P>This is the create table (destination)</P><P>CREATE TABLE db_h_gss.tb_h_teste_insert (teste_1 VARCHAR(200), teste_2 VARCHAR(200), teste_3 VARCHAR(200) ) PARTITIONED BY(cod_index int ) STORED AS ORC;</P><P>Thanks</P> Wed, 18 May 2016 23:53:03 GMT getterf 2016-05-18T23:53:03Z