检验过程:explain
JAVA&beeline
步骤:
- cd $HIVE_HOME/hiveserver2 –启动hive服务 《java操作hive中的常用问题》
- IntelliJ IDEA
- 加入hive依赖包
mvnrepository.com -> jdbc -> 版本
e.g.
<dependency>
<groupld>org.apache.hive</groupld>
<artifactld>hive-jdbc</artifactld>
<version>2.11</version>
</dependency>
- 创建模块
public class HiveMain{
public static void main(String[] args){
//加载驱动
Calss.forName("org.apache.hive.jdbc.HiveDriver");
//获取链接
Connection cnn=DriverManager.getConnection(
url:"jdbc:hive2://192.168.200.10:10000/default", //default:my_db_name
user:"root",
paddword:"");
//执行sql
PreparedStatement ps=conn.perpareStatement(sql:"select * from tb_name");
ResultSet result=ps.executQuery();
//处理结果
while(result.next()){
result.getInt(columnIndex:1);
System.out.println(x);
String name=result.getString(columnIndex:2);
System.out.println(name);
}
//关闭
result.close();
ps.close();
conn.close();
}
}
explode
1个
select explode(col_name) from tb_name;
多个
SELECT col_1,col_new_name FROM tb_name LATERAL VIEW explode(col_2) new_name_2 AS col_new_name
自定义函数
创建UDF函数
1. 导包HDFS和hive-exec
<dependencies>
<dependency>...</dependency>
</dependencies>
- 2.