Eclipse Remote Operation Hive

start hiveserver First

Hive--service hiveserver 10000 &

Create a project

Introduction Package:

Code (simple query):

package Com.hive.jdbc;import Java.sql.connection;import Java.sql.drivermanager;import Java.sql.ResultSet;import Java.sql.statement;public class Hivejdbc {public static void main (string[] args) {try {class.forname ("            Org.apache.hadoop.hive.jdbc.HiveDriver ");            Query statement String querysql = "SELECT * from T_RP"; Link hive Connection con = drivermanager.getconnection ("Jdbc:hive://192.168.0.100:10000/default", "Hive", "Hive"            ");            Statement stmt = Con.createstatement ();            Execute Query statement ResultSet res = stmt.executequery (querysql); while (Res.next ()) {System.out.println ("Result:key:" + res.getstring (1) + "–> value:" + Res.getstri            Ng (2));            } stmt.close ();        Con.close ();        } catch (Exception e) {e.printstacktrace (); }    }}