Created on 10-09-2018 10:34 AM - edited 09-16-2022 06:47 AM
Client can interact with Hive?How
Created 10-09-2018 11:08 AM
Assuming you want to connect to HS2, apart from beeline, you can connect using JDBC/ODBC as explained in wiki.
Created 10-09-2018 07:35 PM
btw, these questions are copied from
https://data-flair.training/forums/topic/how-client-can-interact-with-hive
Created 10-10-2018 12:40 PM
The Client can interact with the Hive in the below three ways:-
ü Hive Thrift Client: The Hive server is exposed as thrift service. Hence it is possible to interact with HIVE with any programming language that supports thrift.
ü JDBC Driver: Hive uses pure Type 4 JDBC driver to connect to the server which is defined in org.apache.hadoop.HIVE.JDBC.HiveDriver class. . Pure Java applications may use this driver in order to connect to application using separate host and port.
The BeeLine CLI uses JDBC Driver to connect to the HIVE Server.
ü ODBC Driver: An ODBC Driver allows application that support ODBC to connect to the HIVE server. By default Apache does not ships the ODBC Driver but it is freely available by many vendors.