Apache Hive

Features

Feature Info

Type

Relational

Driver

Included

Version Included

3.1.3

Hop Dependencies

None

Documentation

Documentation Link

JDBC Url

jdbc:hive2://<host:port>,<host2:port2>/databaseName

Driver folder

Hop Installation/plugins/databases/hive/lib

Partitions

Apache Hive need to have a PARTITION clause generated before the fields definition. To do this you can add table and clause definitions in the specific Hive field called 'Table-partition clauses'. This is the format to specify:

TABLE1(CLAUSE1);SCHEMA2.TABLE2(CLAUSE2)

For example, if you want to partition a customers table by statecode dynamically, you can add the following: customers(statecode) and for INSERT INTO statement Hop will add PARTITION(statecode).

HINT: for dynamic partitioning you can add the following statements in the advanced tab of the RDBMS metadata as statements to run right after connecting:

SET hive.exec.dynamic.partition = true;
SET hive.exec.dynamic.partition.mode = nonstrict;