g5.yml 860 B

123456789101112131415161718192021222324252627282930313233343536373839404142
  1. VERSION: 1.0.0.1
  2. DATABASE: localdb
  3. USER: gpadmin
  4. HOST: 10.170.42.48
  5. PORT: 5432
  6. GPLOAD:
  7. INPUT:
  8. - SOURCE:
  9. LOCAL_HOSTNAME:
  10. - 10.170.42.93
  11. PORT: 1234
  12. FILE:
  13. - /data/terminal/distinct/g5_terminal_20220123.csv
  14. - FORMAT: csv
  15. - DELIMITER: '|'
  16. - HEADER: false
  17. - ENCODING: utf-8
  18. - ERROR_LIMIT: 20000000
  19. - LOG_ERRORS: true
  20. OUTPUT:
  21. - TABLE: terminal_info.o_info_list_5g_terminal
  22. - MODE: merge
  23. - MATCH_COLUMNS:
  24. - msisdn
  25. - UPDATE_COLUMNS:
  26. - imsi
  27. - imei
  28. - tac
  29. - fact_name
  30. - terminal_name
  31. - hprovince
  32. - hprovince_name
  33. - hcity
  34. - hcity_name
  35. - vprovince
  36. - vprovince_name
  37. - vcity_name
  38. - roaming_city_name
  39. - cell_most
  40. - used_5g
  41. - status_5g
  42. - day