blocks|key|37925|text|安装kerberos软件包，它将修复您的问题。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|37926|entityMap^0|2|8|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

Install the <code>kerberos</code> Python package, it will fix your issue.

blocks|key|2064487|text|我遇到了同样的问题，但我通过安装所需库的正确版本来修复它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2064488|使用pip安装下面的python库：|2064489|six==1.12.0
bit_array==0.1.0
thrift==0.9.3
thrift_sasl==0.2.1
sasl==0.2.1
impyla==0.13.8|code-block|syntax|javascript|2064490|下面的代码在python版本2.7和3.4中运行得很好。|offset|length|style|CODE|2064491|import+ssl
from+impala.dbapi+import+connect
import+os
os.system("kinit")
conn+=+connect(host='hostname.io',+port=21050,+use_ssl=True,+database='default',+user='urusername',+kerberos_service_name='impala',+auth_mechanism+=+'GSSAPI')
cur+=+conn.cursor()
cur.execute('SHOW+DATABASES;')
result=cur.fetchall()
for+data+in+result:
++++print+(data)+|2064492|entityMap^0|0|0|0|6|6|E|3|I|3|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|V|8|@$K|W|L|X|M|N]|$K|Y|L|Z|M|N]|$K|10|L|11|M|N]]|9|@]|A|$]]|$1|O|3|P|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|R|$]]

I ran into the same issue but i fixed it by installing the right version of required libraries. 

Install below python libraries using pip:

<pre><code>six==1.12.0
bit_array==0.1.0
thrift==0.9.3
thrift_sasl==0.2.1
sasl==0.2.1
impyla==0.13.8
</code></pre>

Below code is working fine with the <code>python</code> version <code>2.7</code> and <code>3.4</code>. 

<pre><code>import ssl
from impala.dbapi import connect
import os
os.system("kinit")
conn = connect(host='hostname.io', port=21050, use_ssl=True, database='default', user='urusername', kerberos_service_name='impala', auth_mechanism = 'GSSAPI')
cur = conn.cursor()
cur.execute('SHOW DATABASES;')
result=cur.fetchall()
for data in result:
 print (data) 
</code></pre>

blocks|key|37928|text|对我来说，安装这个软件包修复了它：libsasl2-modules-gssapi-mit|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|37929|entityMap^0|H|R|0^^$0|@$1|2|3|4|5|6|7|H|8|@$9|I|A|J|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|K|8|@]|D|@]|E|$]]]|G|$]]

For me, installing this package fixed it: <code>libsasl2-modules-gssapi-mit</code>

blocks|key|47535|text|尝试这样做以获得内核化的集群的表。在我的例子中，CDH-5.14.2-1。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|47536|在运行此代码之前，请确保有有效的票证。|47537|具有下面的包的python+2.7。|blockquote|CODE|47538|thrift-0.9.3
thriftpy-0.3.8
thrift_sasl-0.3.0
impyla==0.14.2.2|code-block|syntax|javascript|47539|工作守则|47540|from+impala.dbapi+import+connect
from+impala.util+import+as_pandas

#+21000+is+impala+daemon+port.
conn+=+connect(host='yourHost',+port=21050,+auth_mechanism='GSSAPI')+

cursor+=+conn.cursor()
cursor.execute("SHOW+TABLES")
#+After+running+.execute(),+Impala+will+store+the+result+sets+on+the+server
#+until+it+is+fetched.+Use+the+method+.fetchall()+to+pull+the+entire+result
#+set+over+the+network+(you+should+only+do+it+if+you+know+dataset+is+small)
tables+=+cursor.fetchall()

print("Displaying+list+of+tables")
#+the+result+is+a+list+of+tuples
for+t+in+tables:
++++#+we+know+that+each+row+in+SHOW+TABLES+result
++++#+should+only+contains+one+table+name
++++print(t[0])
++++#+exit()+enable+for+only+one+table

print("eol+>>>")|47541|entityMap^0|8|4|O|C|0|0|E|3|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@$9|13|A|14|B|K]]|D|@]|E|$]]|$1|L|3|M|5|N|7|15|8|@]|D|@]|E|$O|P]]|$1|Q|3|R|5|J|7|16|8|@]|D|@]|E|$]]|$1|S|3|T|5|N|7|17|8|@]|D|@]|E|$O|P]]|$1|U|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|V|$]]

Try this to get tables for kerberized cluster. In my case CDH-5.14.2-1.

Make sure you have a valid ticket before running this code.

<blockquote>
 with python <code>2.7</code> having below packages. 
</blockquote>

<pre><code>thrift-0.9.3
thriftpy-0.3.8
thrift_sasl-0.3.0
impyla==0.14.2.2
</code></pre>

<blockquote>
 Working Code
</blockquote>

<pre><code>from impala.dbapi import connect
from impala.util import as_pandas

# 21000 is impala daemon port.
conn = connect(host='yourHost', port=21050, auth_mechanism='GSSAPI') 

cursor = conn.cursor()
cursor.execute("SHOW TABLES")
# After running .execute(), Impala will store the result sets on the server
# until it is fetched. Use the method .fetchall() to pull the entire result
# set over the network (you should only do it if you know dataset is small)
tables = cursor.fetchall()

print("Displaying list of tables")
# the result is a list of tuples
for t in tables:
 # we know that each row in SHOW TABLES result
 # should only contains one table name
 print(t[0])
 # exit() enable for only one table

print("eol &gt;&gt;&gt;")
</code></pre>

blocks|key|37959|text|对我来说，以下连接参数起作用了。我不需要在python中安装任何额外的软件包。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|37960|connect(host="your_host",+port=21050,+auth_mechanism='GSSAPI',+timeout=100000,+use_ssl=False,+ca_cert=None,+ldap_user=None,+ldap_password=None,+kerberos_service_name='impala')|code-block|syntax|javascript|37961|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For me, the following connection parameters worked. I did not have to install any additional packages in python. 

<pre><code>connect(host="your_host", port=21050, auth_mechanism='GSSAPI', timeout=100000, use_ssl=False, ca_cert=None, ldap_user=None, ldap_password=None, kerberos_service_name='impala')
</code></pre>

blocks|key|38017|text|要使用python连接Impala，您可以按照以下步骤操作，|type|unstyled|depth|inlineStyleRanges|entityRanges|data|38018|为Impala安装Coludera+ODBC驱动程序。|ordered-list-item|38019|使用64位ODBC驱动程序创建DSN，将您的服务器详细信息放在下面是相同的屏幕快照示例。|38020|📷|atomic|offset|length|38021|1.+Use+below+code+snippet+for+connectivity|code-block|syntax|javascript|38022|进口pyodbc|38023|以pyodbc.connect("DSN=impala_con"，autocommit=True)作为康涅狄格：.df+=+pd.read_sql(""，conn)|38024|​|38025|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://developer.qcloudimg.com/http-save/yehe-900000/592b6d25668c9450593884007e553116.png|imageAlt^0|0|0|0|0|1|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|15|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|16|8|@]|9|@]|A|$]]|$1|E|3|F|5|D|7|17|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|18|8|@]|9|@$J|19|K|1A|1|1B]]|A|$]]|$1|L|3|M|5|N|7|1C|8|@]|9|@]|A|$O|P]]|$1|Q|3|R|5|6|7|1D|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1E|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1F|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|X|$Y|$5|Z|10|11|A|$12|13|14|-4]]]]

To connection Impala using python you can follow below steps,

<ol>
<li>Install Coludera ODBC Driver for Impala.</li>
<li>Create DSN using 64-bit ODBC driver, put your server details, below is sample screen shot for same
<a href="https://i.stack.imgur.com/rXN5H.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rXN5H.png" alt="enter image description here"></a>

<ol start="3">
<li>Use below code snippet for connectivity

import pyodbc

with pyodbc.connect("DSN=impala_con", autocommit=True) as conn:
... df = pd.read_sql("", conn)</li>
</ol></li>
</ol>

blocks|key|47167|text|python无法连接hiveserver2|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|47168|确保安装cyrus-sasl-devel和cyrus-sasl-gssapi|47169|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/30705576/python-cannot-connect-hiveserver2?answertab=oldest#tab-top^0|0|L|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

<a href="https://stackoverflow.com/questions/30705576/python-cannot-connect-hiveserver2?answertab=oldest#tab-top">python cannot connect hiveserver2</a>

make sure you install cyrus-sasl-devel and cyrus-sasl-gssapi

I'm on a W8 machine, where I use Python (Anaconda distribution) to connect to Impala in our Hadoop cluster using the Impyla package. Our hadoop cluster is secured via Kerberos. I have followed the <a href="http://docs.ibis-project.org/configuration.html#working-with-secure-clusters-kerberos" rel="noreferrer">API REFERENCE</a> how to configure the connection. 

<pre><code> from impala.dbapi import connect
 conn = connect( host='localhost', port=21050, auth_mechanism='GSSAPI',
 kerberos_service_name='impala')
</code></pre>

We are using Kerberos GSSAPI with SASL

<pre><code>auth_mechanism='GSSAPI'
</code></pre>

I have managed to install python-sasl library for WIN8 but still I encounter this error.

<pre><code>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_start (-4) SASL(-4): no mechanism available: No worthy mechs found',)
</code></pre>

I wonder if I am still missing some dependencies.

Connect to Impala using impyla client with Kerberos auth

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我在一台W8机器上，使用Python (Anaconda分发版)使用Impyla包连接到Hadoop集群中的Impala。我们的hadoop集群是通过Kerberos来保护的。我遵循了如何配置连接。    from impala.dbapi import connect    conn = connect( host='localhost', port=21050, auth_mechanism=

问用Kerberos auth使用impyla客户端连接到Impala
EN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用Kerberos auth使用impyla客户端连接到ImpalaEN

回答 7

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用Kerberos auth使用impyla客户端连接到Impala
EN