Ah, makes sense. Also,should the offset be incremented on a per frame or
a per row basis? Regarding the offsets being 0, I opened CALCITE-1181,
so hopefully we can get that sorted.
On 4/04/2016 11:57 PM, Josh Elser wrote:
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<[email protected]> 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<[email protected]> 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!
