API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 14th, 2019
23
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 25.48 KB | None | 0 0
raw download clone embed print report
  1. 2019-09-14T12:26:01.559051 1 35737 MapDHandler.cpp:320 stdlog_begin connect 7 0
  2. 2019-09-14T12:26:01.863895 I 35737 MapDHandler.cpp:377 User TEST_USER connected to database TEST_DATABASE with public_session_id 601-UQvs
  3. 2019-09-14T12:26:01.863957 I 35737 MapDHandler.cpp:320 stdlog connect 7 304 TEST_DATABASE TEST_USER 601-UQvs {"roles"} {"super"}
  4. 2019-09-14T12:26:01.864109 1 35737 MapDHandler.cpp:532 stdlog_begin get_session_info 8 0 TEST_DATABASE TEST_USER 601-UQvs
  5. 2019-09-14T12:26:01.864130 I 35737 MapDHandler.cpp:532 stdlog get_session_info 8 0 TEST_DATABASE TEST_USER 601-UQvs
  6. 2019-09-14T12:26:03.943323 1 35737 MapDHandler.cpp:759 stdlog_begin sql_execute 9 0 TEST_DATABASE TEST_USER 601-UQvs {"query_str"} {"select sum(A.val) val1,A.sDate,A.sID from A join B on B.sID=A.sID and B.id=A.bID where A.sID=999888 group by A.sDate,A.sID;"}
  7. 2019-09-14T12:26:03.943473 I 35737 measure.h:72 Timer start parse_to_ra parse_to_ra: 5221
  8. 2019-09-14T12:26:03.944297 I 35737 Calcite.cpp:455 User TEST_USER catalog TEST_DATABASE sql 'select sum(A.val) val1,A.sDate,A.sID from A join B on B.sID=A.sID and B.id=A.bID where A.sID=999888 group by A.sDate,A.sID;'
  9. 2019-09-14T12:26:04.006846 I 35737 Calcite.cpp:474 Time in Thrift 2 (ms), Time in Java Calcite server 60 (ms)
  10. 2019-09-14T12:26:04.006935 I 35737 measure.h:79 Timer end parse_to_ra parse_to_ra: 5221 elapsed 63 ms
  11. 2019-09-14T12:26:04.006960 I 35737 measure.h:72 Timer start execute_rel_alg execute_rel_alg: 4359
  12. 2019-09-14T12:26:04.006973 I 35737 measure.h:72 Timer start getExecutor getExecutor: 127
  13. 2019-09-14T12:26:04.006984 I 35737 measure.h:79 Timer end getExecutor getExecutor: 127 elapsed 0 ms
  14. 2019-09-14T12:26:04.007000 I 35737 measure.h:72 Timer start executeRelAlgQuery executeRelAlgQuery: 57
  15. 2019-09-14T12:26:04.007012 I 35737 measure.h:72 Timer start executeRelAlgQueryNoRetry executeRelAlgQueryNoRetry: 80
  16. 2019-09-14T12:26:04.007291 I 35737 RelAlgOptimizer.cpp:322 ID=5 (RelProject<139765385265216> (RexInput 0 139765373346608) (RexInput 1 139765373346608) (RexInput 2 139765373346608) (RexInput 3 139765373346608) (RexInput 4 139765373346608) (RexInput 5 139765373346608) (RexInput 6 139765373346608) (RexInput 7 139765373346608) (RexInput 8 139765373346608) (RexInput 9 139765373346608) (RexInput 10 139765373346608) (RexInput 11 139765373346608) (RexInput 12 139765373346608) (RexInput 13 139765373346608) (RexInput 14 139765373346608) (RexInput 15 139765373346608) (RexInput 16 139765373346608) (RexInput 17 139765373346608) (RexInput 18 139765373346608) (RexInput 0 139765385265712) (RexInput 1 139765385265712) (RexInput 2 139765385265712) (RexInput 3 139765385265712) (RexInput 4 139765385265712) (RexInput 5 139765385265712) (RexInput 6 139765385265712) (RexInput 7 139765385265712) (RexInput 8 139765385265712) (RexInput 9 139765385265712) (RexInput 10 139765385265712) (RexInput 11 139765385265712) (RexInput 12 139765385265712) (RexInput 13 139765385265712) (RexInput 14 139765385265712) (RexInput 15 139765385265712)) deleted!
  17. 2019-09-14T12:26:04.007420 I 35737 RelAlgOptimizer.cpp:754 (RelProject<139765385265712> (RexInput 0 139765367590368) (RexInput 1 139765367590368) (RexInput 2 139765367590368) (RexInput 3 139765367590368) (RexInput 4 139765367590368) (RexInput 5 139765367590368) (RexInput 6 139765367590368) (RexInput 7 139765367590368) (RexInput 8 139765367590368) (RexInput 9 139765367590368) (RexInput 10 139765367590368) (RexInput 11 139765367590368) (RexInput 12 139765367590368) (RexInput 13 139765367590368) (RexInput 14 139765367590368) (RexInput 15 139765367590368) (RexOperator 19 (RexInput 0 139765367590368))) eliminated 15 columns.
  18. 2019-09-14T12:26:04.008127 I 35737 measure.h:72 Timer start executeRelAlgSeq executeRelAlgSeq: 300
  19. 2019-09-14T12:26:04.008148 I 35737 measure.h:72 Timer start executeRelAlgStep executeRelAlgStep: 361
  20. 2019-09-14T12:26:04.008211 I 35737 measure.h:72 Timer start executeWorkUnit executeWorkUnit: 1902
  21. 2019-09-14T12:26:04.008228 I 35737 measure.h:72 Timer start get_table_infos get_table_infos: 259
  22. 2019-09-14T12:26:04.008243 I 35737 measure.h:79 Timer end get_table_infos get_table_infos: 259 elapsed 0 ms
  23. 2019-09-14T12:26:04.008262 I 35737 measure.h:72 Timer start get_table_infos get_table_infos: 259
  24. 2019-09-14T12:26:04.008279 I 35737 measure.h:79 Timer end get_table_infos get_table_infos: 259 elapsed 0 ms
  25. 2019-09-14T12:26:04.008291 I 35737 measure.h:72 Timer start Exec_executeWorkUnit executeWorkUnitImpl: 1137
  26. 2019-09-14T12:26:04.008361 I 35737 measure.h:72 Timer start execution_dispatch_comp executeWorkUnitImpl: 1157
  27. 2019-09-14T12:26:04.010321 I 35737 measure.h:72 Timer start buildJoinLoops buildJoinLoops: 212
  28. 2019-09-14T12:26:04.010353 I 35737 measure.h:79 Timer end buildJoinLoops buildJoinLoops: 212 elapsed 0 ms
  29. 2019-09-14T12:26:04.010421 1 35737 NativeCodegen.cpp:1668 number of hoisted literals: 0 / literal buffer usage: 0 bytes
  30. 2019-09-14T12:26:04.010881 I 35737 measure.h:79 Timer end execution_dispatch_comp executeWorkUnitImpl: 1157 elapsed 2 ms
  31. 2019-09-14T12:26:04.011049 1 35737 Execute.cpp:1597 Dispatching multifrag kernels
  32. 2019-09-14T12:26:04.011067 1 35737 Execute.cpp:1598 Query Memory Descriptor State
  33. Query Type: Non-grouped Aggregate
  34. Allow Multifrag: True
  35. Keyless Hash: False
  36. Interleaved Bins on GPU: False
  37. Blocks Share Memory: False
  38. Threads Share Memory: False
  39. Uses Fast Group Values: False
  40. Lazy Init Groups (GPU): True
  41. Entry Count: 1
  42. Min Val (perfect hash only): 0
  43. Max Val (perfect hash only): 0
  44. Bucket Val (perfect hash only): 0
  45. Sort on GPU: False
  46. Output Columnar: False
  47. Render Output: False
  48. Use Baseline Sort: False
  49. Col Slot Context State
  50. N | P , L
  51. 0 | 8 , 4
  52.  
  53. 2019-09-14T12:26:04.011190 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  54. 2019-09-14T12:26:04.011220 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  55. 2019-09-14T12:26:04.011244 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  56. 2019-09-14T12:26:04.011243 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  57. 2019-09-14T12:26:04.011200 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  58. 2019-09-14T12:26:04.011261 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  59. 2019-09-14T12:26:04.011305 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  60. 2019-09-14T12:26:04.011282 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  61. 2019-09-14T12:26:04.011413 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  62. 2019-09-14T12:26:04.011451 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  63. 2019-09-14T12:26:04.011480 I 35737 measure.h:72 Timer start executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135
  64. 2019-09-14T12:26:04.011492 I 35737 measure.h:72 Timer start executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135
  65. 2019-09-14T12:26:04.011480 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  66. 2019-09-14T12:26:04.011513 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  67. 2019-09-14T12:26:04.011508 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  68. 2019-09-14T12:26:04.011510 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  69. 2019-09-14T12:26:04.011541 I 35737 measure.h:72 Timer start executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135
  70. 2019-09-14T12:26:04.011558 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  71. 2019-09-14T12:26:04.011562 I 35737 measure.h:72 Timer start executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135
  72. 2019-09-14T12:26:04.011578 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  73. 2019-09-14T12:26:04.012821 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 1 ms
  74. 2019-09-14T12:26:04.012827 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 1 ms
  75. 2019-09-14T12:26:04.012882 I 35737 measure.h:79 Timer end executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135 elapsed 1 ms
  76. 2019-09-14T12:26:04.012895 I 35737 measure.h:79 Timer end executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135 elapsed 1 ms
  77. 2019-09-14T12:26:04.012908 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 1 ms
  78. 2019-09-14T12:26:04.012880 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 1 ms
  79. 2019-09-14T12:26:04.012919 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 1 ms
  80. 2019-09-14T12:26:04.012974 I 35737 measure.h:79 Timer end executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135 elapsed 1 ms
  81. 2019-09-14T12:26:04.012994 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 1 ms
  82. 2019-09-14T12:26:04.013619 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 2 ms
  83. 2019-09-14T12:26:04.013691 I 35737 measure.h:79 Timer end executePlanWithoutGroupBy executePlanWithoutGroupBy: 2135 elapsed 2 ms
  84. 2019-09-14T12:26:04.013714 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 2 ms
  85. 2019-09-14T12:26:04.013900 I 35737 measure.h:79 Timer end Exec_executeWorkUnit executeWorkUnitImpl: 1137 elapsed 5 ms
  86. 2019-09-14T12:26:04.013964 I 35737 measure.h:72 Timer start Exec_executeWorkUnit executeWorkUnitImpl: 1137
  87. 2019-09-14T12:26:04.014012 I 35737 measure.h:72 Timer start execution_dispatch_comp executeWorkUnitImpl: 1157
  88. 2019-09-14T12:26:04.015311 I 35737 measure.h:72 Timer start buildJoinLoops buildJoinLoops: 212
  89. 2019-09-14T12:26:04.015334 I 35737 measure.h:79 Timer end buildJoinLoops buildJoinLoops: 212 elapsed 0 ms
  90. 2019-09-14T12:26:04.015455 1 35737 NativeCodegen.cpp:1668 number of hoisted literals: 0 / literal buffer usage: 0 bytes
  91. 2019-09-14T12:26:04.015948 I 35737 measure.h:79 Timer end execution_dispatch_comp executeWorkUnitImpl: 1157 elapsed 1 ms
  92. 2019-09-14T12:26:04.016078 1 35737 Execute.cpp:1623 Dispatching kernel per fragment
  93. 2019-09-14T12:26:04.016095 1 35737 Execute.cpp:1624 Query Memory Descriptor State
  94. Query Type: Projection
  95. Allow Multifrag: True
  96. Keyless Hash: False
  97. Interleaved Bins on GPU: False
  98. Blocks Share Memory: True
  99. Threads Share Memory: True
  100. Uses Fast Group Values: False
  101. Lazy Init Groups (GPU): True
  102. Entry Count: 146991045
  103. Min Val (perfect hash only): 0
  104. Max Val (perfect hash only): 0
  105. Bucket Val (perfect hash only): 0
  106. Sort on GPU: False
  107. Output Columnar: False
  108. Render Output: False
  109. Use Baseline Sort: False
  110. Col Slot Context State
  111. N | P , L
  112. 0 | 0 , 0
  113. 1 | 8 , 8
  114.  
  115. 2019-09-14T12:26:04.016124 I 35737 Execute.cpp:1632 Lowering scan limit from 146991045 to match max fragment size 32000000 for kernel per fragment execution path.
  116. 2019-09-14T12:26:04.016168 I 35737 measure.h:79 Timer end Exec_executeWorkUnit executeWorkUnitImpl: 1137 elapsed 2 ms
  117. 2019-09-14T12:26:04.016187 I 35737 measure.h:72 Timer start Exec_executeWorkUnit executeWorkUnitImpl: 1137
  118. 2019-09-14T12:26:04.016205 I 35737 measure.h:72 Timer start execution_dispatch_comp executeWorkUnitImpl: 1157
  119. 2019-09-14T12:26:04.017176 I 35737 measure.h:72 Timer start buildJoinLoops buildJoinLoops: 212
  120. 2019-09-14T12:26:04.017200 I 35737 measure.h:79 Timer end buildJoinLoops buildJoinLoops: 212 elapsed 0 ms
  121. 2019-09-14T12:26:04.017276 1 35737 NativeCodegen.cpp:1668 number of hoisted literals: 0 / literal buffer usage: 0 bytes
  122. 2019-09-14T12:26:04.017732 I 35737 measure.h:79 Timer end execution_dispatch_comp executeWorkUnitImpl: 1157 elapsed 1 ms
  123. 2019-09-14T12:26:04.017838 1 35737 Execute.cpp:1623 Dispatching kernel per fragment
  124. 2019-09-14T12:26:04.017855 1 35737 Execute.cpp:1624 Query Memory Descriptor State
  125. Query Type: Projection
  126. Allow Multifrag: True
  127. Keyless Hash: False
  128. Interleaved Bins on GPU: False
  129. Blocks Share Memory: True
  130. Threads Share Memory: True
  131. Uses Fast Group Values: False
  132. Lazy Init Groups (GPU): True
  133. Entry Count: 32000000
  134. Min Val (perfect hash only): 0
  135. Max Val (perfect hash only): 0
  136. Bucket Val (perfect hash only): 0
  137. Sort on GPU: False
  138. Output Columnar: False
  139. Render Output: False
  140. Use Baseline Sort: False
  141. Col Slot Context State
  142. N | P , L
  143. 0 | 0 , 0
  144. 1 | 8 , 8
  145.  
  146. 2019-09-14T12:26:04.017951 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  147. 2019-09-14T12:26:04.017964 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  148. 2019-09-14T12:26:04.017983 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  149. 2019-09-14T12:26:04.017998 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  150. 2019-09-14T12:26:04.017999 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  151. 2019-09-14T12:26:04.018034 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  152. 2019-09-14T12:26:04.018018 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  153. 2019-09-14T12:26:04.018059 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  154. 2019-09-14T12:26:04.018081 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  155. 2019-09-14T12:26:04.018081 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  156. 2019-09-14T12:26:04.018143 I 35737 measure.h:72 Timer start executePlanWithGroupBy executePlanWithGroupBy: 2278
  157. 2019-09-14T12:26:04.018159 I 35737 measure.h:72 Timer start executePlanWithGroupBy executePlanWithGroupBy: 2278
  158. 2019-09-14T12:26:04.018100 I 35737 measure.h:72 Timer start execution_dispatch_run operator(): 1191
  159. 2019-09-14T12:26:04.018167 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  160. 2019-09-14T12:26:04.018199 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  161. 2019-09-14T12:26:04.018179 I 35737 measure.h:72 Timer start executePlanWithGroupBy executePlanWithGroupBy: 2278
  162. 2019-09-14T12:26:04.018183 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  163. 2019-09-14T12:26:04.018235 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  164. 2019-09-14T12:26:04.018239 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  165. 2019-09-14T12:26:04.018341 I 35737 measure.h:72 Timer start executePlanWithGroupBy executePlanWithGroupBy: 2278
  166. 2019-09-14T12:26:04.018361 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  167. 2019-09-14T12:26:04.573788 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 555 ms
  168. 2019-09-14T12:26:04.573876 I 35737 measure.h:79 Timer end executePlanWithGroupBy executePlanWithGroupBy: 2278 elapsed 555 ms
  169. 2019-09-14T12:26:04.573903 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 555 ms
  170. 2019-09-14T12:26:04.680151 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 662 ms
  171. 2019-09-14T12:26:04.680224 I 35737 measure.h:79 Timer end executePlanWithGroupBy executePlanWithGroupBy: 2278 elapsed 662 ms
  172. 2019-09-14T12:26:04.680256 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 662 ms
  173. 2019-09-14T12:26:04.680299 I 35737 measure.h:72 Timer start fetchChunks fetchChunks: 1885
  174. 2019-09-14T12:26:04.680375 I 35737 measure.h:79 Timer end fetchChunks fetchChunks: 1885 elapsed 0 ms
  175. 2019-09-14T12:26:04.680515 I 35737 measure.h:72 Timer start executePlanWithGroupBy executePlanWithGroupBy: 2278
  176. 2019-09-14T12:26:04.680534 I 35737 measure.h:72 Timer start lauchGpuCode launchGpuCode: 195
  177. 2019-09-14T12:26:04.696428 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 678 ms
  178. 2019-09-14T12:26:04.696465 I 35737 measure.h:79 Timer end executePlanWithGroupBy executePlanWithGroupBy: 2278 elapsed 678 ms
  179. 2019-09-14T12:26:04.696491 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 678 ms
  180. 2019-09-14T12:26:04.724014 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 705 ms
  181. 2019-09-14T12:26:04.724051 I 35737 measure.h:79 Timer end executePlanWithGroupBy executePlanWithGroupBy: 2278 elapsed 705 ms
  182. 2019-09-14T12:26:04.724079 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 706 ms
  183. 2019-09-14T12:26:05.461724 I 35737 measure.h:79 Timer end lauchGpuCode launchGpuCode: 195 elapsed 781 ms
  184. 2019-09-14T12:26:05.461817 I 35737 measure.h:79 Timer end executePlanWithGroupBy executePlanWithGroupBy: 2278 elapsed 781 ms
  185. 2019-09-14T12:26:05.461846 I 35737 measure.h:79 Timer end execution_dispatch_run operator(): 1191 elapsed 1443 ms
  186. 2019-09-14T12:26:05.462124 I 35737 measure.h:79 Timer end Exec_executeWorkUnit executeWorkUnitImpl: 1137 elapsed 1445 ms
  187. 2019-09-14T12:26:05.462212 I 35737 measure.h:79 Timer end executeWorkUnit executeWorkUnit: 1902 elapsed 1454 ms
  188. 2019-09-14T12:26:05.462240 I 35737 measure.h:79 Timer end executeRelAlgStep executeRelAlgStep: 361 elapsed 1454 ms
  189. 2019-09-14T12:26:05.462258 I 35737 measure.h:72 Timer start executeRelAlgStep executeRelAlgStep: 361
  190. 2019-09-14T12:26:05.462694 I 35737 RelAlgExecutor.cpp:643 Assigned input (RelScan<139765373346608> A) to nest level 0
  191. 2019-09-14T12:26:05.462727 I 35737 RelAlgExecutor.cpp:643 Assigned input (RelProject<139765385265712> (RexInput 1 139765367590368) (RexOperator 19 (RexInput 0 139765367590368))) to nest level 1
  192. 2019-09-14T12:26:05.462782 I 35737 RelAlgExecutor.cpp:643 Assigned input (RelScan<139765373346608> A) to nest level 0
  193. 2019-09-14T12:26:05.462801 I 35737 RelAlgExecutor.cpp:643 Assigned input (RelProject<139765385265712> (RexInput 1 139765367590368) (RexOperator 19 (RexInput 0 139765367590368))) to nest level 1
  194. 2019-09-14T12:26:05.462912 I 35737 measure.h:72 Timer start executeWorkUnit executeWorkUnit: 1902
  195. 2019-09-14T12:26:05.462938 I 35737 measure.h:72 Timer start get_table_infos get_table_infos: 259
  196. 2019-09-14T12:26:05.463037 I 35737 measure.h:79 Timer end get_table_infos get_table_infos: 259 elapsed 0 ms
  197. 2019-09-14T12:26:05.463069 I 35737 measure.h:72 Timer start Exec_executeWorkUnit executeWorkUnitImpl: 1137
  198. 2019-09-14T12:26:05.463272 I 35737 measure.h:72 Timer start execution_dispatch_comp executeWorkUnitImpl: 1157
  199. 2019-09-14T12:26:05.463582 I 35737 measure.h:79 Timer end execution_dispatch_comp executeWorkUnitImpl: 1157 elapsed 0 ms
  200. 2019-09-14T12:26:05.463610 I 35737 measure.h:79 Timer end Exec_executeWorkUnit executeWorkUnitImpl: 1137 elapsed 0 ms
  201. 2019-09-14T12:26:05.463640 I 35737 measure.h:72 Timer start get_table_infos get_table_infos: 259
  202. 2019-09-14T12:26:05.463774 I 35737 measure.h:79 Timer end get_table_infos get_table_infos: 259 elapsed 0 ms
  203. 2019-09-14T12:26:05.463797 I 35737 measure.h:72 Timer start Exec_executeWorkUnit executeWorkUnitImpl: 1137
  204. 2019-09-14T12:26:05.463838 I 35737 measure.h:72 Timer start execution_dispatch_comp executeWorkUnitImpl: 1157
  205. 2019-09-14T12:26:05.465420 I 35737 measure.h:72 Timer start buildJoinLoops buildJoinLoops: 212
  206. 2019-09-14T12:26:08.377768 I 35737 measure.h:72 Timer start columnarize_result columnarize_result: 226
  207. 2019-09-14T12:26:18.556734 I 35737 measure.h:79 Timer end columnarize_result columnarize_result: 226 elapsed 10179 ms
  208. 2019-09-14T12:26:30.300866 1 35737 BaselineJoinHashTable.cpp:206 Caught exception while building baseline hash table: Hash tables with more than 2B entries not supported yet
  209. 2019-09-14T12:26:45.375315 I 35737 measure.h:79 Timer end buildJoinLoops buildJoinLoops: 212 elapsed 39909 ms
  210. 2019-09-14T12:26:45.375457 I 35737 measure.h:79 Timer end execution_dispatch_comp executeWorkUnitImpl: 1157 elapsed 39911 ms
  211. 2019-09-14T12:26:45.375513 I 35737 measure.h:79 Timer end Exec_executeWorkUnit executeWorkUnitImpl: 1137 elapsed 39911 ms
  212. 2019-09-14T12:26:45.375804 I 35737 measure.h:79 Timer end executeWorkUnit executeWorkUnit: 1902 elapsed 39912 ms
  213. 2019-09-14T12:26:45.375857 I 35737 measure.h:79 Timer end executeRelAlgStep executeRelAlgStep: 361 elapsed 39913 ms
  214. 2019-09-14T12:26:45.375879 I 35737 measure.h:79 Timer end executeRelAlgSeq executeRelAlgSeq: 300 elapsed 41367 ms
  215. 2019-09-14T12:26:45.552078 I 35737 measure.h:79 Timer end executeRelAlgQueryNoRetry executeRelAlgQueryNoRetry: 80 elapsed 41545 ms
  216. 2019-09-14T12:26:45.552173 I 35737 measure.h:79 Timer end executeRelAlgQuery executeRelAlgQuery: 57 elapsed 41545 ms
  217. 2019-09-14T12:26:45.552202 I 35737 measure.h:79 Timer end execute_rel_alg execute_rel_alg: 4359 elapsed 41545 ms
  218. 2019-09-14T12:26:45.552221 E 35737 MapDHandler.cpp:4936 Exception: Fatal error while attempting to build hash tables for join: Hash tables with more than 2B entries not supported yet
  219. 2019-09-14T12:26:45.552484 I 35737 MapDHandler.cpp:759 stdlog sql_execute 9 41609 TEST_DATABASE TEST_USER 601-UQvs {"query_str"} {"select sum(A.val) val1,A.sDate,A.sID from A join B on B.sID=A.sID and B.id=A.bID where A.sID=999888 group by A.sDate,A.sID;"}
  220. 2019-09-14T12:26:53.156039 1 35737 MapDHandler.cpp:382 stdlog_begin disconnect 10 0 TEST_DATABASE TEST_USER 601-UQvs
  221. 2019-09-14T12:26:53.156130 I 35737 MapDHandler.cpp:386 User TEST_USER disconnected from database TEST_DATABASE
  222.  
  223. 2019-09-14T12:26:53.156172 I 35737 MapDHandler.cpp:382 stdlog disconnect 10 0 TEST_DATABASE TEST_USER 601-UQvs
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!