Insert query: insert into tg_new partition(spec_id,tg_dim_key,data_supplier_name,retailer_name) select consumer_dim_key,file_id,load_timestamp,a.spec_id,a.tg_dim_key,a.data_supplier_name,a.retailer_name as from wh_postx_sonae_p1.tg_segment_map_fact_sonae a where consumer_dim_key in (select consumer_dim_key from cn_dim_key_tg);
create table tg_new( consumer_dim_key bigint, file_id string, load_timestamp string) PARTITIONED BY(spec_id string,tg_dim_key bigint,data_supplier_name string,retailer_name string)