Phoenix database adapter for Python not working

icecream — Fri, 16 Sep 2022 10:50:52 GMT

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)

Re: Phoenix database adapter for Python not working

icecream — Fri, 16 Dec 2016 22:20:14 GMT

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

question Re: Phoenix database adapter for Python not working in Archives of Support Questions (Read Only)

Phoenix database adapter for Python not working

Re: Phoenix database adapter for Python not working