Hive 执行计划

explain  select
 channel,store_id
 ,sum(orders) as orders
 ,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,store_id
order by channel,store_id
;
+----------------------------------------+
|                Explain                 |
+----------------------------------------+
| Plan optimized by CBO.                 |
|                                        |
| Stage-0                                |
|   Fetch Operator                       |
|     Cached Query Result:true,limit:-1  |
|                                        |
+----------------------------------------+

 

explain extended  select
 channel,store_id
 ,sum(orders) as orders
 ,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,store_id
order by channel,store_id
;
+----------------------------------------------------+
|                      Explain                       |
+----------------------------------------------------+
| OPTIMIZED SQL: SELECT `channel`, `store_id`, SUM(`orders`) AS `$f2`, SUM(`sum_gmv`) AS `$f3` |
| FROM `vn09jj5`.`test3_orderline_1094_controlstore_offline_summary` |
| WHERE `paid_date` >= DATE '2020-09-01'             |
| GROUP BY `store_id`, `channel`                     |
| ORDER BY `channel`, `store_id`                     |
| STAGE DEPENDENCIES:                                |
|   Stage-0 is a root stage                          |
|                                                    |
| STAGE PLANS:                                       |
|   Stage: Stage-0                                   |
|     Fetch Operator                                 |
|       limit: -1                                    |
|       Processor Tree:                              |
|         ListSink                                   |
|       Cached Query Result: true                    |
|                                                    |
+----------------------------------------------------+

 

 

explain  select
 channel,paid_date,store_id
 ,sum(orders) as orders
 ,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,paid_date,store_id
order by store_id,channel,paid_date
;

INFO  : Compiling command(queryId=hive_20200914081330_2ad529c6-18e2-4b85-b7fe-2ea2bc549927): explain  select
channel,paid_date,store_id
,sum(orders) as orders
,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,paid_date,store_id
order by store_id,channel,paid_date
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:Explain, type:string, comment:null)], properties:null)
INFO  : Completed compiling command(queryId=hive_20200914081330_2ad529c6-18e2-4b85-b7fe-2ea2bc549927); Time taken: 0.501 seconds
INFO  : Executing command(queryId=hive_20200914081330_2ad529c6-18e2-4b85-b7fe-2ea2bc549927): explain  select
channel,paid_date,store_id
,sum(orders) as orders
,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,paid_date,store_id
order by store_id,channel,paid_date
INFO  : Starting task [Stage-1:EXPLAIN] in serial mode
INFO  : Completed executing command(queryId=hive_20200914081330_2ad529c6-18e2-4b85-b7fe-2ea2bc549927); Time taken: 0.022 seconds
INFO  : OK
+----------------------------------------+
|                Explain                 |
+----------------------------------------+
| Plan optimized by CBO.                 |
|                                        |
| Stage-0                                |
|   Fetch Operator                       |
|     Cached Query Result:true,limit:-1  |
|                                        |
+----------------------------------------+

 

explain extended  select
 channel,paid_date,store_id
 ,sum(orders) as orders
 ,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,paid_date,store_id
order by store_id,channel,paid_date
;

INFO  : Compiling command(queryId=hive_20200914081356_635475af-f828-43c3-b315-a78ee453eedc): explain extended select
channel,paid_date,store_id
,sum(orders) as orders
,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,paid_date,store_id
order by store_id,channel,paid_date
INFO  : Semantic Analysis Completed (retrial = false)
INFO  : Returning Hive schema: Schema(fieldSchemas:[FieldSchema(name:Explain, type:string, comment:null)], properties:null)
INFO  : Completed compiling command(queryId=hive_20200914081356_635475af-f828-43c3-b315-a78ee453eedc); Time taken: 0.366 seconds
INFO  : Executing command(queryId=hive_20200914081356_635475af-f828-43c3-b315-a78ee453eedc): explain extended select
channel,paid_date,store_id
,sum(orders) as orders
,sum(sum_gmv) as sales
from vn09jj5.test3_orderline_1094_controlstore_offline_summary
where paid_date>='2020-09-01'
group by channel,paid_date,store_id
order by store_id,channel,paid_date
INFO  : Starting task [Stage-1:EXPLAIN] in serial mode
INFO  : Completed executing command(queryId=hive_20200914081356_635475af-f828-43c3-b315-a78ee453eedc); Time taken: 0.012 seconds
INFO  : OK
+----------------------------------------------------+
|                      Explain                       |
+----------------------------------------------------+
| OPTIMIZED SQL: SELECT `channel`, `paid_date`, `store_id`, SUM(`orders`) AS `$f3`, SUM(`sum_gmv`) AS `$f4` |
| FROM `vn09jj5`.`test3_orderline_1094_controlstore_offline_summary` |
| WHERE `paid_date` >= DATE '2020-09-01'             |
| GROUP BY `store_id`, `channel`, `paid_date`        |
| ORDER BY `store_id`, `channel`, `paid_date`        |
| STAGE DEPENDENCIES:                                |
|   Stage-0 is a root stage                          |
|                                                    |
| STAGE PLANS:                                       |
|   Stage: Stage-0                                   |
|     Fetch Operator                                 |
|       limit: -1                                    |
|       Processor Tree:                              |
|         ListSink                                   |
|       Cached Query Result: true                    |
|                                                    |
+----------------------------------------------------+