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 <vaghawan...@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 >
