table1是根据dt分区的数据表,dt例如:20220101,下列加载数据的SQL正确的是(),要求可重跑、写入分区要求当前天执行时写入至前一天的分区。
A.LOADDATINPATH'filepath'OVERWRITEINTOTABLEtable1PARTITION(dt='{{yyyymmdd}}')
B.LOADDATINPATH'filepath'INTOTABLEtable1PARTITION(dt='{{yyyymmdd}}')
C.LOADDATINPATH'filepath'INTOTABLEtable1PARTITION(dt='{{yyyyMMdd}}')
D.LOADDATINPATH'filepath'OVERWRITEINTOTABLEtable1PARTITION(dt='{{yyyyMMdd-1d}}')