Set Hive Configurations

Hi everyone,

How do I set these parameters in the SqlSourceSystem for my Hive connection?

-hiveconf -hiveconf hive.enforce.bucketing=true -hiveconf hive.exec.dynamic.partition.mode=nonstrict -hiveconf hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager -hiveconf hive.compactor.initiator.on=true -hiveconf hive.compactor.worker.threads=1

Many thanks!!

@lamarof Are these really connection level settings (as opposed to server side configuration)? If they are then you can try to set them as properties in the properties field of the SqlSourceCollection or provide the entire url (with the properties encoded into it). I’m not sure if either of those are supported by hive via jdbc or not. If that doesn’t work we would most likely need to add additional support for that.