2.15 - Sintaxis de EXPLAIN para el conector de iniciador de Hive - Teradata QueryGrid

Teradata® QueryGrid™ Guía de instalación y uso

Product
Teradata QueryGrid
Release Number
2.15
Release Date
Marzo de 2021
Content Type
Administración
Configuración
Guía del usuario
Instalación
Publication ID
B035-5991-031K-ESN
Language
Español (España)

El ejemplo muestra cómo Hive inicia una solicitud EXPLAIN para un conector de destino de Teradata.

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

Resultado:

+--------------------------------------------------------------------------------------+--+
| 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  
|
+--------------------------------------------------------------------------------------+--+