Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

HIVE JDBC connection details

Shulou Source: shulou.com Published: 2022-06-03 07:54:57 11月23日 Update

Package org.conan.myhadoop.mr;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class HiveJDBCConnection {private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver"; / / Hive after version 0.11.0 org.apache.hive.jdbc.HiveDriver private static String url = "jdbc:hive://localhost:10000/default" / Hive version 0.11.0 and later jdbc:hive2://localhost:10000/default private static String userName = "; private static String passWord ="; public static void main (String [] args) {try {Class.forName (driverName); Connection con = DriverManager.getConnection ("url", "userName", "passWord"); Statement stmt = con.createStatement () / / if it exists, delete String tableName = "jdbc_table"; String sql = "drop table if exists" + tableName; stmt.execute (sql) / / create table sql = "create table" + tableName + "(key string,value string) row format delimited fields terminated by', 'stored as textfile"; stmt.execute (sql); / / load data String Path= "/ home/hive_1.txt" Sql = "load data local inpath'" + Path+ "'into table" + tableName; stmt.execute (sql); / / query data sql = "select * from" + tableName; ResultSet res = stmt.executeQuery (sql); while (res.next ()) {System.out.println (res.getString (1) + "\ t" + res.getString (1)) } catch (ClassNotFoundException e) {System.out.println ("driver class not found"); e.printStackTrace ();} catch (SQLException e) {System.out.println ("there is a problem connecting Hive information"); e.printStackTrace ();}

The above is to connect HiveServer with Java, but HiveServer itself has many problems (such as security, concurrency, etc.). To solve these problems, the Hive0.11.0 version provides a new service: HiveServer2, which is a good solution to the security and concurrency problems of HiveServer.

The userName and passWord above are the username and password of the hive metadata mysql

Use Cases: Hive CLI versus Beeline

The following section focuses on the common uses of Hive CLI/HiveServer1 and how you can migrate to Beeline/HiveServer2 in each case.

Http://blog.cloudera.com/blog/2014/02/migrating-from-hive-cli-to-beeline-a-primer/?utm_source=tuicool&utm_medium=referral

Reference article:

Http://www.iteblog.com/archives/846

Tags: Questions data version security security information brand new password article user name face-to-face reference service query driver Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Shulou Information MariaDB Shulou Technology Linux