2.15 - 用于 Hive 发起程序连接器的 EXPLAIN 语法 - Teradata QueryGrid

Teradata® QueryGrid™ 安装和用户指南

Product
Teradata QueryGrid
Release Number
2.15
Release Date
2021 年 3 月
Content Type
安装
用户指南
管理
配置
Publication ID
B035-5991-031K-CHS
Language
中文 (简体)

该示例展示了 Hive 向 Teradata 目标连接器发起 EXPLAIN 请求的情况。

jdbc:hive2://localhost:10000> EXPLAIN SELECT * FROM cardata_remote;

结果︰

+--------------------------------------------------------------------------------------+--+
| 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: cardata_remote
|             Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE
|             Select Operator
|               expressions: price (type: double), mileage (type: bigint), 
|                 make (type: varchar(2048)), model (type: varchar(2048)),
|                  trim1 (type: varchar(2048)), 
|                  type1 (type: varchar(2048)), 
|                  cylinder (type: int), 
|                  liter (type: double), 
|                  doors (type: int), 
|                  cruise (type: tinyint), 
|                  sound (type: tinyint), 
|                  leather (type: tinyint), 
|                  dt (type: varchar(2048)), 
|                  country (type: varchar(2048))
|               outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, 
|                  _col7, _col8, _col9, _col10, _col11, _col12, _col13 
|               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.TextInputFormat
|                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
|                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
|
|   Stage: Stage-0
|     Fetch Operator 
|       limit: -1
|       Processor Tree: 
|         ListSink  
|
+--------------------------------------------------------------------------------------+--+