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;