About geethsameer686

geethsameer686 · ‎08-17-2017

Thanks a lot Timothy.

geethsameer686 · ‎08-17-2017

@Timothy Spann Hi Timothy. I am using Phoenix for my project and I am stuck with Array types. My query is, suppose I have an array column in my table, I am inserting the data in that array, and after some time, weeks, months I will need to update the array, basically append/remove the data to/from it, basically modify the array but I am unable to find the solution for it. Could you help me with this? I found this in the Limitations of array on Phoenix.apache.org: --> Partial update of an array is currently not possible. Instead, the array may be manipulated on the client-side and then upserted back in its entirety. Is there any work around for this? Phoenix array type: https://phoenix.apache.org/array_type.html Thanks in advance.

geethsameer686 · ‎08-16-2017

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

Online	Offline
Last Visited	‎12-01-2017 10:05 PM

Date Registered	‎08-16-2017 08:32 AM
Last Visited	‎12-01-2017 10:05 PM
Total Messages Posted	5
Total Kudos Received	1

Re: Phoenixdb FetchAll not working and returning e...

Phoenix Array datatype issue

Phoenixdb FetchAll not working and returning empty...