请问这是什么问题?
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【GBase版本】: GBase8c
【操作系统】: X86
【CPU】: intel
【问题描述】*:
执行merge into table1 as a using (select '80F8362792E647E8923D49BDBCE55E9A' id,'5E930EC1C00F4AF0977F43586ECFD789' task_id,'delete from dws_taxi_trip_data ;\nINSERT INTO dws_taxi_trip_data ( vendor_id, payment_type, driver_name_id, tpep_pick_year, tpep_pick_month, PULocationArea, fare_amount, tolls_amount, total_amount ) SELECT vendor_id,payment_type,driver_name_id,DATE_FORMAT ( tpep_pickup_datetime, '%Y' ),DATE_FORMAT ( tpep_pickup_datetime, '%m' ),pu_location_id,fare_amount,tolls_amount,total_amount FROM\tdwm_taxi_trip_data' task_info) b on a.id=b.id when matched then update set task_id=b.task_id,task_info=b.task_info when not matched then insert (id,task_id,task_info) values (b.id,b.task_id,b.task_info);
报错是什么问题?
评论
热门帖子
- 12025-12-01浏览数:182763
- 22023-05-09浏览数:25057
- 42023-09-25浏览数:18525
- 52020-05-11浏览数:17528