CODEWITHSUNDEEP
hadoophivedata-dictionary
swts
swts

Reputation: 31

Does hive have a data dictionary?

Does hive have a data dictionary? I am trying to fetch the column names of tables in hive. Similar to oracle query other than describe command:

SELECT COLUMN_NAME,DATA_TYPE FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = ? ORDER BY COLUMN_ID;

Upvotes: 1

Views: 6468

Answers (2)

Tanveer
Tanveer

Reputation: 900

Hive works in three configurations:

  1. Local: In local configuration meta-store is stored in a relational database. But it runs in same JVM's.
  2. Remote: In this configuration meta-store is stored in a relational database but database is located remote. And runs in a separate JVM.
  3. Embedded: In embedded configuration meta store is a derby database. This database comes with Hive. And runs in the same jvm as Hive Services, Hive Client and Meta Store.This is called as embedded configuration.

Upvotes: 0

Remus Rusanu
Remus Rusanu

Reputation: 294407

Hive uses an external relational database as its metastore. You can query the configured metastore directly, using the metastore API (eg. MySQL). A higher level component is HCatalog, which offers an API to access and manipulate the metastore.

Upvotes: 1

Related Questions