Apache Hive
Features
| Feature | Info |
|---|---|
Type | Relational |
Driver | Included |
Version Included | 3.1.3 |
Hop Dependencies | None |
Documentation | |
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;