先在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","",""