Guest User

Untitled

a guest
May 30th, 2014
371
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Query (id=af4d1f47c62b76b4:d88072cab3fa4197):
  2. - AsyncTotalTime: 0ns
  3. Summary:
  4. Session ID: f14532f5f56fd776:64e25774df90d9b4
  5. Session Type: BEESWAX
  6. Start Time: 2014-05-30 15:40:13.268075000
  7. End Time:
  8. Query Type: DML
  9. Query State: CREATED
  10. Query Status: OK
  11. Impala Version: impalad version 1.3.1-cdh4 RELEASE (build 907481bf45b248a7bb3bb077d54831a71f484e5f)
  12. User: root
  13. Network Address: ::ffff:10.20.11.117:59244
  14. Default Db: db
  15. Sql Statement: insert INTO TABLE t2 PARTITION(dt) SELECT * FROM t WHERE dt='2014-05-27-00'
  16. Plan:
  17. ----------------
  18. Estimated Per-Host Requirements: Memory=3.00GB VCores=1
  19. WARNING: The following tables are missing relevant table and/or column statistics.
  20. db.t
  21.  
  22. F00:PLAN FRAGMENT [PARTITION=RANDOM]
  23. WRITE TO HDFS [db.t2, OVERWRITE=false, PARTITION-KEYS=(t.dt)]
  24. | partitions=1
  25. | hosts=3 per-host-mem=6.01KB
  26. |
  27. 00:SCAN HDFS [db.t, PARTITION=RANDOM]
  28. partitions=1/1 size=9.91GB
  29. table stats: 0 rows total
  30. columns missing stats: col1, col2, col3, col4, col5, col6, col7, col8, col9, col10, col11, col12, col13, col14, col15, col16, col17, col18, col19, col20, col21, col22, col23, col24, col25, col26, col27, col28, col29, col30, col31, col32, col33, col34, col35, col36, col37, col38, col39, col40, col41, col42, col43, col44, col45, col46, col47, col48, col49, col50, col51, col52, col53, col54, col55, col56, col57, col58, col59, col60, col61, col62, col63, col64, col65, col66, col67, col68, col69, col70, col71, col72, col73, col74, col75, col76, col77, col78, col79, col80, col81, col82, col83, col84, col85, col86, col87, col88, col89, col90, col91, col92, col93, col94, col95, col96, col97, col98, col99, col100, col101, col102, col103, col104, col105, col106, col107, col108, col109, col110, col111, col112, col113, col114, col115, col116, col117, col118, col119, col120, col121, col122, col123, col124, col125, col126, col127, col128, col129, col130, col131, col132, col133, col134, col135, col136, col137, col138, col139, col140, col141, col142, col143, col144, col145, col146, col147, col148, col149, col150, col151, col152, col153, col154, col155, col156, col157, col158, col159, col160, col161, col162, col163, col164, col165, col166, col167, col168, col169, col170, col171, col172, col173, col174, col175, col176, col177, col178, col179, col180, col181, col182, col183, col184, col185, col186, col187, col188, col189, col190, col191, col192, col193, col194, col195, col196, col197, col198, col199, col200, col201, col202, col203, col204, col205, col206, col207, col208, col209, col210, col211, col212, col213, col214, col215, col216, col217, col218, col219, col220, col221, col222, col223, col224, col225, col226, col227, col228, col229, col230, col231, col232, col233, col234, col235, col236, col237, col238, col239, col240, col241, col242, col243, col244, col245, col246, col247, col248, col249, col250, col251, col252, col253, col254, col255, col256, col257, col258, col259, col260, col261, col262, col263, col264, col265, col266, col267, col268, col269, col270, col271, col272, col273, col274, col275, col276, col277, col278, col279, col280, col281, col282, col283, col284, col285, col286, col287, col288, col289, col290, col291, col292, col293, col294, col295, col296, col297, col298, col299, col300, col301, col302, col303, col304, col305, col306, col307, col308, col309, col310, col311, col312, col313, col314, col315, col316, col317, col318, col319, col320, col321, col322, col323, col324, col325, col326, col327, col328, col329, col330, col331, col332, col333, col334, col335, col336, col337, col338, col339, col340, col341, col342, col343, col344, col345, col346, col347, col348, col349, col350, col351, col352, col353, col354, col355, col356, col357, col358, col359, col360, col361, col362, col363, col364, col365, col366, col367, col368, col369, col370, col371, col372, col373, col374, col375, col376, col377, col378, col379, col380, col381, col382, col383, col384, col385, col386, col387, col388, col389, col390, col391, col392, col393, col394, col395, col396, col397, col398, col399, col400, col401, col402, col403, col404, col405, col406, col407, col408, col409
  31. hosts=3 per-host-mem=3.00GB
  32. tuple-ids=0 row-size=6.01KB cardinality=0
  33. ----------------
  34. Estimated Per-Host Mem: 3221231622
  35. Estimated Per-Host VCores: 1
  36. Tables Missing Stats: db.t
  37. Request Pool: default-pool
  38. Query Timeline: 45m50s
  39. - Start execution: 3.223ms (3.223ms)
  40. - Planning finished: 59.459ms (56.236ms)
  41. - AsyncTotalTime: 0ns
  42. ImpalaServer:
  43. - AsyncTotalTime: 0ns
  44. - ClientFetchWaitTimer: 0ns
  45. - RowMaterializationTimer: 0ns
  46. Execution Profile af4d1f47c62b76b4:d88072cab3fa4197:(Total: 172.575ms, non-child: 0ns, % non-child: 0.00%)
  47. - AsyncTotalTime: 0ns
  48. - FinalizationTimer: 0ns
  49. Averaged Fragment 0:(Total: 15m50s, non-child: 0ns, % non-child: 0.00%)
  50. split sizes: min: 3.30 GB, max: 3.30 GB, avg: 3.30 GB, stddev: 579.09 KB
  51. - AverageThreadTokens: 8.94
  52. - PeakMemoryUsage: 1.41 GB
  53. - PrepareTime: 904.889us
  54. - RowsProduced: 11.76M (11759217)
  55. - TotalCpuTime: 2h14m
  56. - TotalNetworkReceiveTime: 0ns
  57. - TotalNetworkSendTime: 0ns
  58. - TotalStorageWaitTime: 1m58s
  59. CodeGen:(Total: 119.852ms, non-child: 119.852ms, % non-child: 100.00%)
  60. - CodegenTime: 0ns
  61. - CompileTime: 107.582ms
  62. - LoadTime: 11.202ms
  63. - ModuleFileSize: 105.51 KB
  64. HdfsTableSink:(Total: 15m49s, non-child: 15m49s, % non-child: 100.00%)
  65. - BytesWritten: 943.56 MB
  66. - EncodeTimer: 15m16s
  67. - FinalizePartitionFileTimer: 28s942ms
  68. - HdfsWriteTimer: 19s193ms
  69. - PeakMemoryUsage: 490.60 MB
  70. - RowsInserted: 11.39M (11386118)
  71. - TmpFileCreateTimer: 52.937ms
  72. HDFS_SCAN_NODE (id=0):(Total: 1s488ms, non-child: 1s488ms, % non-child: 100.00%)
  73. - AverageHdfsReadThreadConcurrency: 0.00
  74. - AverageScannerThreadConcurrency: 7.95
  75. - BytesRead: 2.29 GB
  76. - BytesReadDataNodeCache: 0
  77. - BytesReadLocal: 2.21 GB
  78. - BytesReadShortCircuit: 2.21 GB
  79. - DecompressionTime: 0ns
  80. - NumColumns: 0
  81. - NumDisksAccessed: 4
  82. - NumScannerThreadsStarted: 8
  83. - PeakMemoryUsage: 958.72 MB
  84. - PerReadThreadRawHdfsThroughput: 1.53 GB/sec
  85. - RowsRead: 11.78M (11778854)
  86. - RowsReturned: 11.76M (11759217)
  87. - RowsReturnedRate: 7.77 M/sec
  88. - ScanRangesComplete: 98
  89. - ScannerThreadsInvoluntaryContextSwitches: 30.67K (30666)
  90. - ScannerThreadsTotalWallClockTime: 2h
  91. - MaterializeTupleTime(*): 1h57m
  92. - ScannerThreadsSysTime: 453.262ms
  93. - ScannerThreadsUserTime: 3m21s
  94. - ScannerThreadsVoluntaryContextSwitches: 88.60K (88603)
  95. - TotalRawHdfsReadTime(*): 1s409ms
  96. - TotalReadThroughput: 1.68 MB/sec
  97. Fragment 0:
  98. - AsyncTotalTime: 0ns
  99. Instance af4d1f47c62b76b4:d88072cab3fa419a (host=SOMEHOST3:22000):(Total: 23m36s, non-child: 0ns, % non-child: 0.00%)
  100. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:13/307.42 MB 1:13/325.22 MB 2:11/262.74 MB 3:10/229.46 MB 4:30/716.74 MB 5:41/946.83 MB 6:30/593.54 MB
  101. MemoryUsage(32s000ms): 868.04 MB, 987.55 MB, 1.01 GB, 1.04 GB, 1.15 GB, 1.21 GB, 1.25 GB, 1.21 GB, 1.27 GB, 1.50 GB, 1.47 GB, 1.49 GB, 1.47 GB, 1.49 GB, 1.49 GB, 1.46 GB, 1.47 GB, 1.48 GB, 1.48 GB, 1.50 GB, 1.46 GB, 1.51 GB, 1.48 GB, 1.48 GB, 1.48 GB, 1.45 GB, 1.49 GB, 1.49 GB, 1.47 GB, 1.50 GB, 1.45 GB, 1.50 GB, 1.51 GB, 1.49 GB, 1.51 GB, 1.44 GB, 1.48 GB, 1.48 GB, 1.48 GB, 1.49 GB, 1.46 GB, 1.48 GB, 1.50 GB, 1.39 GB
  102. ThreadUsage(32s000ms): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 6
  103. - AsyncTotalTime: 0ns
  104. - AverageThreadTokens: 8.90
  105. - PeakMemoryUsage: 1.70 GB
  106. - PrepareTime: 761.852us
  107. - RowsProduced: 17.10M (17098222)
  108. - TotalCpuTime: 3h27m
  109. - TotalNetworkReceiveTime: 0ns
  110. - TotalNetworkSendTime: 0ns
  111. - TotalStorageWaitTime: 2m51s
  112. CodeGen:(Total: 105.281ms, non-child: 105.281ms, % non-child: 100.00%)
  113. - AsyncTotalTime: 0ns
  114. - CodegenTime: 0ns
  115. - CompileTime: 94.999ms
  116. - LoadTime: 9.413ms
  117. - ModuleFileSize: 105.51 KB
  118. HdfsTableSink:(Total: 23m34s, non-child: 23m34s, % non-child: 100.00%)
  119. - AsyncTotalTime: 0ns
  120. - BytesWritten: 1.38 GB
  121. - EncodeTimer: 22m46s
  122. - FinalizePartitionFileTimer: 28s036ms
  123. - HdfsWriteTimer: 27s852ms
  124. - PeakMemoryUsage: 639.93 MB
  125. - RowsInserted: 17.10M (17098222)
  126. - TmpFileCreateTimer: 119.715ms
  127. HDFS_SCAN_NODE (id=0):(Total: 1s983ms, non-child: 1s983ms, % non-child: 100.00%)
  128. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:13/307.42 MB 1:13/325.22 MB 2:11/262.74 MB 3:10/229.46 MB 4:30/716.74 MB 5:41/946.83 MB 6:30/593.54 MB
  129. Hdfs Read Thread Concurrency Bucket: 0:99.93% 1:0.07077% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0%
  130. File Formats: PARQUET/NONE:60532
  131. ExecOption: Codegen enabled: 0 out of 148
  132. BytesRead(32s000ms): 115.89 MB, 152.97 MB, 223.85 MB, 323.57 MB, 348.70 MB, 422.45 MB, 523.20 MB, 552.07 MB, 624.55 MB, 719.87 MB, 769.28 MB, 861.50 MB, 962.17 MB, 1010.68 MB, 1.10 GB, 1.15 GB, 1.22 GB, 1.34 GB, 1.37 GB, 1.49 GB, 1.54 GB, 1.62 GB, 1.74 GB, 1.77 GB, 1.87 GB, 1.94 GB, 2.00 GB, 2.12 GB, 2.16 GB, 2.26 GB, 2.34 GB, 2.39 GB, 2.50 GB, 2.55 GB, 2.64 GB, 2.73 GB, 2.79 GB, 2.88 GB, 2.95 GB, 3.02 GB, 3.11 GB, 3.18 GB, 3.26 GB, 3.30 GB
  133. - AsyncTotalTime: 0ns
  134. - AverageHdfsReadThreadConcurrency: 0.00
  135. - AverageScannerThreadConcurrency: 7.92
  136. - BytesRead: 3.32 GB
  137. - BytesReadDataNodeCache: 0
  138. - BytesReadLocal: 3.32 GB
  139. - BytesReadShortCircuit: 3.32 GB
  140. - DecompressionTime: 0ns
  141. - NumColumns: 0
  142. - NumDisksAccessed: 7
  143. - NumScannerThreadsStarted: 8
  144. - PeakMemoryUsage: 1.07 GB
  145. - PerReadThreadRawHdfsThroughput: 1.72 GB/sec
  146. - RowsRead: 17.10M (17098222)
  147. - RowsReturned: 17.10M (17098222)
  148. - RowsReturnedRate: 8.62 M/sec
  149. - ScanRangesComplete: 148
  150. - ScannerThreadsInvoluntaryContextSwitches: 45.08K (45083)
  151. - ScannerThreadsTotalWallClockTime: 3h6m
  152. - MaterializeTupleTime(*): 3h
  153. - ScannerThreadsSysTime: 673.893ms
  154. - ScannerThreadsUserTime: 5m
  155. - ScannerThreadsVoluntaryContextSwitches: 133.15K (133145)
  156. - TotalRawHdfsReadTime(*): 1s925ms
  157. - TotalReadThroughput: 2.41 MB/sec
  158. Instance af4d1f47c62b76b4:d88072cab3fa4198 (host=SOMEHOST2:22000):(Total: 1m32s, non-child: 0ns, % non-child: 0.00%)
  159. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:31/709.29 MB 1:23/502.28 MB 2:34/797.81 MB 3:26/574.11 MB 4:34/799.07 MB
  160. MemoryUsage(1m4s): 769.72 MB, 838.56 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB, 830.72 MB
  161. ThreadUsage(1m4s): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9
  162. - AsyncTotalTime: 0ns
  163. - AverageThreadTokens: 9.03
  164. - PeakMemoryUsage: 930.11 MB
  165. - PrepareTime: 1.195ms
  166. - RowsProduced: 1.12M (1119297)
  167. - TotalCpuTime: 0ns
  168. - TotalNetworkReceiveTime: 0ns
  169. - TotalNetworkSendTime: 0ns
  170. - TotalStorageWaitTime: 18s984ms
  171. CodeGen:(Total: 163.407ms, non-child: 163.407ms, % non-child: 100.00%)
  172. - AsyncTotalTime: 0ns
  173. - CodegenTime: 0ns
  174. - CompileTime: 149.239ms
  175. - LoadTime: 12.719ms
  176. - ModuleFileSize: 105.51 KB
  177. HdfsTableSink:(Total: 1m31s, non-child: 1m31s, % non-child: 100.00%)
  178. - AsyncTotalTime: 0ns
  179. - BytesWritten: 4.00 B
  180. - EncodeTimer: 1m29s
  181. - HdfsWriteTimer: 0ns
  182. - PeakMemoryUsage: 191.93 MB
  183. - RowsInserted: 0
  184. - TmpFileCreateTimer: 7.651ms
  185. HDFS_SCAN_NODE (id=0):(Total: 1s245ms, non-child: 1s245ms, % non-child: 100.00%)
  186. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:31/709.29 MB 1:23/502.28 MB 2:34/797.81 MB 3:26/574.11 MB 4:34/799.07 MB
  187. BytesRead(1m4s): 142.42 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB, 233.01 MB
  188. - AsyncTotalTime: 0ns
  189. - AverageHdfsReadThreadConcurrency: 0.00
  190. - AverageScannerThreadConcurrency: 8.03
  191. - BytesRead: 233.01 MB
  192. - BytesReadDataNodeCache: 0
  193. - BytesReadLocal: 0
  194. - BytesReadShortCircuit: 0
  195. - DecompressionTime: 0ns
  196. - NumColumns: 0
  197. - NumDisksAccessed: 0
  198. - NumScannerThreadsStarted: 9
  199. - PeakMemoryUsage: 760.21 MB
  200. - PerReadThreadRawHdfsThroughput: 1.30 GB/sec
  201. - RowsRead: 1.18M (1178208)
  202. - RowsReturned: 1.12M (1119297)
  203. - RowsReturnedRate: 898.43 K/sec
  204. - ScanRangesComplete: 1
  205. - ScannerThreadsInvoluntaryContextSwitches: 0
  206. - ScannerThreadsTotalWallClockTime: 0ns
  207. - MaterializeTupleTime(*): 1m29s
  208. - ScannerThreadsSysTime: 0ns
  209. - ScannerThreadsUserTime: 0ns
  210. - ScannerThreadsVoluntaryContextSwitches: 0
  211. - TotalRawHdfsReadTime(*): 175.602ms
  212. - TotalReadThroughput: 86.81 KB/sec
  213. Instance af4d1f47c62b76b4:d88072cab3fa4199 (host=SOMEHOST4:22000):(Total: 22m22s, non-child: 0ns, % non-child: 0.00%)
  214. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:14/285.90 MB 1:12/296.74 MB 2:14/336.06 MB 3:10/226.44 MB 4:34/808.60 MB 5:32/691.37 MB 6:31/736.07 MB
  215. MemoryUsage(32s000ms): 910.23 MB, 1013.02 MB, 1.05 GB, 1.18 GB, 1.24 GB, 1.22 GB, 1.41 GB, 1.45 GB, 1.46 GB, 1.50 GB, 1.48 GB, 1.49 GB, 1.46 GB, 1.48 GB, 1.50 GB, 1.47 GB, 1.50 GB, 1.45 GB, 1.49 GB, 1.53 GB, 1.48 GB, 1.52 GB, 1.47 GB, 1.49 GB, 1.51 GB, 1.46 GB, 1.49 GB, 1.50 GB, 1.49 GB, 1.51 GB, 1.48 GB, 1.50 GB, 1.51 GB, 1.48 GB, 1.52 GB, 1.49 GB, 1.50 GB, 1.52 GB, 1.46 GB, 1.46 GB, 1.41 GB
  216. ThreadUsage(32s000ms): 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 9, 8
  217. - AsyncTotalTime: 0ns
  218. - AverageThreadTokens: 8.87
  219. - PeakMemoryUsage: 1.62 GB
  220. - PrepareTime: 757.359us
  221. - RowsProduced: 17.06M (17060133)
  222. - TotalCpuTime: 3h15m
  223. - TotalNetworkReceiveTime: 0ns
  224. - TotalNetworkSendTime: 0ns
  225. - TotalStorageWaitTime: 2m45s
  226. CodeGen:(Total: 90.869ms, non-child: 90.869ms, % non-child: 100.00%)
  227. - AsyncTotalTime: 0ns
  228. - CodegenTime: 0ns
  229. - CompileTime: 78.508ms
  230. - LoadTime: 11.475ms
  231. - ModuleFileSize: 105.51 KB
  232. HdfsTableSink:(Total: 22m21s, non-child: 22m21s, % non-child: 100.00%)
  233. - AsyncTotalTime: 0ns
  234. - BytesWritten: 1.38 GB
  235. - EncodeTimer: 21m32s
  236. - FinalizePartitionFileTimer: 29s849ms
  237. - HdfsWriteTimer: 29s726ms
  238. - PeakMemoryUsage: 639.93 MB
  239. - RowsInserted: 17.06M (17060133)
  240. - TmpFileCreateTimer: 31.444ms
  241. HDFS_SCAN_NODE (id=0):(Total: 1s236ms, non-child: 1s236ms, % non-child: 100.00%)
  242. Hdfs split stats (<volume id>:<# splits>/<split lengths>): 0:14/285.90 MB 1:12/296.74 MB 2:14/336.06 MB 3:10/226.44 MB 4:34/808.60 MB 5:32/691.37 MB 6:31/736.07 MB
  243. Hdfs Read Thread Concurrency Bucket: 0:99.63% 1:0.3736% 2:0% 3:0% 4:0% 5:0% 6:0% 7:0% 8:0%
  244. File Formats: PARQUET/NONE:60123
  245. ExecOption: Codegen enabled: 0 out of 147
  246. BytesRead(32s000ms): 121.30 MB, 199.02 MB, 317.71 MB, 379.78 MB, 506.43 MB, 574.23 MB, 681.94 MB, 757.79 MB, 821.30 MB, 949.04 MB, 983.30 MB, 1.06 GB, 1.14 GB, 1.19 GB, 1.31 GB, 1.35 GB, 1.44 GB, 1.54 GB, 1.58 GB, 1.70 GB, 1.75 GB, 1.83 GB, 1.93 GB, 1.97 GB, 2.07 GB, 2.14 GB, 2.21 GB, 2.31 GB, 2.37 GB, 2.44 GB, 2.54 GB, 2.59 GB, 2.69 GB, 2.75 GB, 2.83 GB, 2.93 GB, 2.98 GB, 3.07 GB, 3.13 GB, 3.20 GB, 3.28 GB
  247. - AsyncTotalTime: 0ns
  248. - AverageHdfsReadThreadConcurrency: 0.00
  249. - AverageScannerThreadConcurrency: 7.90
  250. - BytesRead: 3.32 GB
  251. - BytesReadDataNodeCache: 0
  252. - BytesReadLocal: 3.32 GB
  253. - BytesReadShortCircuit: 3.32 GB
  254. - DecompressionTime: 0ns
  255. - NumColumns: 0
  256. - NumDisksAccessed: 7
  257. - NumScannerThreadsStarted: 8
  258. - PeakMemoryUsage: 1017.33 MB
  259. - PerReadThreadRawHdfsThroughput: 1.56 GB/sec
  260. - RowsRead: 17.06M (17060133)
  261. - RowsReturned: 17.06M (17060133)
  262. - RowsReturnedRate: 13.80 M/sec
  263. - ScanRangesComplete: 147
  264. - ScannerThreadsInvoluntaryContextSwitches: 46.91K (46915)
  265. - ScannerThreadsTotalWallClockTime: 2h56m
  266. - MaterializeTupleTime(*): 2h50m
  267. - ScannerThreadsSysTime: 685.893ms
  268. - ScannerThreadsUserTime: 5m5s
  269. - ScannerThreadsVoluntaryContextSwitches: 132.66K (132664)
  270. - TotalRawHdfsReadTime(*): 2s126ms
  271. - TotalReadThroughput: 2.54 MB/sec
RAW Paste Data