1 STAGE DEPENDENCIES:
2 Stage-1 is a root stage
3 Stage-0 depends on stages: Stage-1
4
5 STAGE PLANS:
6 Stage: Stage-1
7 Map Reduce
8 Map Operator Tree:
9 TableScan
10 alias: tbl_a
11 filterExpr: (col_1 = 'aaa.com') (type: boolean)
12 Statistics: Num rows: 5275084 Data size: 1039193932 Basic stats: COMPLETE Column stats: PARTIAL
13 Filter Operator
14 predicate: (col_1 = 'aaa.com') (type: boolean)
15 Statistics: Num rows: 2637542 Data size: 485307728 Basic stats: COMPLETE Column stats: PARTIAL
16 Select Operator
17 expressions: date_local (type: string)
18 outputColumnNames: date_local
19 Statistics: Num rows: 2637542 Data size: 485307728 Basic stats: COMPLETE Column stats: PARTIAL
20 Group By Operator
21 aggregations: count()
22 keys: date_local (type: string), 'aaa.com' (type: string)
23 mode: hash
24 outputColumnNames: _col0, _col1, _col2
25 Statistics: Num rows: 1010 Data size: 291890 Basic stats: COMPLETE Column stats: PARTIAL
26 Reduce Output Operator
27 key expressions: _col0 (type: string), 'aaa.com' (type: string)
28 sort order: ++
29 Map-reduce partition columns: _col0 (type: string), 'aaa.com' (type: string)
30 Statistics: Num rows: 1010 Data size: 291890 Basic stats: COMPLETE Column stats: PARTIAL
31 value expressions: _col2 (type: bigint)
32 Reduce Operator Tree:
33 Group By Operator
34 aggregations: count(VALUE._col0)
35 keys: KEY._col0 (type: string), 'aaa.com' (type: string)
36 mode: mergepartial
37 outputColumnNames: _col0, _col1, _col2
38 Statistics: Num rows: 202 Data size: 58378 Basic stats: COMPLETE Column stats: PARTIAL
39 Select Operator
40 expressions: 'aaa.com' (type: string), _col0 (type: string), _col2 (type: bigint)
41 outputColumnNames: _col0, _col1, _col2
42 Statistics: Num rows: 202 Data size: 58378 Basic stats: COMPLETE Column stats: PARTIAL
43 File Output Operator
44 compressed: false
45 Statistics: Num rows: 202 Data size: 58378 Basic stats: COMPLETE Column stats: PARTIAL
46 table:
47 input format: org.apache.hadoop.mapred.SequenceFileInputFormat
48 output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
49 serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
50
51 Stage: Stage-0
52 Fetch Operator
53 limit: -1
54 Processor Tree:
55 ListSink
56
|