この例では、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)