ads_trd_group_funnel_rolling.ini 1016 B

123456789101112131415161718192021222324
  1. ; Hive ads.ads_trd_group_funnel_rolling → PG ads.ads_trd_group_funnel_rolling
  2. ; 全量覆盖(非分区单行,TRUNCATE 重灌);dt 是普通 ORC 列直接导
  3. ; 跑法: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
  4. [reader]
  5. dataSource = hdfs/prd-hdfs-ha
  6. path = /user/hive/warehouse/ads.db/ads_trd_group_funnel_rolling
  7. 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
  8. columnType =
  9. fileType = orc
  10. encoding = UTF-8
  11. compress =
  12. nullFormat =
  13. fieldDelimiter = \t
  14. [writer]
  15. dataSource = postgresql/dev-poyee-xiaoxu
  16. database = hs_sync_data
  17. table = ads.ads_trd_group_funnel_rolling
  18. 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
  19. columnType =
  20. preSql = TRUNCATE TABLE ads.ads_trd_group_funnel_rolling
  21. postSql =
  22. batchSize = 1024