Apache Hive

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;