| 123456789101112131415161718192021222324 |
- ; Hive ads.ads_trd_group_funnel_rolling → PG ads.ads_trd_group_funnel_rolling
- ; 全量覆盖(非分区单行,TRUNCATE 重灌);dt 是普通 ORC 列直接导
- ; 跑法:python3 bin/datax-hdfs-export-starter.py -ini jobs/ads/trd/ads_trd_group_funnel_rolling.ini -start-date 20260621 -stop-date 20260621 -skip-check
- [reader]
- dataSource = hdfs/prd-hdfs-ha
- path = /user/hive/warehouse/ads.db/ads_trd_group_funnel_rolling
- column = dt,uv_start_7d,uv_show_7d,uv_detail_7d,uv_order_7d,uv_paid_7d,uv_start_30d,uv_show_30d,uv_detail_30d,uv_order_30d,uv_paid_30d,etl_time
- columnType =
- fileType = orc
- encoding = UTF-8
- compress =
- nullFormat =
- fieldDelimiter = \t
- [writer]
- dataSource = postgresql/dev-poyee-xiaoxu
- database = hs_sync_data
- table = ads.ads_trd_group_funnel_rolling
- column = dt,uv_start_7d,uv_show_7d,uv_detail_7d,uv_order_7d,uv_paid_7d,uv_start_30d,uv_show_30d,uv_detail_30d,uv_order_30d,uv_paid_30d,etl_time
- columnType =
- preSql = TRUNCATE TABLE ads.ads_trd_group_funnel_rolling
- postSql =
- batchSize = 1024
|