phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Phoenix Query Server Avatica Upsert
Date Fri, 05 Feb 2016 17:26:23 GMT
Phoenix 4.7.0 is not released yet. A couple of issues can up in the last
RC, so we'll roll a new one very soon.

Thanks,
James

On Fri, Feb 5, 2016 at 9:23 AM, Steve Terrell <sterrell@oculus360.us> wrote:

> 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ý <lalinsky@gmail.com>
> 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 <sterrell@oculus360.us>
>> 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
>>>
>>
>>
>

Mime
View raw message