Query b1493cfca4c19e78:3447c3814a77d2ab

Status: OK

Plan

6496 (BCAST * 1)64966496827948303312483033124830331248303312483033124830331237556219230503050 (BCAST * 105)3755621924830331248303312106603314510660331454830331273394507318994813189948173394507
23:EXCHANGE
UNPARTITIONED
1 instance
Max: 15.260ms, avg: 15.260ms
22:AGGREGATE
FINALIZE
105 instances
Max: 195.437ms, avg: 18.516ms
21:EXCHANGE
HASH(REQUEST_MIN,MEMBERID,CATE3_ID)
105 instances
Max: 14.360ms, avg: 587.312us
12:AGGREGATE
STREAMING
105 instances
Max: 457.529ms, avg: 235.185ms
11:SELECT

105 instances
Max: 1s689ms, avg: 1s283ms
10:ANALYTIC

105 instances
Max: 9s772ms, avg: 7s232ms
09:SORT

105 instances
Max: 1m8s, avg: 1m1s
20:EXCHANGE
HASH(CAST(from_unixtime(unix_timestamp(CREATEDATE), 'yyyyMMddHHmm') AS BIGINT),MEMBERID,CATE3_ID)
105 instances
Max: 233.340ms, avg: 71.493ms
08:HASH JOIN
LEFT OUTER JOIN, BROADCAST
105 instances
Max: 288.580ms, avg: 91.978ms
07:HASH JOIN
LEFT OUTER JOIN, PARTITIONED
105 instances
Max: 438.254ms, avg: 190.288ms
17:EXCHANGE
HASH(PRODUCT_ID)
105 instances
Max: 2s040ms, avg: 61.999ms
18:EXCHANGE
HASH(PRODUCT_ID)
105 instances
Max: 255.095ms, avg: 192.879ms
19:EXCHANGE
BROADCAST
105 instances
Max: 426.820us, avg: 125.877us
04:SCAN_MYSQL_DATA SOURCE

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

105 instances
Max: 989.247ms, avg: 547.618ms
06:HASH JOIN
LEFT OUTER JOIN, PARTITIONED
105 instances
Max: 4s050ms, avg: 3s521ms
15:EXCHANGE
HASH(PRODUCTID)
105 instances
Max: 219.414ms, avg: 38.796ms
16:EXCHANGE
HASH(SKU_ID)
105 instances
Max: 791.378ms, avg: 588.516ms
02:SCAN_MYSQL_DATA SOURCE

105 instances
Max: 1s468ms, avg: 885.102ms
05:HASH JOIN
INNER JOIN, PARTITIONED
105 instances
Max: 402.219ms, avg: 339.439ms
13:EXCHANGE
HASH(ORDERID)
105 instances
Max: 59.802ms, avg: 29.600ms
14:EXCHANGE
HASH(ID)
105 instances
Max: 32.901ms, avg: 22.446ms
01:SCAN_MYSQL_DATA SOURCE

86 instances
Max: 3s824ms, avg: 1s988ms
00:SCAN_MYSQL_DATA SOURCE

105 instances
Max: 6s029ms, avg: 831.521ms