pm_nr_gpload.yml 577 B

123456789101112131415161718192021222324252627
  1. VERSION: 1.0.0.1
  2. DATABASE: sqmmt
  3. USER: gpadmin
  4. HOST: 192.168.70.109
  5. PORT: 5432
  6. GPLOAD:
  7. PRELOAD:
  8. - TRUNCATE: false
  9. - REUSE_TABLES: true
  10. - STAGING_TABLE: extrnal_table_pm_5g_gpload
  11. - FAST_MATCH: true
  12. INPUT:
  13. - SOURCE:
  14. LOCAL_HOSTNAME:
  15. - 192.168.70.130
  16. PORT: 54321
  17. FILE:
  18. - /data1/pm_5g/distinct/pm_5g_hour_2022052409.csv
  19. - FORMAT: csv
  20. - DELIMITER: ','
  21. - HEADER: true
  22. - ENCODING: utf-8
  23. - ERROR_LIMIT: 20000000
  24. - LOG_ERRORS: true
  25. OUTPUT:
  26. - TABLE: tsfx.dw_sa_omc_ci_h
  27. - MODE: insert