We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date

how to connect HIVE from sql workbench

Hi Team, 

have installed studio in some other server and want to connect from sql workbench , how i will do.
getting error massage since in hive jdbc dir ,  hive-jdbc-2.0.1-standalone not sure if this causing issue . 
please suggect


3 Replies

MD Mallieswari D Syncfusion Team May 10, 2019 10:12 AM

Hi Ajay, 

We consider that your requirement is related to ‘connecting Studio’s Hive from a different machine’. In that case, we would like to let you know that the machine where Studio is installed will have the cluster running as standalone mode (localhost) including Hive service in localhost mode. So, you cannot connect the service from outside the machine. Rather we suggest you to create new pseudo-node cluster using Syncfusion Big Cluster Manager Application and connect from outside using IP address of the Machine. 

Please refer the following help links, 
  1. Download Big Data Agent and Cluster Manager setup - https://www.syncfusion.com/account/downloads/bigdata/licensed/3_2_0_20
  2. Install Big Data Agent and Cluster Manager setup – https://help.syncfusion.com/bigdata/cluster-manager/installation-and-deployment#step-by-step-installation
  3. Run Cluster Manager application – https://help.syncfusion.com/bigdata/cluster-manager/installation-and-deployment#big-data-cluster-manager---ssl-self-signed-certificate
  4. Pseudo node cluster creation – https://help.syncfusion.com/bigdata/cluster-manager/cluster-creation#pseudo-node-cluster

If you mean any other requirements, please let us know. We are happy to help you. 

Mallieswari D

AJ ajay. May 22, 2019 04:03 AM

Thanks team

MK Madhan Kumar S Syncfusion Team May 24, 2019 12:39 AM

Hi Ajay, 
You are welcome. 
Madhan Kumar S 

Live Chat Icon For mobile
Up arrow icon