question Phoenixdb FetchAll not working and returning empty list in Archives of Support Questions (Read Only)

Phoenixdb FetchAll not working and returning empty list

geethsameer686 — Wed, 16 Aug 2017 15:43:46 GMT

@Timothy SpannThe queries like upsert are working fine and data is getting inserted into tables but when I execute a select query and print result, it shows empty.

The output which I am getting for this is [ ].

I have checked with sqlline.py and have seen that the table has 2 rows.

import phoenixdb
database_url ='http://localhost:8765/'
conn = phoenixdb.connect(database_url, autocommit=True)
cursor = conn.cursor()
cursor.execute("upsert into users values(2,'user')")
cursor.execute("select * from users")
print cursor.fetchall()

I have read your previous answer. Could you tell me how to restart the query server and with with the phoenix.queryserver.serialization parameter set to JSON.

Re: Phoenixdb FetchAll not working and returning empty list

TimothySpann — Wed, 16 Aug 2017 20:05:05 GMT

1. Go to Ambari

2. Under HBase, Under Service Actions, Restart Phoenix Query Servers.

3. Under HBase, go to configs, under Filter type in your parameter

4. Change it, save and restart.

https://community.hortonworks.com/questions/68570/cannot-connect-to-phoenix-query-server-using-jdbc.html

https://phoenix.apache.org/server.html

https://community.hortonworks.com/articles/2663/phoenix-queryserver.html

@joshelser

https://community.hortonworks.com/questions/53827/phoenixdb-connection-to-phoenix-query-server.html

Re: Phoenixdb FetchAll not working and returning empty list

geethsameer686 — Thu, 17 Aug 2017 14:35:43 GMT

Thanks a lot Timothy.