Phoenixdb FetchAll not working and returning empty list

[#1]

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

1. import phoenixdb
2. database_url ='http://localhost:8765/'
3. conn = phoenixdb.connect(database_url, autocommit=True)
4. cursor = conn.cursor()
5. cursor.execute("upsert into users values(2,'user')")
6. cursor.execute("select * from users")
7. 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.

[#2 · Accepted solution]

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

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

[#3]

Thanks a lot Timothy.