calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <josh.el...@gmail.com>
Subject Re: Starting a transaction with avatica and a few other things
Date Mon, 04 Apr 2016 13:57:35 GMT
Hrm, I'm not sure off the top of my head how the offset returned by the 
server operates. If it's not returning the offset for the current 
"batch" of results, that's an accidental omission (but a client can 
easily track the offset, which would explain how the omission happened 
in the first place).

F21 wrote:
> Hey Josh,
>
> Thanks for your examples, those are pretty useful. I have one question
> about offsets. In your example, you started with an offset of 0 and
> added to the offset as you fetched more rows from the server. Does the
> first frame from a prepareAndExecute result always have an offset of 0?
>  From my limited testing, it appears the offsets returned by the server
> never increases.
>
> Thanks!
>
> On 29/03/2016 1:43 AM, Josh Elser wrote:
>> If you're still trying to wrap your head around how to interact with
>> the Avatica server (PQS in your case),
>> https://issues.apache.org/jira/browse/CALCITE-1081 might be of some help.
>>
>> Specifically, I tried to outline what kind of requests you might send
>> for some basic operations
>> http://people.apache.org/~elserj/calcite/docs/avatica_example_client.html
>>
>> LMK if these are helpful (or not) and what kind of additional
>> documentation/instructions would be useful.
>>
>> James Taylor wrote:
>>> That documentation is still the same. Going through the query server
>>> doesn't change anything. The important quote there about starting a
>>> transaction:
>>>
>>> A transaction is started implicitly through the execution of a
>>> statement on
>>> a transactional table and then finished through either a commit or
>>> rollback.
>>>
>>> On Sat, Mar 26, 2016 at 11:08 PM, F21<f21.groups@gmail.com> wrote:
>>>
>>>> Hi James,
>>>>
>>>> Thanks for the quick reply. The docs does talk about how to use
>>>> transactions with phoenix, but doesn't seem to answer my questions
>>>> regarding implementing transactions for a phoenix query server client.
>>>>
>>>> Cheers!
>>>>
>>>>
>>>> On 27/03/2016 5:04 PM, James Taylor wrote:
>>>>
>>>>> Please read https://phoenix.apache.org/transactions.html and let us
>>>>> know
>>>>> if
>>>>> it doesn't answer your questions.
>>>>>
>>>>> Thanks,
>>>>> James
>>>>>
>>>>> On Sat, Mar 26, 2016 at 10:00 PM, F21<f21.groups@gmail.com> wrote:
>>>>>
>>>>> Hi guys,
>>>>>> As I posted on the Phoenix list a few days ago, I am working on a
>>>>>> golang
>>>>>> client for the phoenix query service (which uses avatica).
>>>>>>
>>>>>> In regards to starting a transaction, I see that the protobuf
>>>>>> reference
>>>>>> contains Commit and Rollback requests, but there isn't any Begin
>>>>>> request.
>>>>>>
>>>>>> Is sending a ConnectionSync request and setting autoCommit to
>>>>>> false the
>>>>>> correct way to start a transaction?
>>>>>>
>>>>>> Also, what is the state of autoCommit when I send an Open request
>>>>>> to the
>>>>>> server?
>>>>>>
>>>>>> Finally, the Open request allows me to send a map called info.
>>>>>> What is
>>>>>> suppose to go into this map?
>>>>>>
>>>>>> Cheers!
>>>>>>
>>>>>>
>>>
>

Mime
View raw message