Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
Announcements
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.

Phoenix database adapter for Python not working

avatar
Explorer

 

 

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)

1 ACCEPTED SOLUTION

avatar
Explorer

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

View solution in original post

1 REPLY 1

avatar
Explorer

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