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'
;
本文介绍了一种将特定日期分区的数据从源表SRM_BI_dev.srm_fnd_concurrent_request导入到目标表tabletest_xx的具体方法。通过使用INSERT INTO...SELECT语句,并指定分区pt='20201108',实现对request_id等字段的数据迁移。
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'
;

被折叠的 条评论
为什么被折叠?