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