![driver for mysql jdbc driver for mysql jdbc](https://1.bp.blogspot.com/-HsY0MsiKIGY/VcXwLdwp0YI/AAAAAAAADEw/yAUrowc7K78/s1600/Add_MySQL_JDBC_Driver_to_Eclipse_1.png)
![driver for mysql jdbc driver for mysql jdbc](https://i.ytimg.com/vi/jtoZkRXF0_Y/maxresdefault.jpg)
With the help of the hive client, we can able to trigger the hive queries on top of the hive server. Hive Client or Gateway: It provides a communication channel in-between the current working host or node to the hive server2. It will easily trigger the job on the hive server. If any external software or the tool wants to trigger the hive jobs, then it with the help of the hive thrift server. The hive thrift server will help to submit the hive queries from the external environment.
#Driver for mysql jdbc install
As per the requirement or the business need, we can install it on the Hadoop stack. Hive thrift server: In the hive service, the hive thrift server is an optional service. In hive service, there are different components are available like hive server2, hive metastore, hive metadata, hive thrift server, hive gateway, or client. To work with the Hive JDBC driver, first, we need to understand the hive architecture. The different ways like HDP environment, CDH environment, and standalone hive environment, etc. There are different ways that we can use the hive service. In the Hadoop stack, we are using the HDFS to store the distributed data. We can trigger the SQL query on top of the distributed data. How does JDBC driver work in Hive?Īs we have discussed, the hive will support the SQL functionality. But by default, we are using the JDBC connection in the Hadoop stack. As per the project requirement or the business need, we need to choose any one of the connection types. The first type is the JDBC driver, and the second type is the ODBC driver. There are two types of the driver available that is supported by the hive. The JDBC driver will help to connect with the hive server2. We can trigger the queries on the distributed data, i.e., the data which is store on the HDFS level. It will help to analyse data, query on the data, and visualize the data.
![driver for mysql jdbc driver for mysql jdbc](https://bennadel-cdn.com/resources/uploads/2009/com_mysql_jdbc_driver_allowmultiqueries.gif)
The hive JDBC driver will provide the functionality to connect the external or internal (superset service) BI tools. The Hive is a very vital service in the Hadoop ecosystem.