You can use the Apache Hive catalog source to extract metadata from an Apache Hive source system.
Apache Hive is a data warehouse software built on Apache Hadoop, used to query large datasets from various databases and file systems.
Extracted metadata
You can use the Apache Hive catalog source to extract metadata from an Apache Hive source.
Metadata Command Center extracts the following metadata from the Apache Hive source system:
•Database
•Schema
•Table
•Column
•External Table
•External Column
•View
•View Column
•Materialized View
Note:
Objects of the Materialized View type appear as View in
Data Governance and Catalog
.
Data profiling for Apache Hive objects
Configure data profiling to run profiles on the metadata extracted from an Apache Hive source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on the following objects:
•Views
•Tables
•External tables created in the following file formats:
- AVRO
- Parquet
- Delimited
- JSON
The data profiling task runs profiles on the following data types:
•bigint
•boolean
•char
•date
•decimal
•double
•float
•integer
•smallint
•string
•timestamp
•tinyint
•varchar
Compatible connectors
Before you configure an Apache Hive catalog source, you must connect to the Apache Hive source system.
Use Hive Connector to connect to the Apache Hive source system.
For information about configuring a connection, see Connections.