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)