You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Vaghawan Ojha <va...@gmail.com> on 2017/10/23 08:58:30 UTC

SQLException While Trying To Connect phoenixdb python

Hi, the sqline.py works fine in the server console, but when I try to
connect it through python, it gives the following SQLException:



File "/usr/local/lib/python2.7/dist-packages/phoenixdb/avatica.py",
line 129, in parse_error_protobuf
    raise errors.InternalError(err.error_message)
phoenixdb.errors.InternalError: (u'RuntimeException:
java.sql.SQLException: No suitable driver found for
bigdata-namenode:8765 -> SQLException: No suitable driver found for
bigdata-namenode:8765', None, None, None)



import phoenixdb
database_url = 'http://localhost:8765/'conn =
phoenixdb.connect(database_url, autocommit=True)

Can anybody please help me what's wrong, I'm not sure if I need to
explicitly give the driver class or something, I'm working with the python.

Any help would be great.

Thanks
Vaghawan

Re: SQLException While Trying To Connect phoenixdb python

Posted by Vaghawan Ojha <va...@gmail.com>.

Yes, Thank you for your response, the thin client wasn't working due to the
Hadoop and HBase classpath. I fixed it. I'm actually using python client,
it seems the connection is reset everytime when I finish one operation.

Thanks
Vaghawan

On Tue, Oct 24, 2017 at 6:17 PM, Datta Mane <da...@gmail.com> wrote:

>
> Check the database URL
>
> This is how JDBC URL is configured
>
> jdbc:phoenix:thin:url=http://ip-10-46-174-227.ec2.internal:
> 8765;serialization=PROTOBUF;authentication=SPNEGO
>
> Make sure you have proper driver files in system path.
>
> On Mon, Oct 23, 2017 at 4:58 AM, Vaghawan Ojha <va...@gmail.com>
> wrote:
>
>> Hi, the sqline.py works fine in the server console, but when I try to
>> connect it through python, it gives the following SQLException:
>>
>>
>>
>> File "/usr/local/lib/python2.7/dist-packages/phoenixdb/avatica.py", line 129, in parse_error_protobuf
>>     raise errors.InternalError(err.error_message)
>> phoenixdb.errors.InternalError: (u'RuntimeException: java.sql.SQLException: No suitable driver found for bigdata-namenode:8765 -> SQLException: No suitable driver found for bigdata-namenode:8765', None, None, None)
>>
>>
>>
>> import phoenixdb
>> database_url = 'http://localhost:8765/'conn = phoenixdb.connect(database_url, autocommit=True)
>>
>> Can anybody please help me what's wrong, I'm not sure if I need to
>> explicitly give the driver class or something, I'm working with the python.
>>
>> Any help would be great.
>>
>> Thanks
>> Vaghawan
>>
>
>

Re: SQLException While Trying To Connect phoenixdb python

Posted by Datta Mane <da...@gmail.com>.

Check the database URL

This is how JDBC URL is configured

jdbc:phoenix:thin:url=
http://ip-10-46-174-227.ec2.internal:8765;serialization
=PROTOBUF;authentication=SPNEGO

Make sure you have proper driver files in system path.

On Mon, Oct 23, 2017 at 4:58 AM, Vaghawan Ojha <va...@gmail.com>
wrote:

> Hi, the sqline.py works fine in the server console, but when I try to
> connect it through python, it gives the following SQLException:
>
>
>
> File "/usr/local/lib/python2.7/dist-packages/phoenixdb/avatica.py", line 129, in parse_error_protobuf
>     raise errors.InternalError(err.error_message)
> phoenixdb.errors.InternalError: (u'RuntimeException: java.sql.SQLException: No suitable driver found for bigdata-namenode:8765 -> SQLException: No suitable driver found for bigdata-namenode:8765', None, None, None)
>
>
>
> import phoenixdb
> database_url = 'http://localhost:8765/'conn = phoenixdb.connect(database_url, autocommit=True)
>
> Can anybody please help me what's wrong, I'm not sure if I need to
> explicitly give the driver class or something, I'm working with the python.
>
> Any help would be great.
>
> Thanks
> Vaghawan
>