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
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

how to connect HIVE from sql workbench

Thread ID:





144514 May 9,2019 02:37 PM UTC May 24,2019 05:39 AM UTC Big Data Platform 3
Tags: General
Asked On May 9, 2019 02:37 PM UTC

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


Mallieswari D [Syncfusion]
Replied On May 10, 2019 03:12 PM UTC

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

Replied On May 22, 2019 09:03 AM UTC

Thanks team

Madhan Kumar S [Syncfusion]
Replied On May 24, 2019 05:39 AM UTC

Hi Ajay, 
You are welcome. 
Madhan Kumar S 


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon