2.16 - Hiveイニシエータ コネクタのEXPLAIN構文 - Teradata QueryGrid

Teradata® QueryGrid™ インストールとユーザー ガイド

Product
Teradata QueryGrid
Release Number
2.16
Release Date
2021年6月
Content Type
インストール
ユーザー ガイド
構成
管理
Publication ID
B035-5991-061K-JPN
Language
日本語 (日本)

この例では、Teradataターゲット コネクタへのEXPLAINリクエストを開始するHiveを示します。

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