Could not open client transport with JDBC Uri: jdbc:hive2://192.168.88.10:10000: java.net.ConnectExc

Connection to node1.itcast.cn failed.
[ 08S01] Could not open client transport with JDBC Uri: jdbc:hive2://192.168.88.10:10000: java.net.ConnectException: Connection refused: connect
结论:查网上资料说是jdbc驱动不匹配

然而也没找到相应的驱动
是通过换虚拟机解决的

set hive.exec.dynamic.partition=true; 
set hive.exec.dynamic.partition.mode=nonstrict;

create table student(
	s_id string
	,s_name string
	,s_birth string
	,s_sex string
	) 
	partitioned by(dt string)
	row format delimited fields terminated by 't';
	
	
create table score(
	s_id string
	,s_score int
	) 
	partitioned by(dt string)
	row format delimited fields terminated by 't';


insert overwrite table student  partition(dt = '2021-07-24')
select	'02' as s_id, '钱电' as s_name, '1990-12-21' as s_birth, '男' as s_sex union all 
select	'01' as s_id, '赵雷' as s_name, '1990-01-01' as s_birth, '男' as s_sex union all 
select	'03' as s_id, '孙风' as s_name, '1990-05-20' as s_birth, '男' as s_sex union all 
select	'04' as s_id, '李云' as s_name, '1990-08-06' as s_birth, '男' as s_sex union all 
select	'05' as s_id, '周梅' as s_name, '1991-12-01' as s_birth, '女' as s_sex union all 
select	'06' as s_id, '吴兰' as s_name, '1992-03-01' as s_birth, '女' as s_sex union all 
select	'07' as s_id, '郑竹' as s_name, '1989-07-01' as s_birth, '女' as s_sex union all 
select	'08' as s_id, '王菊' as s_name, '1990-01-20' as s_birth, '女' as s_sex ;

insert的时候执行了一个小时都没执行完…
是分区问题??