Hive – What are the metastore tables in Hive ?

user June 5, 2021 Leave a Comment on Hive – What are the metastore tables in Hive ?

Metastore is the central repository of Apache Hive metadata. It stores metadata for Hive tables

AUX_TABLE
BUCKETING_COLS
CDS
COLUMNS_V2
COMPACTION_QUEUE
COMPLETED_COMPACTIONS
COMPLETED_TXN_COMPONENTS
DATABASE_PARAMS
DBS
DB_PRIVS
DELEGATION_TOKENS
FUNCS
FUNC_RU
GLOBAL_PRIVS
HIVE_LOCKS
IDXS
INDEX_PARAMS
KEY_CONSTRAINTS
MASTER_KEYS
NEXT_COMPACTION_QUEUE_ID
NEXT_LOCK_ID
NEXT_TXN_ID
NOTIFICATION_LOG
NOTIFICATION_SEQUENCE
NUCLEUS_TABLES
PARTITIONS
PARTITION_EVENTS
PARTITION_KEYS
PARTITION_KEY_VALS
PARTITION_PARAMS
PART_COL_PRIVS
PART_COL_STATS
PART_PRIVS
ROLES
ROLE_MAP
SDS
SD_PARAMS
SEQUENCE_TABLE
SERDES
SERDE_PARAMS
SKEWED_COL_NAMES
SKEWED_COL_VALUE_LOC_MAP
SKEWED_STRING_LIST
SKEWED_STRING_LIST_VALUES
SKEWED_VALUES
SORT_COLS
TABLE_PARAMS
TAB_COL_STATS
TBLS
TBL_COL_PRIVS
TBL_PRIVS
TXNS
TXN_COMPONENTS
TYPES
TYPE_FIELDS
VERSION
WRITE_SET

Post Views: 177

Hive - Where can I get the hive metastore details (Credentials,Host,Server etc)
In General we don't deal directly with Hive metastore . But there are some situation…
How can I get all the hive tables and its external location,partitions etc ?
There may be some situations where you may need to give all the hive tables…
Hive : Different types of Hive execution engines
Hive is an open-source data warehouse tool built on top of Hadoop. It allows users…
Learn how to connect Hive with Apache Spark.
HiveContext is a Spark SQL module that allows you to work with Hive data in…
Hive : Role of Hive type coercion and how can you perform type coercion in Hive?
In Hive, type coercion is the process of converting one data type to another data…
Hive : Hive's dynamic partitioning and how can you use it in your Hive queries?
Hive's dynamic partitioning is a feature that enables the automatic partitioning of data in Hive…
Hive : How can you implement bucketing in Hive?
Hive allows you to store and analyze large volumes of data in a distributed environment.…
Hive : Hive optimizer - Detailed walk through
Hive is a popular open-source data warehouse system that allows users to store, manage, and…
Hive : Learn hive external functions and how can you use external functions in Hive?
Hive is built on top of Hadoop, which is a distributed file system and a…
How to delete a partition data as well from Hive external table on DROP command?
As you know external tables are tables where Hive does not manage the data of…