2.15 - 用于 Spark SQL 发起程序连接器的 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
中文 (简体)

以下示例展示了 Spark SQL 向 Teradata 目标连接器发起 EXPLAIN 请求的情况。

scala> ForeignServer.sql("explain select name from default.nn1 where number = 10")
+------------------------------------------------------------------------------------+
|plan                                                                                 +------------------------------------------------------------------------------------+
|== Physical Plan ==
*Project [name#25]
+- *Filter (isnotnull(number#24) && (number#24 = 10))
   +- *Scan com.teradata.querygrid.qgc.spark.QGRelation@4ec78008 default.nn1[name#25,number#24] PushedFilters: [IsNotNull(number), EqualTo(number,10)], ReadSchema: struct<name:string>|
+------------------------------------------------------------------------------------+

scala> ForeignServer.sql("explain insert into default.nn1 select * from players2")
+------------------------------------------------------------------------------------+
|plan                                          
+------------------------------------------------------------------------------------+
|== Physical Plan ==
ExecutedCommand
   +- InsertIntoDataSourceCommand Relation[number#24,name#25] com.teradata.querygrid.qgc.spark.QGRelation@4ec78008, OverwriteOptions(false,Map())
         +- MetastoreRelation default, players2
+------------------------------------------------------------------------------------+