calcite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Francis Chuang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (CALCITE-1181) FetchResponse always return no rows
Date Sun, 03 Apr 2016 11:04:25 GMT
Francis Chuang created CALCITE-1181:
---------------------------------------

             Summary: FetchResponse always return no rows
                 Key: CALCITE-1181
                 URL: https://issues.apache.org/jira/browse/CALCITE-1181
             Project: Calcite
          Issue Type: Bug
          Components: avatica
    Affects Versions: avatica-1.7.1
         Environment: HBase 1.1 and Phoenix 4.7.0
            Reporter: Francis Chuang
            Assignee: Julian Hyde


Assuming I have a table called my_table which is created and seeded like so:

CREATE TABLE my_table (k BIGINT PRIMARY KEY, v VARCHAR) TRANSACTIONAL=true
UPSERT INTO my_table VALUES (1,'A')
UPSERT INTO my_table VALUES (2,'B')

I have 2 rows in the table. If I query the table using SELECT * FROM my_table, and request
a maxRowCount of 1, using FetchRequest to request further rows always returns 0 rows.

For ease of reproduction, I have included CURL commands (avatica will need to have serialization
set to JSON):

curl localhost:8765 -XPOST --data '{"request": "openConnection","connectionId": "my-conn"}'

curl localhost:8765 -XPOST --data '{"request": "createStatement","connectionId": "my-conn"}'
curl localhost:8765 -XPOST --data '{"request": "prepareAndExecute","connectionId": "my-conn","statementId":
12345,"sql": "SELECT * FROM my_table","maxRowCount": 1}' # update the statementId

curl localhost:8765 -XPOST --data '{"request": "fetch","connectionId": "my-conn","statementId":
12345,"offset": 0,"fetchMaxRowCount": 1}' # update the statementId



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message