Hive Connection

Posts: 3
Joined: Thu Dec 17, 2015 7:10 am

Hive Connection

Postby dasmrin » Wed Jan 06, 2016 12:05 pm


There are the 3 different ways of connecting Hive? (jdbc driver, odbc driver, thrift client). Please explain.


Finance Junkie
Posts: 981
Joined: Wed Apr 09, 2014 6:28 am

Re: Hive Connection

Postby edupristine » Tue Apr 05, 2016 7:16 am

Hi Dasmrin

Fundamentally there are 2 ways to connect with hive. One is through hive shell which is an interpreter where we can execute our queries. Second option is through hiveserver2 which is basically a thrift interface.
If we have direct access to the hive client, we can use the shell. There are basically two types of shell interfaces to hive. One is the hive shell which is the basic shell interface. This is deprecated in the latest versions of hive. The other shell is the beeline shell which internally uses the thrift interface.
Hiveserver2 helps us to access hive remotely from various applications. We can connect to hive from various applications and various programming languages through hiveserver2.

Return to “Big Data & Hadoop”


Global Association of Risk Professionals, Inc. (GARP®) does not endorse, promote, review or warrant the accuracy of the products or services offered by EduPristine for FRM® related information, nor does it endorse any pass rates claimed by the provider. Further, GARP® is not responsible for any fees or costs paid by the user to EduPristine nor is GARP® responsible for any fees or costs of any person or entity providing any services to EduPristine Study Program. FRM®, GARP® and Global Association of Risk Professionals®, are trademarks owned by the Global Association of Risk Professionals, Inc

CFA Institute does not endorse, promote, or warrant the accuracy or quality of the products or services offered by EduPristine. CFA Institute, CFA®, Claritas® and Chartered Financial Analyst® are trademarks owned by CFA Institute.

Utmost care has been taken to ensure that there is no copyright violation or infringement in any of our content. Still, in case you feel that there is any copyright violation of any kind please send a mail to and we will rectify it.