Reply
Explorer
Posts: 6
Registered: ‎10-10-2016
Accepted Solution

Phoenix database adapter for Python not working

 

 

I followed the instruction from http://python-phoenixdb.readthedocs.io/en/latest/

to connect Hbase in cloudera cluster, but I got the following error below.

 

I can create table using phoenix-sqlline.py localhost:2181:/hbase or even use ./psql.py to import CSV, why the python adaopter does not work? Could someone give me a simple example that allows me to connect phoenixDB in Cloudera? 

 

 

>>> import phoenixdb
>>> database_url = 'http://localhost:8765/'
>>> conn = phoenixdb.connect(database_url, autocommit=True)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/root/anaconda2/lib/python2.7/site-packages/phoenixdb/__init__.py", line 63, in connect
client.connect()
File "/root/anaconda2/lib/python2.7/site-packages/phoenixdb/avatica.py", line 152, in connect
raise errors.InterfaceError('Unable to connect to the specified service', e)
phoenixdb.errors.InterfaceError: ('Unable to connect to the specified service', error(111, 'Connection refused'), None, None)

Highlighted
Explorer
Posts: 6
Registered: ‎10-10-2016

Re: Phoenix database adapter for Python not working

I didn't know that I need to manually start query server. that's fix my problem