Query 1940d3deac0d71ea:9bf0c38962bdcfaa

Status: OK

Plan

6539 (BCAST * 1)65396539833248320412483204124832041248320412483204124832041237555444730503050 (BCAST * 112)3755544474832041248320412106599003510659900354832041273394507319094423190944273394507
23:EXCHANGE
UNPARTITIONED
1 instance
Max: 43.557ms, avg: 43.557ms
22:AGGREGATE
FINALIZE
112 instances
Max: 84.449ms, avg: 16.374ms
21:EXCHANGE
HASH(REQUEST_MIN,MEMBERID,CATE3_ID)
112 instances
Max: 2.265ms, avg: 656.762us
12:AGGREGATE
STREAMING
112 instances
Max: 776.055ms, avg: 639.363ms
11:SELECT

112 instances
Max: 2s968ms, avg: 2s417ms
10:ANALYTIC

112 instances
Max: 16s982ms, avg: 13s966ms
09:SORT

112 instances
Max: 2m25s, avg: 1m48s
20:EXCHANGE
HASH(CAST(from_unixtime(unix_timestamp(CREATEDATE), 'yyyyMMddHHmm') AS BIGINT),MEMBERID,CATE3_ID)
112 instances
Max: 310.959ms, avg: 244.671ms
08:HASH JOIN
LEFT OUTER JOIN, BROADCAST
112 instances
Max: 358.227ms, avg: 129.069ms
07:HASH JOIN
LEFT OUTER JOIN, PARTITIONED
112 instances
Max: 406.298ms, avg: 183.659ms
17:EXCHANGE
HASH(PRODUCT_ID)
112 instances
Max: 3s479ms, avg: 204.826ms
18:EXCHANGE
HASH(PRODUCT_ID)
112 instances
Max: 1s374ms, avg: 1s085ms
19:EXCHANGE
BROADCAST
112 instances
Max: 2.129ms, avg: 1.016ms
04:SCAN_MYSQL_DATA SOURCE

1 instance
Max: 11.646ms, avg: 11.646ms
03:SCAN_MYSQL_DATA SOURCE

112 instances
Max: 1s597ms, avg: 992.407ms
06:HASH JOIN
LEFT OUTER JOIN, PARTITIONED
112 instances
Max: 5s875ms, avg: 4s784ms
15:EXCHANGE
HASH(PRODUCTID)
112 instances
Max: 616.696ms, avg: 178.297ms
16:EXCHANGE
HASH(SKU_ID)
112 instances
Max: 3s796ms, avg: 3s025ms
02:SCAN_MYSQL_DATA SOURCE

112 instances
Max: 1s976ms, avg: 1s373ms
05:HASH JOIN
INNER JOIN, PARTITIONED
112 instances
Max: 783.078ms, avg: 581.173ms
13:EXCHANGE
HASH(ORDERID)
112 instances
Max: 235.509ms, avg: 187.052ms
14:EXCHANGE
HASH(ID)
112 instances
Max: 205.430ms, avg: 121.143ms
01:SCAN_MYSQL_DATA SOURCE

85 instances
Max: 4s091ms, avg: 3s027ms
00:SCAN_MYSQL_DATA SOURCE

112 instances
Max: 2s723ms, avg: 1s895ms