Run Hive Activity

Runs Hive DDL queries such as CREATE TABLE, DROP TABLE and ALTER TABLE.

Note

DataRow.io requires only Hive Metastore, the Hive queries will be executed in DataRow.io itself.

Activity Parameters

Name	Description	Type	Default
Title	Title of the activity to display on the designer.	text
Query	DDL SQL statement.	text

Job Parameters

Note

When using DataRow.io on AWS, these additional job parameters need to be set for Hive functionality to work properly.

Key	Value
datarow.hive.enabled	true
datarow.hive.javax.jdo.option.ConnectionURL	jdbc:${DBPROTO}://${DBHOST}/${DBNAME}?createDatabaseIfNotExist=true
datarow.hive.javax.jdo.option.ConnectionUserName	Metastore db username
datarow.hive.javax.jdo.option.ConnectionPassword	Metastore db password. Consider using vault with templating ${vault:secret-hive-password}
datarow.hive.javax.jdo.option.ConnectionDriverName	org.mariadb.jdbc.Driver|com.mysql.jdbc.Driver

Note

When using DataRow.io on AWS, these additional job parameters need to be set for accessing Glue Catalog.

Key	Value
datarow.hive.enabled	true
datarow.hive.hive.metastore.client.factory.class	com.amazonaws.glue.catalog.metastore.AWSGlueDataCatalogHiveClientFactory
datarow.hive.hive.metastore.glue.catalogid	Optional AWS Account ID