Member since
08-16-2017
5
Posts
1
Kudos Received
0
Solutions
08-17-2017
07:35 AM
Thanks a lot Timothy.
... View more
08-17-2017
07:31 AM
@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.
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix
08-16-2017
08:43 AM
1 Kudo
@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.
... View more
Labels:
- Labels:
-
Apache Phoenix