既有适合小白学习的零基础资料,也有适合3年以上经验的小伙伴深入学习提升的进阶课程,涵盖了95%以上大数据知识点,真正体系化!
由于文件比较多,这里只是将部分目录截图出来,全套包含大厂面经、学习笔记、源码讲义、实战项目、大纲路线、讲解视频,并且后续会持续更新
}
//连接Hive
try {
conn = DriverManager.getConnection(HIVE\_URL, HIVE\_USERNAME, HIVE\_PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
try {
ps = conn.prepareStatement("insert into " + SOURCE + " values(?, ?)");
//写入数据id为1234,name为张三
ps.setInt(1,1234);
ps.setString(2, "张三");
rs = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
}
### 2.2.删除
import java.io.IOException;
import java.sql.*;
public class Test{
//Hive连接信息
private static String JDBC_DRIVER = “org.apache.hive.jdbc.HiveDriver”;
private static String HIVE_URL = “jdbc:hive2://192.168.1.1:25005/test”;
private static String HIVE_USERNAME = “root”;
private static String HIVE_PASSWORD = “123456”;
//Hive源
private static String SOURCE = "`ods\_x8v`.`ods\_tsp\_tab\_tbox\_change`";
private static String TARGET = "`dw\_x8v`.`dwd\_tsp\_tab\_tbox\_change`";
private static Connection conn = null;
private static ResultSet rs = null;
private static PreparedStatement ps = null;
public static void main(String[] args) {
//HiveJDBC驱动
try {
Class.forName(JDBC\_DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//连接Hive
try {
conn = DriverManager.getConnection(HIVE\_URL, HIVE\_USERNAME, HIVE\_PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
try {
ps = conn.prepareStatement("delete from " + SOURCE + " where id = ?");
//删除id为1234的数据
ps.setInt(1,1234);
//执行数据更新操作
rs = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
}
### 2.3.修改
import java.io.IOException;
import java.sql.*;
public class Test{
//Hive连接信息
private static String JDBC_DRIVER = “org.apache.hive.jdbc.HiveDriver”;
private static String HIVE_URL = “jdbc:hive2://192.168.1.1:25005/test”;
private static String HIVE_USERNAME = “root”;
private static String HIVE_PASSWORD = “123456”;
//Hive源
private static String SOURCE = "`ods\_x8v`.`ods\_tsp\_tab\_tbox\_change`";
private static String TARGET = "`dw\_x8v`.`dwd\_tsp\_tab\_tbox\_change`";
private static Connection conn = null;
private static ResultSet rs = null;
private static PreparedStatement ps = null;
public static void main(String[] args) {
//HiveJDBC驱动
try {
Class.forName(JDBC\_DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//连接Hive
try {
conn = DriverManager.getConnection(HIVE\_URL, HIVE\_USERNAME, HIVE\_PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
try {
ps = conn.prepareStatement("update " + SOURCE + " set name = ? where id = ?");
//修改id为1234的数据name字段为张三
ps.setString(1, "张三");
ps.setInt(2,1234);
//执行数据更新操作
rs = ps.executeUpdate();
} catch (Exception e) {
e.printStackTrace();
}
}
}
### 2.4.查询
import java.io.IOException;
import java.sql.*;
public class Test{
//Hive连接信息
private static String JDBC_DRIVER = “org.apache.hive.jdbc.HiveDriver”;
private static String HIVE_URL = “jdbc:hive2://192.168.1.1:25005/test”;
private static String HIVE_USERNAME = “root”;
private static String HIVE_PASSWORD = “123456”;
//Hive源
private static String SOURCE = "`ods\_x8v`.`ods\_tsp\_tab\_tbox\_change`";
private static String TARGET = "`dw\_x8v`.`dwd\_tsp\_tab\_tbox\_change`";
private static Connection conn = null;
private static ResultSet rs = null;
private static PreparedStatement ps = null;
public static void main(String[] args) {
//HiveJDBC驱动
try {
Class.forName(JDBC\_DRIVER);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
//连接Hive
try {
conn = DriverManager.getConnection(HIVE\_URL, HIVE\_USERNAME, HIVE\_PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
try {
//查询表中id,name字段数据
ps = conn.prepareStatement("select id, name from " + SOURCE);
//将查询结果返回结果集
rs = ps.executeQuery();
//遍历结果集
while (rs.next()) {
int id = rs.getInt(1);
String name = rs.getString(2);
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
## 3)注意
**(1)ps.setString():空指针异常**
![img](https://img-blog.csdnimg.cn/img_convert/95a4a085be79f57252aad0d62608e388.png)
![img](https://img-blog.csdnimg.cn/img_convert/9789018ed6b4e7b0f90edc570d484605.png)
**网上学习资料一大堆,但如果学到的知识不成体系,遇到问题时只是浅尝辄止,不再深入研究,那么很难做到真正的技术提升。**
**[需要这份系统化资料的朋友,可以戳这里获取](https://bbs.csdn.net/topics/618545628)**
**一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!**
止,不再深入研究,那么很难做到真正的技术提升。**
**[需要这份系统化资料的朋友,可以戳这里获取](https://bbs.csdn.net/topics/618545628)**
**一个人可以走的很快,但一群人才能走的更远!不论你是正从事IT行业的老鸟或是对IT行业感兴趣的新人,都欢迎加入我们的的圈子(技术交流、学习资源、职场吐槽、大厂内推、面试辅导),让我们一起学习成长!**