explane_hive

0: jdbc:hive2://localhost:10000/default> EXPLAIN select ch.basesum, chl.baseprice from check ch full join (select baseprice, checkuid from checkline limit 10) chl on chl.checkuid = ch.checkuid limit 10;
INFO  : Compiling command(queryId=hadoop_20190429141949_636504bd-fc56-451c-9406-7a2640327d42): EXPLAIN select ch.basesum, chl.baseprice from check ch full join (select baseprice, checkuid from checkline limit 10) chl on chl.checkuid = ch.checkuid limit 10
INFO  : Concurrency mode is disabled, not creating a lock manager
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=hadoop_20190429141949_636504bd-fc56-451c-9406-7a2640327d42); Time taken: 0.51 seconds
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Executing command(queryId=hadoop_20190429141949_636504bd-fc56-451c-9406-7a2640327d42): EXPLAIN select ch.basesum, chl.baseprice from check ch full join (select baseprice, checkuid from checkline limit 10) chl on chl.checkuid = ch.checkuid limit 10
INFO  : Starting task [Stage-3:EXPLAIN] in serial mode
INFO  : Completed executing command(queryId=hadoop_20190429141949_636504bd-fc56-451c-9406-7a2640327d42); Time taken: 0.061 seconds
INFO  : OK
INFO  : Concurrency mode is disabled, not creating a lock manager
+----------------------------------------------------+
|                      Explain                       |
+----------------------------------------------------+
| STAGE DEPENDENCIES:                                |
|   Stage-1 is a root stage                          |
|   Stage-0 depends on stages: Stage-1               |
|                                                    |
| STAGE PLANS:                                       |
|   Stage: Stage-1                                   |
|     Map Reduce                                     |
|       Map Operator Tree:                           |
|           TableScan                                |
|             alias: ch                              |
|             properties:                            |
|               druid.fieldNames basesum,checkuid    |
|               druid.fieldTypes float,string        |
|               druid.query.json {"queryType":"scan","dataSource":"checks","intervals":["1900-01-01T00:00:00.000Z/3000-01-01T00:00:00.000Z"],"columns":["basesum","checkuid"],"resultFormat":"compactedList"} |
|               druid.query.type scan                |
|             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|             Reduce Output Operator                 |
|               key expressions: checkuid (type: string) |
|               sort order: +                        |
|               Map-reduce partition columns: checkuid (type: string) |
|               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|               value expressions: basesum (type: float) |
|           TableScan                                |
|             alias: checkline                       |
|             properties:                            |
|               druid.fieldNames baseprice,checkuid  |
|               druid.fieldTypes float,string        |
|               druid.query.json {"queryType":"scan","dataSource":"checklines","intervals":["1900-01-01T00:00:00.000Z/3000-01-01T00:00:00.000Z"],"columns":["baseprice","checkuid"],"resultFormat":"compactedList","limit":10} |
|               druid.query.type scan                |
|             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|             Reduce Output Operator                 |
|               key expressions: checkuid (type: string) |
|               sort order: +                        |
|               Map-reduce partition columns: checkuid (type: string) |
|               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|               value expressions: baseprice (type: float) |
|       Reduce Operator Tree:                        |
|         Join Operator                              |
|           condition map:                           |
|                Outer Join 0 to 1                   |
|           keys:                                    |
|             0 checkuid (type: string)              |
|             1 checkuid (type: string)              |
|           outputColumnNames: _col0, _col5          |
|           Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|           Select Operator                          |
|             expressions: _col0 (type: float), _col5 (type: float) |
|             outputColumnNames: _col0, _col1        |
|             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|             Limit                                  |
|               Number of rows: 10                   |
|               Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|               File Output Operator                 |
|                 compressed: false                  |
|                 Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE |
|                 table:                             |
|                     input format: org.apache.hadoop.mapred.SequenceFileInputFormat |
|                     output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat |
|                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe |
|                                                    |
|   Stage: Stage-0                                   |
|     Fetch Operator                                 |
|       limit: 10                                    |
|       Processor Tree:                              |
|         ListSink                                   |
|                                                    |
+----------------------------------------------------+
66 rows selected (0,733 seconds)