#Hive odbc excel drivers#
:::image type="content" source="./media/apache-hadoop-connect-hive-jdbc-driver/hdinsight-squirreldrivers.png" alt-text="Drivers tab on the left of the window" border="true":::įrom the icons at the top of the Drivers dialog, select the + icon to create a driver. From the left of the window, select Drivers.
#Hive odbc excel code#
For example, the following Java code opens a new connection: From JDBC clients such as SQuirreL SQL, enter admin name and password in client settings.įrom a Java application, you must use the name and password when establishing a connection. When establishing the connection, use the HDInsight cluster admin name and password to authenticate. These ports aren't exposed to the outside. You can't connect to HiveServer 2 directly on ports 10001 or 10000. HDInsight is a managed service, which means all connections to the cluster are managed via a secure Gateway. You can only use port 443 to connect to the cluster from some places outside of the Azure virtual network. Host name '' in the connection string is the same as your cluster URL. :::image type="content" source="./media/apache-hadoop-connect-hive-jdbc-driver/hdinsight-get-connection-string-through-ambari.png" alt-text="Get JDBC connection string through Ambari" border="true"::: Host name in connection string Or you can get the connection through Ambari UI > Hive > Configs > Advanced. Replace CLUSTERNAME with the name of your HDInsight cluster. Jdbc:hive2://:443/default transportMode=http ssl=true httpPath=/hive2
0 kommentar(er)
