insert into table test_xx PARTITION (pt = '20201108')
SELECT
request_id ,
request_info_id ,
request_code ,
request_name ,
phase_code ,
status_code ,
business_group
FROM SRM_BI_dev.srm_fnd_concurrent_request
where pt = '20201108'
;
insert into table test_xx PARTITION (pt = '20201108')
SELECT
request_id ,
request_info_id ,
request_code ,
request_name ,
phase_code ,
status_code ,
business_group
FROM SRM_BI_dev.srm_fnd_concurrent_request
where pt = '20201108'
;