DESCRIBE | Hive Initiator Connector | QueryGrid - DESCRIBE Syntax for the Hive Initiator Connector - Teradata QueryGrid

QueryGridâ„¢ Installation and User Guide - 3.06

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata QueryGrid
Release Number
3.06
Published
December 2024
ft:locale
en-US
ft:lastEdition
2024-12-07
dita:mapPath
ndp1726122159943.ditamap
dita:ditavalPath
ft:empty
dita:id
lxg1591800469257
Product Category
Analytical Ecosystem

The example shows the Hive initiator connector using the DESCRIBE statement to fetch and display metadata from a non-native remote table.

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

Result:

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