前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >Could not open client transport with JDBC Uri: jdbc:hive2://192.168.88.10:10000: java.net.ConnectExc

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

作者头像
Maynor
发布2021-12-07 11:54:30
7460
发布2021-12-07 11:54:30
举报

记录一下使用Hive的Bug

在这里插入图片描述
在这里插入图片描述

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驱动不匹配

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

mr执行太慢问题

代码语言:javascript
复制
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的时候执行了一个小时都没执行完… 是分区问题??

本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
原始发表:2021-07-25 ,如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 记录一下使用Hive的Bug
  • mr执行太慢问题
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档