gistfile1.txt

0: jdbc:hive2://localhost:10000/default> EXPLAIN select ch.basesum 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_20190428185334_b3e15ce0-71d2-4b24-89dc-7fbc475b0208): EXPLAIN select ch.basesum 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_20190428185334_b3e15ce0-71d2-4b24-89dc-7fbc475b0208); Time taken: 0.219 seconds
INFO  : Concurrency mode is disabled, not creating a lock manager
INFO  : Executing command(queryId=hadoop_20190428185334_b3e15ce0-71d2-4b24-89dc-7fbc475b0208): EXPLAIN select ch.basesum 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_20190428185334_b3e15ce0-71d2-4b24-89dc-7fbc475b0208); Time taken: 0.017 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 checkuid            |
|               druid.fieldTypes string              |
|               druid.query.json {"queryType":"scan","dataSource":"checklines","intervals":["1900-01-01T00:00:00.000Z/3000-01-01T00:00:00.000Z"],"columns":["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 |
|       Reduce Operator Tree:                        |
|         Join Operator                              |
|           condition map:                           |
|                Outer Join 0 to 1                   |
|           keys:                                    |
|             0 checkuid (type: string)              |
|             1 checkuid (type: string)              |
|           outputColumnNames: _col0                 |
|           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                                   |
|                                                    |
+----------------------------------------------------+