Oh, I didn't know there was a 4.7. Following the links on https://phoenix.apache.org/download.html only takes me to locations that have 4.6 available to download, which is the version I am using.
Looking at my 4.6 pom.xml it appears to be build with <calcite.version>1.3.0-incubating</calcite.version> , which incidentally may answer my other related/similar question in my other email: How to send the query on the body. I now see form your source code that this is only supported for "if self.version >= AVATICA_1_4_0:" So I will hunt for Phoenix 4.7 to see if it can solved both my issues. Thank you, Lukas. By the way, in case this helps anyone else, I found these two links: - http://hortonworks.com/search-results/?search=phoenix+query+server - https://community.hortonworks.com/questions/1985/phoenix-query-server-upsert-fail.html Thanks, Steve On Fri, Feb 5, 2016 at 10:41 AM, Lukáš Lalinský <[email protected]> wrote: > This depends on the exact version of Avatica you are using, because it's > different in all released versions. > > In this comment you can see an example of running UPSERT with 1.4 with the > JSON serializer (I think Phoenix 4.7 includes that version): > > > https://issues.apache.org/jira/browse/CALCITE-1050?focusedCommentId=15093324&page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15093324 > > You can also try my Python module for talking to the server. With verbose > logging, it will print the exact JSON documents it's sending. > > https://code.oxygene.sk/lukas/python-phoenixdb > > Lukas > > > On Fri, Feb 5, 2016 at 5:16 PM, Steve Terrell <[email protected]> > wrote: > >> Does anyone have an example of how to upsert a row in a Phoenix table via >> the Avatica HTTP mechanism? >> >> The closest thing to documentation I can find are these two links: >> >> - >> >> https://community.hortonworks.com/questions/1565/phoenix-query-server-documentation.html >> - https://calcite.apache.org/docs/avatica_json_reference.html >> >> I got the select example working, but cannot get an upsert to work. >> >> Thanks, >> Steve >> > >
