2.09 - 用于 Hive 发起程序连接器的 DESCRIBE 语法 - Teradata QueryGrid

Teradata® QueryGrid™ 安装和用户指南

prodname
Teradata QueryGrid
vrm_release
2.09
created_date
2019 年 5 月
category
安装
用户指南
管理
配置
featnum
B035-5991-059K-CHS

该示例展示了 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)