| title | slug | date | keyword | license |
|---|---|---|---|---|
Apache Hive catalog |
/apache-hive-catalog |
2023-12-10 |
hive catalog |
Copyright 2023 Datastrato Pvt Ltd. This software is licensed under the Apache License version 2. |
Gravitino offers the capability to utilize Apache Hive as a catalog for metadata management.
- The Hive catalog requires a Hive Metastore Service (HMS), or a compatible implementation of the HMS, such as AWS Glue.
- The Gravitino must have network access to the Hive metastore service with the Thrift protocol.
:::note The Hive catalog is available for Apache Hive 2.x only. Support for Apache Hive 3.x is under development. :::
The Hive catalog supports creating, updating, and deleting databases and tables in the HMS.
| Property Name | Description | Default Value | Required | Since Version |
|---|---|---|---|---|
metastore.uris |
The Hive metastore service URIs, separate multiple addresses with commas. Such as thrift://127.0.0.1:9083 |
(none) | Yes | 0.2.0 |
client.pool-size |
The maximum number of Hive metastore clients in the pool for Gravitino. | 1 | No | 0.2.0 |
gravitino.bypass. |
Property name with this prefix passed down to the underlying HMS client for use. Such as gravitino.bypass.hive.metastore.failure.retries = 3 indicate 3 times of retries upon failure of Thrift metastore calls |
(none) | No | 0.2.0 |
Please refer to Manage Metadata Using Gravitino for more details.
The Hive catalog supports to create, update, and delete databases in the HMS.
Schema properties supply or set metadata for the underlying Hive database. The following table lists predefined schema properties for the Hive database. Additionally, you can define your own key-value pair properties and transmit them to the underlying Hive database.
| Property name | Description | Default value | Required | Since Version |
|---|---|---|---|---|
location |
The directory for Hive database storage. Such as /user/hive/warehouse. |
HMS uses the value of hive.metastore.warehouse.dir in the hive-site.xml by default. |
No | 0.1.0 |
see Manage Metadata Using Gravitino.
The Hive catalog supports creating, updating, and deleting of tables in the HMS.
The Hive catalog supports partitioned tables. Users can create partitioned tables in the Hive catalog with the specific partitioning attribute.
Although Gravitino supports several partitioning strategies, the Apache Hive inherently only supports a single partitioning strategy (partitioned by column), therefore the Hive catalog only supports Identity partitioning.
:::caution
The fieldName specified in the partitioning attribute must be a column defined in the table.
:::
The Hive catalog supports bucketed sorted tables. Users can create bucketed sorted tables in the Hive catalog with specific distribution and sortOrders attributes.
Although Gravitino supports several distribution strategies, the Apache Hive inherently only supports a single distribution strategy (clustered by column), therefore the Hive catalog only supports Hash distribution.
:::caution
The fieldName specified in the distribution and sortOrders attribute must be a column defined in the table.
:::
The Hive catalog supports all data types defined in the Hive Language Manual. The following table lists the data types mapped from the Hive catalog to the Gravitino.
| Hive Data Type | Gravitino Data Type | Since Version |
|---|---|---|
boolean |
boolean |
0.2.0 |
tinyint |
byte |
0.2.0 |
smallint |
short |
0.2.0 |
int/integer |
integer |
0.2.0 |
bigint |
long |
0.2.0 |
float |
float |
0.2.0 |
double/double precision |
double |
0.2.0 |
decimal |
decimal |
0.2.0 |
string |
string |
0.2.0 |
char |
char |
0.2.0 |
varchar |
varchar |
0.2.0 |
timestamp |
timestamp |
0.2.0 |
date |
date |
0.2.0 |
interval_year_month |
interval_year |
0.2.0 |
interval_day_time |
interval_day |
0.2.0 |
binary |
binary |
0.2.0 |
array |
array |
0.2.0 |
map |
map |
0.2.0 |
struct |
struct |
0.2.0 |
uniontype |
uniontype |
0.2.0 |
Table properties supply or set metadata for the underlying Hive tables. The following table lists predefined table properties for the Hive table. Additionally, you can define your own key-value pair properties and transmit them to the underlying Hive database.
| Property Name | Description | Default Value | Required | Since version |
|---|---|---|---|---|
location |
The location for table storage. Such as /user/hive/warehouse/test_table. |
HMS uses the database location as the parent directory by default. | No | 0.2.0 |
table-type |
Type of the table. Valid values include MANAGED_TABLE and EXTERNAL_TABLE. |
MANAGED_TABLE |
No | 0.2.0 |
format |
The table file format. Valid values include TEXTFILE, SEQUENCEFILE, RCFILE, ORC, PARQUET, AVRO, JSON, CSV, and REGEX. |
TEXTFILE |
No | 0.2.0 |
input-format |
The input format class for the table. Such as org.apache.hadoop.hive.ql.io.orc.OrcInputFormat. |
The property format sets the default value org.apache.hadoop.mapred.TextInputFormat and can change it to a different default. |
No | 0.2.0 |
output-format |
The output format class for the table. Such as org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat. |
The property format sets the default value org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat and can change it to a different default. |
No | 0.2.0 |
serde-lib |
The serde library class for the table. Such as org.apache.hadoop.hive.ql.io.orc.OrcSerde. |
The property format sets the default value org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe and can change it to a different default. |
No | 0.2.0 |
serde.parameter. |
The prefix of the serde parameter. Such as "serde.parameter.orc.create.index" = "true" indicate ORC serde lib to create row indexes |
(none) | No | 0.2.0 |
Hive automatically adds and manages some reserved properties. Users aren't allowed to set these properties.
| Property Name | Description | Since Version |
|---|---|---|
comment |
Used to store the table comment. | 0.2.0 |
numFiles |
Used to store the number of files in the table. | 0.2.0 |
totalSize |
Used to store the total size of the table. | 0.2.0 |
EXTERNAL |
Indicates whether the table is external. | 0.2.0 |
transient_lastDdlTime |
Used to store the last DDL time of the table. | 0.2.0 |
Please refer to Manage Metadata Using Gravitino for more details.
Gravitino has already defined a unified set of metadata operation interfaces, and almost all Hive Alter operations have corresponding table update request which enable you to change the struct of an existing table. The following table lists the mapping relationship between Hive Alter operations and the Gravitino table update requests.
| Hive Alter Operation | Gravitino Table Update Request | Since Version |
|---|---|---|
Rename Table |
Rename table |
0.2.0 |
Alter Table Properties |
Set a table property |
0.2.0 |
Alter Table Comment |
Update comment |
0.2.0 |
Alter SerDe Properties |
Set a table property |
0.2.0 |
Remove SerDe Properties |
Remove a table property |
0.2.0 |
Alter Table Storage Properties |
Unsupported | - |
Alter Table Skewed or Stored as Directories |
Unsupported | - |
Alter Table Constraints |
Unsupported | - |
:::note
As Gravitino has a separate interface for updating the comment of a table, the Hive catalog sets comment as a reserved property for the table, preventing users from setting the comment property, Although Apache Hive changes the comment of a table by modifying the comment property of the table.
:::
| Hive Alter Operation | Gravitino Table Update Request | Since Version |
|---|---|---|
Change Column Name |
Rename a column |
0.2.0 |
Change Column Type |
Update the type of a column |
0.2.0 |
Change Column Position |
Update the position of a column |
0.2.0 |
Change Column Comment |
Update the column comment |
0.2.0 |
:::note Support for altering partitions is under development. :::