Apache - Hive (HS|Hive Server) in Azure.
Hive comes with every cluster in Azure.
# public name
jdbc:hive2://CLUSTERNAME.azurehdinsight.net:443/default;transportMode=http;ssl=true;httpPath=/hive2
# private
jdbc:hive2://fqdn:10001/default;transportMode=http;httpPath=/hive2
Connection to a Spark Hive on a Spark cluster with Dbeaver.
where:
From hdinsight-java-hive-jdbc - pom.xml
<dependencies>
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-exec</artifactId>
<!-- Hive version for HDInsight 3.5/3.6 -->
<version>1.2.1</version>
</dependency>
<dependency>
<groupId>org.apache.hive</groupId>
<artifactId>hive-jdbc</artifactId>
<!-- Hive version for HDInsight 3.5/3.6 -->
<version>1.2.1</version>
</dependency>
<dependency>
<groupId>org.apache.hadoop</groupId>
<artifactId>hadoop-common</artifactId>
<!-- Hadoop version for HDInsight 3.5/3.6 -->
<version>2.7.3</version>
</dependency>
</dependencies>
All in one: hive-jdbc-1.2.1-standalone.jar
It must have the following jar files from the Hive Cluster as written in this documentation: Connect to Hive from JDBC
/usr/hdp/current/hadoop-client/hadoop-common.jar
/usr/hdp/current/hadoop-client/hadoop-auth.jar
/usr/hdp/current/hadoop-client/lib/log4j-*.jar
/usr/hdp/current/hadoop-client/lib/slf4j-*.jar
/usr/hdp/current/hive-client/lib/hive-*-1.2*.jar
/usr/hdp/current/hive-client/lib/httpclient-*.jar
/usr/hdp/current/hive-client/lib/httpcore-*.jar
/usr/hdp/current/hive-client/lib/libthrift-*.jar
/usr/hdp/current/hive-client/lib/libfb*.jar
/usr/hdp/current/hive-client/lib/commons-logging-*.jar
via public hostname of the cluster: see create hive odbc data source
Properties: