title: Hive sidebar_position: 8
import {siteVariables} from ‘../../version’;
Overview
Hive Load Node can write data to hive. Using the flink dialect, the insert operation is currently supported, and the data in the upsert mode will be converted into insert. Manipulating hive tables using the hive dialect is currently not supported.
Supported Version
| Load Node | Version |
|---|---|
| Hive | Hive: 1.x, 2.x, 3.x |
Dependencies
Using Hive load requires the introduction of dependencies. Of course, you can also use INLONG to provide jar packages.(sort-connector-hive)
Maven dependency
How to create a Hive Load Node
Usage for SQL API
The example below shows how to create a Hive Load Node with Flink SQL Cli :
CREATE TABLE hiveTableName ( id STRING, name STRING, uv BIGINT, pv BIGINT ) WITH ( 'connector' = 'hive', 'default-database' = 'default', 'hive-version' = '3.1.2', 'hive-conf-dir' = 'hdfs://localhost:9000/user/hive/hive-site.xml' );
Usage for InLong Dashboard
Configuration
When creating a data stream, select Hive for the data stream direction, and click “Add” to configure it.
Usage for InLong Manager Client
TODO: It will be supported in the future.