Apache Gravitino Flink connector
Overview
The Apache Gravitino Flink connector implements the Catalog Store to manage the catalogs under Gravitino. This capability allows users to perform federation queries, accessing data from various catalogs through a unified interface and consistent access control.
Capabilities
- Supports Hive catalog
- Supports Iceberg catalog
- Supports Paimon catalog
- Supports Jdbc catalog
- Supports most DDL and DML SQLs.
Requirement
- Flink 1.18
- Scala 2.12
- JDK 8, 11 or 17
How to use it
-
Build or download the Gravitino flink connector runtime jar, and place it to the classpath of Flink.
-
Configure the Flink configuration to use the Gravitino flink connector.
| Property | Type | Default Value | Description | Required | Since Version |
|---|---|---|---|---|---|
| table.catalog-store.kind | string | generic_in_memory | The Catalog Store name, it should set to gravitino. | Yes | 0.6.0-incubating |
| table.catalog-store.gravitino.gravitino.metalake | string | (none) | The metalake name that flink connector used to request to Gravitino. | Yes | 0.6.0-incubating |
| table.catalog-store.gravitino.gravitino.uri | string | (none) | The uri of Gravitino server address. | Yes | 0.6.0-incubating |
| table.catalog-store.gravitino.gravitino.client. | string | (none) | The configuration key prefix for the Gravitino client config. | No | 1.0.0 |
To configure the Gravitino client, use properties prefixed with table.catalog-store.gravitino.gravitino.client.. These properties will be passed to the Gravitino client after removing the table.catalog-store.gravitino. prefix.
Example: Setting table.catalog-store.gravitino.gravitino.client.socketTimeoutMs is equivalent to setting gravitino.client.socketTimeoutMs for the Gravitino client.
Note: Invalid configuration properties will result in exceptions. Please see Gravitino Java client configurations for more support client configuration.
Set the flink configuration in flink-conf.yaml.
table.catalog-store.kind: gravitino
table.catalog-store.gravitino.gravitino.metalake: metalake_demo
table.catalog-store.gravitino.gravitino.uri: http://localhost:8090
table.catalog-store.gravitino.gravitino.client.socketTimeoutMs: 60000
table.catalog-store.gravitino.gravitino.client.connectionTimeoutMs: 60000
Or you can set the flink configuration in the TableEnvironment.
final Configuration configuration = new Configuration();
configuration.setString("table.catalog-store.kind", "gravitino");
configuration.setString("table.catalog-store.gravitino.gravitino.metalake", "metalake_demo");
configuration.setString("table.catalog-store.gravitino.gravitino.uri", "http://localhost:8090");
configuration.setString("table.catalog-store.gravitino.gravitino.client.socketTimeoutMs", "60000");
configuration.setString("table.catalog-store.gravitino.gravitino.client.connectionTimeoutMs", "60000");
EnvironmentSettings.Builder builder = EnvironmentSettings.newInstance().withConfiguration(configuration);
TableEnvironment tableEnv = TableEnvironment.create(builder.inBatchMode().build());
- Add necessary jar files to Flink's classpath.
To run Flink with Gravitino connector and then access the data source like Hive, you may need to put additional jars to Flink's classpath. You can refer to the Flink document for more information.
- Execute the Flink SQL query.
Suppose there is only one hive catalog with the name catalog_hive in the metalake metalake_demo.
// use hive catalog
USE CATALOG catalog_hive;
CREATE DATABASE db;
USE db;
SET 'execution.runtime-mode' = 'batch';
SET 'sql-client.execution.result-mode' = 'tableau';
CREATE TABLE hive_students (id INT, name STRING);
INSERT INTO hive_students VALUES (1, 'Alice'), (2, 'Bob');
SELECT * FROM hive_students;
Datatype mapping
Gravitino flink connector support the following datatype mapping between Flink and Gravitino.
| Flink Type | Gravitino Type | Since Version |
|---|---|---|
array | list | 0.6.0-incubating |
bigint | long | 0.6.0-incubating |
binary | fixed | 0.6.0-incubating |
boolean | boolean | 0.6.0-incubating |
char | char | 0.6.0-incubating |
date | date | 0.6.0-incubating |
decimal | decimal | 0.6.0-incubating |
double | double | 0.6.0-incubating |
float | float | 0.6.0-incubating |
integer | integer | 0.6.0-incubating |
map | map | 0.6.0-incubating |
null | null | 0.6.0-incubating |
row | struct | 0.6.0-incubating |
smallint | short | 0.6.0-incubating |
time | time | 0.6.0-incubating |
timestamp | timestamp without time zone | 0.6.0-incubating |
timestamp without time zone | timestamp without time zone | 0.6.0-incubating |
timestamp with time zone | timestamp with time zone | 0.6.0-incubating |
timestamp with local time zone | timestamp with time zone | 0.6.0-incubating |
timestamp_ltz | timestamp with time zone | 0.6.0-incubating |
tinyint | byte | 0.6.0-incubating |
varbinary | binary | 0.6.0-incubating |
varchar | string | 0.6.0-incubating |