2.15 - 用于 Hive 发起程序连接器的 DESCRIBE 语法 - 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 发起程序连接器使用 DESCRIBE 语句从非本机远程表获取和显示元数据的情况。

jdbc:hive2://localhost:10000> DESCRIBE cardata_remote;

结果︰

+-----------+----------------+--------------------+--+
| col_name  |   data_type    |      comment       |
+-----------+----------------+--------------------+--+
| price     | double         | from deserializer  |
| mileage   | bigint         | from deserializer  |
| make      | varchar(2048)  | from deserializer  |
| model     | varchar(2048)  | from deserializer  |
| trim1     | varchar(2048)  | from deserializer  |
| type1     | varchar(2048)  | from deserializer  |
| cylinder  | int            | from deserializer  |
| liter     | double         | from deserializer  |
| doors     | int            | from deserializer  |
| cruise    | tinyint        | from deserializer  |
| sound     | tinyint        | from deserializer  |
| leather   | tinyint        | from deserializer  |
| dt        | varchar(2048)  | from deserializer  |
| country   | varchar(2048)  | from deserializer  |
+-----------+----------------+--------------------+--+
14 rows selected (0.877 seconds)