使用Java连接Hive2

先在Linux中启动hiveserver2，
进入beeline 新窗口打开：
beeline -u jdbc:hive2://192.168.56.100:10000 -n root，IP是虚拟机里的URL。
打开IDEA，首先还是导入依赖。

<dependency>
    <groupId>org.apache.hive</groupId>
    <artifactId>hive-jdbc</artifactId>
    <version>1.1.0</version>
</dependency>
<dependency>
    <groupId>org.apache.hadoop</groupId>
    <artifactId>hadoop-common</artifactId>
    <version>2.6.0</version>
</dependency>
<dependency>
     <groupId>org.apache.hive</groupId>
     <artifactId>hive-exec</artifactId>
     <version>1.1.0</version>
</dependency>

public class HiveToCon {
   

    private static String driverName = "org.apache.hive.jdbc.HiveDriver";


    private static Connection con = null;
    private static Statement state = null;
    private static ResultSet rst = null;


@Before
 public void init() throws ClassNotFoundException, SQLException {
   
	Class.forName("org.apache.hive.jdbc.HiveDriver");
        con = DriverManager.getConnection("jdbc:hive2://192.168.56.100:10000/mydemo","",""