Hello! The WITH HQL clause (inherited from SQL) may help you be a bit more explicit in your transformations and accomplish something similar to your case 2: WITH TABLE1
AS
(
SELECT
cod_index,
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
)
INSERT INTO TABLE db_h_gss.tb_h_teste_insert PARTITION (cod_index = 1)
SELECT
teste_1,
teste_2,
teste_3
FROM TABLE1 WHERE cod_index = 1;
... View more
