The 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/?v=1.6' 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() ... View more