Re: Connecting to Impala from Python

[Matthew Jacobs <mj...@cloudera.com>]

Adding apache lists.

On Sun, Apr 17, 2016 at 9:42 PM Matthew Jacobs <mj...@cloudera.com> wrote:

> Can you try using the function the error message mentions?
>
> >>> impala = ibis.impala.connect(host=host_name,port=port_number,
> database=db_name,auth_mechanism="GSSAPI",use_ssl=True)
>
> Thanks
>
> On Sun, Apr 17, 2016 at 9:15 PM Krishna Sangeeth KS <
> kskrishnasangeeth@gmail.com> wrote:
>
>>
>> Hi Alan,
>>
>> Thanks for sharing your setup.
>>
>> I tried using the same setup. But got the below error message.
>>
>> >>> impala =
>> ibis.impala_connect(host=host_name,port=port_number,database=db_name,auth_mechanism="GSSAPI",use_ssl=True)
>> impala_connect is deprecated, use ibis.impala.connect instead
>> Traceback (most recent call last):
>>   File "<stdin>", line 1, in <module>
>>   File "/usr/lib/python2.6/site-packages/ibis/util.py", line 166, in g
>>     return f(*args, **kwargs)
>>   File "/usr/lib/python2.6/site-packages/ibis/impala/api.py", line 97, in
>> connect
>>     con = ImpalaConnection(pool_size=pool_size, **params)
>>   File "/usr/lib/python2.6/site-packages/ibis/impala/client.py", line 89,
>> in __init__
>>     self.ping()
>>   File "/usr/lib/python2.6/site-packages/ibis/impala/client.py", line
>> 176, in ping
>>     self._new_cursor()
>>   File "/usr/lib/python2.6/site-packages/ibis/impala/client.py", line
>> 161, in _new_cursor
>>     con = impyla.connect(database=self.database, **params)
>>   File "/usr/lib/python2.6/site-packages/impala/dbapi.py", line 147, in
>> connect
>>     auth_mechanism=auth_mechanism)
>>   File "/usr/lib/python2.6/site-packages/impala/hiveserver2.py", line
>> 644, in connect
>>     transport.open()
>>   File
>> "/usr/lib/python2.6/site-packages/thrift_sasl-0.2.0-py2.6.egg/thrift_sasl/__init__.py",
>> line 61, in open
>>     self._trans.open()
>>   File
>> "/usr/lib64/python2.6/site-packages/thrift/transport/TSSLSocket.py", line
>> 101, in open
>>     ciphers=self.ciphers)
>> TypeError: wrap_socket() got an unexpected keyword argument 'ciphers'
>>
>> Any work around to resolve this ?
>>
>> Sangeeth
>>
>>
>> With Regards
>>
>> Krishna Sangeeth K.S
>>
>> ----------------------------------------------------------------------
>>
>> If you can force your heart and nerve and sinew
>> To serve your turn long after they are gone,
>> And so hold on when there is nothing in you
>> Except the Will which says to them: "Hold on"
>>
>>
>>
>> On Wed, Apr 13, 2016 at 7:30 PM, Alan Jackoway <al...@cloudera.com>
>> wrote:
>>
>>> My setup uses Kerberos + SSL on impala, and our ibis connect line looks
>>> like this:
>>> impala = ibis.impala_connect(impala_host, database="default",
>>> auth_mechanism="GSSAPI", use_ssl=True)
>>>
>>> What were you using to connect, and what is the full authentication
>>> error?
>>>
>>> Alan
>>>
>>> On Wed, Apr 13, 2016 at 7:46 AM, Krishna Sangeeth KS <
>>> kskrishnasangeeth@gmail.com> wrote:
>>>
>>>> Hi All,
>>>>
>>>> I am trying to connect to Impala from Python using Ibis framework. The
>>>> hadoop environment is CDH 5.5 and the cluster has Kerberos security
>>>> implemented .
>>>>
>>>> As a result , the default connection setup is throwing Authentication
>>>> error. I have pip installed ibis-framework[kerberos].
>>>>
>>>> Can somebody share how to get this done properly. I am really looking
>>>> forward to try this . Any help will be much appreciated .
>>>>
>>>> Thanks ,
>>>> Sangeeth
>>>>
>>>> --
>>>> You received this message because you are subscribed to the Google
>>>> Groups "Impala User" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to impala-user+unsubscribe@cloudera.org.
>>>>
>>>
>>> --
>>> You received this message because you are subscribed to the Google
>>> Groups "Impala User" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to impala-user+unsubscribe@cloudera.org.
>>>
>>
>> --
>> You received this message because you are subscribed to the Google Groups
>> "Impala Dev" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to impala-dev+unsubscribe@cloudera.org.
>>
>