message=(“Could not start SASL: %s“ % self.sasl.getError())) thrift.transport.TTransport.TTransport

最新推荐文章于 2021-04-13 11:08:01 发布
原创 最新推荐文章于 2021-04-13 11:08:01 发布 · 913 阅读 · 0 ·
CC 4.0 BY-SA版权
Author:baiyun ,Email:mitbaiyun@163.com

本文介绍了一种在Windows环境下解决使用PyHive连接Hive时遇到的问题的方法。通过一条命令修改注册表设置，成功解决了连接问题。

在window环境下使用pyhive连接hive报错，通过以下命令解决

FOR /F "usebackq delims=" %A IN (python -c “from importlib import util;import os;print(os.path.join(os.path.dirname(util.find_spec(‘sasl’).origin),‘sasl2’))”) DO ( REG ADD "HKEY_LOCAL_MACHINE\SOFTWARE\Carnegie Mellon\Project Cyrus\SASL Library" /v SearchPath /t REG_SZ /d "%A" )

管理员cmd运行

在这里插入图片描述

效果

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

遇到问题--hbase---java连接hbase报错TTransportException
直到世界的尽头
03-19 3819
情况 我们在java中连接hbase报错。 java的链接代码如下: package com.test.web.controller; import java.util.ArrayList; import java.util.List; import org.apache.hadoop.hbase.thrift2.generated.TColumnValue; import or...
Pyhive连接hive时出错：thrift.transport.TTransport.TTransportException: Could not start SASL
fyydlz的博客
12-02 5586
Pyhive连接hive时出错：thrift.transport.TTransport.TTransportException: Could not start SASL
thrift.transport.TTransport.TTransportException: Could not start SASL: b'Error in sasl_client_start
10-19 5171
apt-get install libsasl2-dev libsasl2-2 libsasl2-modules-gssapi-mit
thrift.transport.TTransport.TTransportException: Could not start SASL: Error in sasl_client_start (-...
weixin_30706691的博客
03-28 1811
thrift.transport.TTransport.TTransportException: Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found 解决办法： 　　yum install cyrus-sasl-plain c...
python SASL报错
梦想成真那天
05-28 596
Traceback (most recent call last): File "phone.py", line 203, in <module> main() File "phone.py", line 119, in main data = get_data() File "/home/hadoop/phone_location_info/conf.py", line 30, in wrapper data = fun(*args, **kwargs)
python连接hive配置中遇到的问题及解决方法
u011076848的专栏
04-13 1653
1、message=("Could not start SASL: %s" % self.sasl.getError())) thrift.transport.TTransport.TTransportException: Could not start SASL: b'Error in sasl_client_start (-12) SASL library is not initialized 解决方法：https://blog.csdn.net/wenjun_xiao/article/details/
beeline> !connect jdbc:hive2://node1:10000 Connecting to jdbc:hive2://node1:10000 Enter username for jdbc:hive2://node1:10000: hadoop Enter password for jdbc:hive2://node1:10000: 25/07/20 16:07:35 [main]: ERROR jdbc.HiveConnection: Error opening session org.apache.thrift.transport.TTransportException: null at org.apache.thrift.transport.TIOStreamTransport.read(TIOStreamTransport.java:132) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.transport.TSaslTransport.readLength(TSaslTransport.java:376) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.transport.TSaslTransport.readFrame(TSaslTransport.java:453) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.transport.TSaslTransport.read(TSaslTransport.java:435) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.transport.TSaslClientTransport.read(TSaslClientTransport.java:37) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.transport.TTransport.readAll(TTransport.java:86) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.protocol.TBinaryProtocol.readAll(TBinaryProtocol.java:429) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.protocol.TBinaryProtocol.readI32(TBinaryProtocol.java:318) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.protocol.TBinaryProtocol.readMessageBegin(TBinaryProtocol.java:219) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.thrift.TServiceClient.receiveBase(TServiceClient.java:77) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.hive.service.rpc.thrift.TCLIService$Client.recv_OpenSession(TCLIService.java:176) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.hive.service.rpc.thrift.TCLIService$Client.OpenSession(TCLIService.java:163) ~[hive-exec-3.1.3.jar:3.1.3] at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:728) [hive-jdbc-3.1.3.jar:3.1.3] at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:232) [hive-jdbc-3.1.3.jar:3.1.3] at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107) [hive-jdbc-3.1.3.jar:3.1.3] at java.sql.DriverManager.getConnection(DriverManager.java:664) [?:1.8.0_361] at java.sql.DriverManager.getConnection(DriverManager.java:208) [?:1.8.0_361] at org.apache.hive.beeline.DatabaseConnection.connect(DatabaseConnection.java:145) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.DatabaseConnection.getConnection(DatabaseConnection.java:209) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.Commands.connect(Commands.java:1641) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.Commands.connect(Commands.java:1536) [hive-beeline-3.1.3.jar:3.1.3] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_361] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_361] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_361] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_361] at org.apache.hive.beeline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:56) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.BeeLine.execCommandWithPrefix(BeeLine.java:1384) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.BeeLine.dispatch(BeeLine.java:1423) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.BeeLine.execute(BeeLine.java:1287) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.BeeLine.begin(BeeLine.java:1071) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.BeeLine.mainWithInputRedirection(BeeLine.java:538) [hive-beeline-3.1.3.jar:3.1.3] at org.apache.hive.beeline.BeeLine.main(BeeLine.java:520) [hive-beeline-3.1.3.jar:3.1.3] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_361] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_361] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_361] at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_361] at org.apache.hadoop.util.RunJar.run(RunJar.java:330) [hadoop-common-3.4.0.jar:?] at org.apache.hadoop.util.RunJar.main(RunJar.java:245) [hadoop-common-3.4.0.jar:?] 25/07/20 16:07:35 [main]: WARN jdbc.HiveConnection: Failed to connect to node1:10000 Error: Could not open client transport with JDBC Uri: jdbc:hive2://node1:10000: Could not establish connection to jdbc:hive2://node1:10000: null (state=08S01,code=0) beeline> 这个怎么解决
07-21
"Error occurred during initialization of VM: java.lang.InternalError: Could not create SecurityManager: allow" 同时，日志中还显示SLF4J绑定冲突（多个日志绑定），这可能导致启动失败。 因此，我们需要...
Traceback (most recent call last): File "T05_NAC_MSG_RCVER_TGYH_I0200.py", line 250, in main raise ex File "T05_NAC_MSG_RCVER_TGYH_I0200.py", line 200, in main results = cursor.fetchall() File "/home/tgbd/.local/lib/python3.7/site-packages/pyhive/common.py", line 136, in fetchall return list(iter(self.fetchone, None)) File "/home/tgbd/.local/lib/python3.7/site-packages/pyhive/common.py", line 105, in fetchone self._fetch_while(lambda: not self._data and self._state != self._STATE_FINISHED) File "/home/tgbd/.local/lib/python3.7/site-packages/pyhive/common.py", line 45, in _fetch_while self._fetch_more() File "/home/tgbd/.local/lib/python3.7/site-packages/pyhive/hive.py", line 387, in _fetch_more response = self._connection.client.FetchResults(req) File "/usr/lib/python3.7/site-packages/TCLIService/TCLIService.py", line 714, in FetchResults return self.recv_FetchResults() File "/usr/lib/python3.7/site-packages/TCLIService/TCLIService.py", line 726, in recv_FetchResults (fname, mtype, rseqid) = iprot.readMessageBegin() File "/usr/lib/python3.7/site-packages/thrift/protocol/TBinaryProtocol.py", line 135, in readMessageBegin sz = self.readI32() File "/usr/lib/python3.7/site-packages/thrift/protocol/TBinaryProtocol.py", line 218, in readI32 buff = self.trans.readAll(4) File "/usr/lib/python3.7/site-packages/thrift/transport/TTransport.py", line 62, in readAll chunk = self.read(sz - have) File "/usr/lib/python3.7/site-packages/thrift_sasl/__init__.py", line 173, in read self._read_frame() File "/usr/lib/python3.7/site-packages/thrift_sasl/__init__.py", line 187, in _read_frame message=self.sasl.getError()) thrift.transport.TTransport.TTransportException: b'Error in sasl_decode (-1) SASL(-1): generic failure: Unable to find a callback: 32775' 这个报错优先排查哪个py文件？
最新发布
08-12
`thrift.transport.TTransport.TTransportException: b'Error in sasl_decode (-1) SASL(-1): generic failure: Unable to find a callback: 32775'` 这个错误发生在Thrift客户端与服务器进行SASL认证时，具体是在...
2025/08/01 11:02:41 - 执行SQL脚本.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : 错误初始化步骤[执行SQL脚本] 2025/08/01 11:02:41 - 执行SQL脚本.0 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : java.lang.NoSuchMethodError: org.apache.hadoop.hive.common.auth.HiveAuthUtils.getSocketTransport(Ljava/lang/String;III)Lorg/apache/hive/org/apache/thrift/transport/TTransport; 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.apache.hive.jdbc.HiveConnection.createUnderlyingTransport(HiveConnection.java:915) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:951) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:507) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:379) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:284) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:94) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at java.sql.DriverManager.getConnection(DriverManager.java:664) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at java.sql.DriverManager.getConnection(DriverManager.java:208) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:589) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.pentaho.di.core.database.Database.normalConnect(Database.java:481) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.pentaho.di.core.database.Database.connect(Database.java:389) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.pentaho.di.core.database.Database.connect(Database.java:360) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.pentaho.di.trans.steps.sql.ExecSQL.init(ExecSQL.java:297) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69) 2025/08/01 11:02:41 - 执行SQL脚本.0 - at java.lang.Thread.run(Thread.java:748) 2025/08/01 11:02:41 - 转换 1 - ERROR (version 9.4.0.0-343, build 0.0 from 2022-11-08 07.50.27 by buildguy) : 步骤 [执行SQL脚本.0] 初始化失败!
08-02
网络策略阻止 Thrift 端口（通常 10000）、SSL 配置错误或 SASL 认证失败[^1] > **关键提示**：根据社区数据，92% 的类似错误通过统一 Hive JDBC 和 Hadoop 主要版本解决[^3]。若仍报错，检查 `hive-site.xml` 中 ...
[解决方案] Windows pyhive Could not start SASL
wenjun_xiao的博客
02-24 1万+
Windows下使用pyhive连接hive的代码例子如下 from pyhive import hive conn = hive.Connection(host='172.100.0.11',port=10000) cursor = conn.cursor() cursor.execute('show tables') for result in cursor.fetchall(): p...
Python连接hive报错Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available
醉糊涂仙的博客
07-26 1万+
Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found (code THRIFTTRANSPORT): TTransportException('Could not start SASL: Error in sasl_client_st...
pyhive client连接hive报错处理:Could not start SASL
weixin_30379531的博客
08-12 1705
本来一切就绪，镜像里已安装如下主要的pip包。 pyhive configparser pandas hdfs thrift sqlparse sasl thrift-sasl 但，使用pyhive client去真正连接hive服务器时，还是会报如下错误： thrift.transport.TTransport.TTransportException: ...
Hue error: 集成hive报错Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism avai
小蚯蚓的博客
12-09 3877
1.问题描述 hue配置完hive后，打开hue界面报错： Could not start SASL: Error in sasl_client_start (-4) SASL(-4): no mechanism available: No worthy mechs found (code THRIFTTRANSPORT): TTransportException('Could not st...
hadoop2.4.1 安装hue with Yarn模式
zhoujj303030的专栏
04-02 6232
Here are some urls about HUE,your can refer to following urls intall hue and check some error message: http://cloudera.github.io/hue/docs-3.7.0/manual.html https://github.com/cloudera/hu
记录win10下python3.7安装pyhive遇到的问题以及安装impyla
日常记录
08-13 3217
在windows系统下安装pyhive 查资料都是用pip进行安装pyhive的依赖，最后安装pyhive，在安装sasl过程中windows系统会报错，一头雾水； 可以用canda进行安装，自动安装依赖 conda install PyHive 验证是否可用： from pyhive import hive ...
【Python】Python连接Hadoop数据中遇到的各种坑（汇总）
热门推荐
wx0628的博客
01-19 1万+
最近准备使用Python+Hadoop+Pandas进行一些深度的分析与机器学习相关工作。（当然随着学习过程的进展，现在准备使用Python+Spark+Hadoop这样一套体系来搭建后续的工作环境），当然这是后话。 但是这项工作首要条件就是将Python与Hadoop进行打通，本来认为很容易的一项工作，没有想到竟然遇到各种坑，花费了整整半天时间。后来也在网上看到大家在咨询相同的问题，但是真正解决...
windows7下python连接hive的总结分享
weixin_38535787的博客
03-04 592
环境： window7 Anaconda3-2019.10-Windows-x86_64 python连接hive数据库 1.下载sasl编译好的包sasl-0.2.1-cp37-cp37m-win_amd64.whl 下载thrift编译好的包 thrift-0.13.0-cp37-cp37m-win_amd64.whl 备注相关下载地址：https://www.lfd.uci.edu/~go...
使用Pyhive连接hive时出错：thrift.transport.TTransport.TTransportException: Could not start SASL
09-19
这个错误通常是由于缺少依赖库或配置问题导致的。您可以尝试以下方法解决该问题： 1. 确保安装了`thrift_sasl`库，可以使用以下命令安装： ``` pip install thrift_sasl ``` 2. 检查您的Hive服务器配置，确保启用了SASL身份验证。您可以在`hive-site.xml`配置文件中查找以下属性： ``` <property> <name>hive.server2.authentication</name> <value>KERBEROS</value> </property> ``` 如果没有上述属性或值为`NONE`，则需要配置Hive服务器以启用SASL身份验证。 3. 确保您的Python环境中安装了Kerberos客户端库。Kerberos是SASL身份验证所需的一种认证机制。您可以根据您的操作系统安装适当的Kerberos客户端库。 如果上述方法仍然无法解决问题，请提供更多信息，例如您的操作系统、Hive版本以及完整的错误堆栈跟踪信息，以便我能更好地帮助您。
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

BigData-0

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值