跑数出现连不上hive数据库的问题

0
这边有5个跑数节点,在跑数过程中,时不时的就会出现跑数失败,连不上数据库的情况,这边是配置的sentry进行权限管理,
:019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - ERROR (version 5.4-SNAPSHOT, build 1 from 2015-08-17 08.58.25 by PC) : An error occurred executing this job entry : 
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - 
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TEMP.TEMP_DIM_DEALER_01 - Could not open client transport with JDBC Uri: jdbc:hive2://ip:10000/default: Peer indicated failure: Error validating the login
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - ERROR (version 5.4-SNAPSHOT, build 1 from 2015-08-17 08.58.25 by PC) : An error occurred executing this job entry : 
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - 
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - Error occurred while trying to connect to the database
2019/04/18 03:11:31 - TM_DEALER_BUSINESS_AREA_EV - Could not open client transport with JDBC Uri: jdbc:hive2://ip:10000/default: Peer indicated failure: Error validating the login
2019/04/18 03:13:18 - Kitchen - ERROR (version 5.4-SNAPSHOT, build 1 from 2015-08-17 08.58.25 by PC) : Finished with errors
已邀请:
0

lanmengxiaozi - 80后IT 2019-04-23 回答

补充下:这边是用kettle抽数,并且这边每天晚上都会重启hive,但是还是会出现部分任务在某些时间点上出现连不上数据库;
0

x50854968 - 123 2019-05-28 回答

mysql有重置连接的设置,未活动的会关闭
 
0

doubleK24 2020-10-26 回答

请问一下楼主解决了吗?我这边也是时不时会出现这个问题
0

Kiwi2021 2021-03-27 回答

1.Hive中存放是什么?

答:表,存的是和hdfs的天津快乐十分映射关系,hive是逻辑上的数据仓库,实际操作的都是hdfs上的文件,HQL就是幸运飞艇用sql语法来写的mr程序。

2.Hive与关系型数据库的关系?

答:没有关系,hive是数据仓库,不能和数据库一样进行实时的CURD操作。 是一次写入多次读取的操作,可以看成天津快乐十分是ETL工具。

要回复问题请先登录注册