Livy interpreter configuration

You can use the Hive Warehouse Connector in Zeppelin notebooks with the Livy interpreter by modifying or adding properties to your livy interpreter settings. The Livy interpreter accesses processing engines and data sources from the Zeppelin UI.

Requirements

  • Configurations require a livy prefilx.
  • A reference to the HWC jar on the local file system is required.

Interpreter properties

  • livy.spark.hadoop.hive.metastore.uris - thrift://<domain name>:<port>

    Example: thrift://hwc-secure-1.hwc-secure.root.hwx.site:9083

  • livy.spark.jars - local:/opt/cloudera/parcels/<version>/jars/hive-warehouse-connector-assembly-<version>.jar

    Example: local:/opt/cloudera/parcels/CDH-7.2.1-1.cdh7.2.1.p0.4847773/jars/hive-warehouse-connector-assembly-<version>.jar

    Use the local file ("local:").

  • livy.spark.kryo.registrator - com.qubole.spark.hiveacid.util.HiveAcidKyroRegistrator
  • livy.spark.security.credentials.hiveserver2.enabled- true
  • livy.spark.sql.extensions - com.hortonworks.spark.sql.rule.Extensions
  • livy.spark.sql.hive.hiveserver2.jdbc.url - jdbc:hive2://<domain name>:<port>/default;retries=5;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

    Example: jdbc:hive2://hwc-secure-1.hwc-secure.root.hwx.site:2181/default;retries=5;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

  • livy.spark.sql.hive.hiveserver2.jdbc.url.principal - hive/_HOST@ROOT.HWX.SITE