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 <[email protected]> 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 <[email protected]> > 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 >> > >
