x_job_hive2hive_json-15_13_26.868.log 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151
  1. 2022-07-28 15:13:27.162 [main] INFO VMInfo - VMInfo# operatingSystem class => sun.management.OperatingSystemImpl
  2. 2022-07-28 15:13:27.171 [main] INFO Engine - the machine info =>
  3. osInfo: Oracle Corporation 1.8 25.262-b10
  4. jvmInfo: Linux amd64 3.10.0-957.el7.x86_64
  5. cpu num: 128
  6. totalPhysicalMemory: -0.00G
  7. freePhysicalMemory: -0.00G
  8. maxFileDescriptorCount: -1
  9. currentOpenFileDescriptorCount: -1
  10. GC Names [PS MarkSweep, PS Scavenge]
  11. MEMORY_NAME | allocation_size | init_size
  12. PS Eden Space | 256.00MB | 256.00MB
  13. Code Cache | 240.00MB | 2.44MB
  14. Compressed Class Space | 1,024.00MB | 0.00MB
  15. PS Survivor Space | 42.50MB | 42.50MB
  16. PS Old Gen | 683.00MB | 683.00MB
  17. Metaspace | -0.00MB | 0.00MB
  18. 2022-07-28 15:13:27.193 [main] INFO Engine -
  19. {
  20. "content":[
  21. {
  22. "reader":{
  23. "name":"hdfsreader",
  24. "parameter":{
  25. "column":[
  26. "*"
  27. ],
  28. "defaultFS":"hdfs://hadoop03:8020/",
  29. "encoding":"UTF-8",
  30. "fieldDelimiter":"\t",
  31. "fileType":"text",
  32. "path":"/user/hive/warehouse/user_info/user_info_data.txt"
  33. }
  34. },
  35. "writer":{
  36. "name":"hdfswriter",
  37. "parameter":{
  38. "column":[
  39. {
  40. "name":"user_id",
  41. "type":"string"
  42. },
  43. {
  44. "name":"area_id",
  45. "type":"string"
  46. },
  47. {
  48. "name":"age",
  49. "type":"int"
  50. },
  51. {
  52. "name":"occupation",
  53. "type":"string"
  54. }
  55. ],
  56. "compress":"",
  57. "defaultFS":"hdfs://hadoop03:8020/",
  58. "fieldDelimiter":"\t",
  59. "fileName":"user_info_data_2.txt",
  60. "fileType":"text",
  61. "path":"/user/hive/warehouse/user_info/",
  62. "writeMode":"append"
  63. }
  64. }
  65. }
  66. ],
  67. "setting":{
  68. "speed":{
  69. "channel":"1"
  70. }
  71. }
  72. }
  73. 2022-07-28 15:13:27.214 [main] WARN Engine - prioriy set to 0, because NumberFormatException, the value is: null
  74. 2022-07-28 15:13:27.216 [main] INFO PerfTrace - PerfTrace traceId=job_-1, isEnable=false, priority=0
  75. 2022-07-28 15:13:27.217 [main] INFO JobContainer - DataX jobContainer starts job.
  76. 2022-07-28 15:13:27.219 [main] INFO JobContainer - Set jobId = 0
  77. 2022-07-28 15:13:27.244 [job-0] INFO HdfsReader$Job - init() begin...
  78. 2022-07-28 15:13:27.681 [job-0] INFO HdfsReader$Job - hadoopConfig details:{"finalParameters":[]}
  79. 2022-07-28 15:13:27.682 [job-0] INFO HdfsReader$Job - init() ok and end...
  80. 2022-07-28 15:13:28.899 [job-0] INFO JobContainer - jobContainer starts to do prepare ...
  81. 2022-07-28 15:13:28.900 [job-0] INFO JobContainer - DataX Reader.Job [hdfsreader] do prepare work .
  82. 2022-07-28 15:13:28.901 [job-0] INFO HdfsReader$Job - prepare(), start to getAllFiles...
  83. 2022-07-28 15:13:28.902 [job-0] INFO HdfsReader$Job - get HDFS all files in path = [/user/hive/warehouse/user_info/user_info_data.txt]
  84. 2022-07-28 15:13:29.892 [job-0] INFO HdfsReader$Job - [hdfs://hadoop03:8020/user/hive/warehouse/user_info/user_info_data.txt]是[text]类型的文件, 将该文件加入source files列表
  85. 2022-07-28 15:13:29.894 [job-0] INFO HdfsReader$Job - 您即将读取的文件数为: [1], 列表为: [hdfs://hadoop03:8020/user/hive/warehouse/user_info/user_info_data.txt]
  86. 2022-07-28 15:13:29.895 [job-0] INFO JobContainer - DataX Writer.Job [hdfswriter] do prepare work .
  87. 2022-07-28 15:13:29.986 [job-0] INFO HdfsWriter$Job - 由于您配置了writeMode append, 写入前不做清理工作, [/user/hive/warehouse/user_info/] 目录下写入相应文件名前缀 [user_info_data_2.txt] 的文件
  88. 2022-07-28 15:13:29.986 [job-0] INFO JobContainer - jobContainer starts to do split ...
  89. 2022-07-28 15:13:29.986 [job-0] INFO JobContainer - Job set Channel-Number to 1 channels.
  90. 2022-07-28 15:13:29.987 [job-0] INFO HdfsReader$Job - split() begin...
  91. 2022-07-28 15:13:29.987 [job-0] INFO JobContainer - DataX Reader.Job [hdfsreader] splits to [1] tasks.
  92. 2022-07-28 15:13:29.987 [job-0] INFO HdfsWriter$Job - begin do split...
  93. 2022-07-28 15:13:29.991 [job-0] INFO HdfsWriter$Job - splited write file name:[hdfs://hadoop03:8020//user/hive/warehouse/user_info__cae0010e_452e_4ee5_b9c2_91963c7817ce/user_info_data_2.txt__49706284_96d9_4ab0_b32e_56c90cf5c66e]
  94. 2022-07-28 15:13:29.992 [job-0] INFO HdfsWriter$Job - end do split.
  95. 2022-07-28 15:13:29.992 [job-0] INFO JobContainer - DataX Writer.Job [hdfswriter] splits to [1] tasks.
  96. 2022-07-28 15:13:30.003 [job-0] INFO JobContainer - jobContainer starts to do schedule ...
  97. 2022-07-28 15:13:30.009 [job-0] INFO JobContainer - Scheduler starts [1] taskGroups.
  98. 2022-07-28 15:13:30.011 [job-0] INFO JobContainer - Running by standalone Mode.
  99. 2022-07-28 15:13:30.139 [taskGroup-0] INFO TaskGroupContainer - taskGroupId=[0] start [1] channels for [1] tasks.
  100. 2022-07-28 15:13:30.152 [taskGroup-0] INFO Channel - Channel set byte_speed_limit to -1, No bps activated.
  101. 2022-07-28 15:13:30.152 [taskGroup-0] INFO Channel - Channel set record_speed_limit to -1, No tps activated.
  102. 2022-07-28 15:13:30.171 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] attemptCount[1] is started
  103. 2022-07-28 15:13:30.231 [0-0-0-reader] INFO HdfsReader$Job - hadoopConfig details:{"finalParameters":["mapreduce.job.end-notification.max.retry.interval","mapreduce.job.end-notification.max.attempts"]}
  104. 2022-07-28 15:13:30.233 [0-0-0-reader] INFO Reader$Task - read start
  105. 2022-07-28 15:13:30.233 [0-0-0-reader] INFO Reader$Task - reading file : [hdfs://hadoop03:8020/user/hive/warehouse/user_info/user_info_data.txt]
  106. 2022-07-28 15:13:30.239 [0-0-0-writer] INFO HdfsWriter$Task - begin do write...
  107. 2022-07-28 15:13:30.240 [0-0-0-writer] INFO HdfsWriter$Task - write to file : [hdfs://hadoop03:8020//user/hive/warehouse/user_info__cae0010e_452e_4ee5_b9c2_91963c7817ce/user_info_data_2.txt__49706284_96d9_4ab0_b32e_56c90cf5c66e]
  108. 2022-07-28 15:13:30.265 [0-0-0-reader] INFO UnstructuredStorageReaderUtil - CsvReader使用默认值[{"captureRawRecord":true,"columnCount":0,"comment":"#","currentRecord":-1,"delimiter":"\t","escapeMode":1,"headerCount":0,"rawRecord":"","recordDelimiter":"\u0000","safetySwitch":false,"skipEmptyRecords":true,"textQualifier":"\"","trimWhitespace":true,"useComments":false,"useTextQualifier":true,"values":[]}],csvReaderConfig值为[null]
  109. 2022-07-28 15:13:30.271 [0-0-0-reader] INFO Reader$Task - end read source files...
  110. 2022-07-28 15:13:30.539 [0-0-0-writer] INFO HdfsWriter$Task - end do write
  111. 2022-07-28 15:13:30.573 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] taskId[0] is successed, used[404]ms
  112. 2022-07-28 15:13:30.574 [taskGroup-0] INFO TaskGroupContainer - taskGroup[0] completed it's tasks.
  113. 2022-07-28 15:13:40.160 [job-0] INFO StandAloneJobContainerCommunicator - Total 4 records, 79 bytes | Speed 7B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 100.00%
  114. 2022-07-28 15:13:40.161 [job-0] INFO AbstractScheduler - Scheduler accomplished all tasks.
  115. 2022-07-28 15:13:40.162 [job-0] INFO JobContainer - DataX Writer.Job [hdfswriter] do post work.
  116. 2022-07-28 15:13:40.162 [job-0] INFO HdfsWriter$Job - start rename file [hdfs://hadoop03:8020//user/hive/warehouse/user_info__cae0010e_452e_4ee5_b9c2_91963c7817ce/user_info_data_2.txt__49706284_96d9_4ab0_b32e_56c90cf5c66e] to file [hdfs://hadoop03:8020//user/hive/warehouse/user_info/user_info_data_2.txt__49706284_96d9_4ab0_b32e_56c90cf5c66e].
  117. 2022-07-28 15:13:40.176 [job-0] INFO HdfsWriter$Job - finish rename file [hdfs://hadoop03:8020//user/hive/warehouse/user_info__cae0010e_452e_4ee5_b9c2_91963c7817ce/user_info_data_2.txt__49706284_96d9_4ab0_b32e_56c90cf5c66e] to file [hdfs://hadoop03:8020//user/hive/warehouse/user_info/user_info_data_2.txt__49706284_96d9_4ab0_b32e_56c90cf5c66e].
  118. 2022-07-28 15:13:40.177 [job-0] INFO HdfsWriter$Job - start delete tmp dir [hdfs://hadoop03:8020/user/hive/warehouse/user_info__cae0010e_452e_4ee5_b9c2_91963c7817ce] .
  119. 2022-07-28 15:13:40.188 [job-0] INFO HdfsWriter$Job - finish delete tmp dir [hdfs://hadoop03:8020/user/hive/warehouse/user_info__cae0010e_452e_4ee5_b9c2_91963c7817ce] .
  120. 2022-07-28 15:13:40.189 [job-0] INFO JobContainer - DataX Reader.Job [hdfsreader] do post work.
  121. 2022-07-28 15:13:40.190 [job-0] INFO JobContainer - DataX jobId [0] completed successfully.
  122. 2022-07-28 15:13:40.192 [job-0] INFO HookInvoker - No hook invoked, because base dir not exists or is a file: /root/yili-datax/datax/hook
  123. 2022-07-28 15:13:40.296 [job-0] INFO JobContainer -
  124. [total cpu info] =>
  125. averageCpu | maxDeltaCpu | minDeltaCpu
  126. -1.00% | -1.00% | -1.00%
  127. [total gc info] =>
  128. NAME | totalGCCount | maxDeltaGCCount | minDeltaGCCount | totalGCTime | maxDeltaGCTime | minDeltaGCTime
  129. PS MarkSweep | 2 | 2 | 2 | 0.132s | 0.132s | 0.132s
  130. PS Scavenge | 2 | 2 | 2 | 0.105s | 0.105s | 0.105s
  131. 2022-07-28 15:13:40.297 [job-0] INFO JobContainer - PerfTrace not enable!
  132. 2022-07-28 15:13:40.298 [job-0] INFO StandAloneJobContainerCommunicator - Total 4 records, 79 bytes | Speed 7B/s, 0 records/s | Error 0 records, 0 bytes | All Task WaitWriterTime 0.000s | All Task WaitReaderTime 0.000s | Percentage 100.00%
  133. 2022-07-28 15:13:40.300 [job-0] INFO JobContainer -
  134. 任务启动时刻 : 2022-07-28 15:13:27
  135. 任务结束时刻 : 2022-07-28 15:13:40
  136. 任务总计耗时 : 13s
  137. 任务平均流量 : 7B/s
  138. 记录写入速度 : 0rec/s
  139. 读出记录总数 : 4
  140. 读写失败总数 : 0