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