Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Phoenixdb FetchAll not working and returning empty list

Solved Go to solution
Highlighted

Phoenixdb FetchAll not working and returning empty list

New Contributor

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Phoenixdb FetchAll not working and returning empty list

Super Guru
2 REPLIES 2

Re: Phoenixdb FetchAll not working and returning empty list

Super Guru

Re: Phoenixdb FetchAll not working and returning empty list

New Contributor

Thanks a lot Timothy.

Don't have an account?
Coming from Hortonworks? Activate your account here