phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Elser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2355) Avatica fetch does not return an update row-count for upsert, delete
Date Sun, 01 Nov 2015 04:05:27 GMT

    [ https://issues.apache.org/jira/browse/PHOENIX-2355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14984257#comment-14984257
] 

Josh Elser commented on PHOENIX-2355:
-------------------------------------

Hi [~kliew], this is reminding of a ticket in the Calcite project that has been recently fixed
(but I'm not presently finding it). Might you be able to rebuild Phoenix with the master branch
of Calcite and see if that fixes this issue?

If this is still an issue, we'll want to switch this ticket from Phoenix over to Calcite.
Avatica's code is over there, not here.

> Avatica fetch does not return an update row-count for upsert, delete
> --------------------------------------------------------------------
>
>                 Key: PHOENIX-2355
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-2355
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 4.5.0
>         Environment: Hortonworks HDP 2.3 upgraded to Phoenix 4.5.0
>            Reporter: Kevin Liew
>              Labels: avatica, calcite, fetch, phoenix, prepare, wireprotocol
>
> 1. prepare an upsert or delete
> {noformat}
> {
>   "response": "prepare",
>   "statement": {
>     "connectionId": "36acc5c4-0136-874a-2fcf-a3ec747d7FD4",
>     "id": 1532322378,
>     "signature": {
>       "columns": [
>         
>       ],
>       "sql": "upsert into test.integer_table values ('test3', ?)",
>       "parameters": [
>         {
>           "signed": false,
>           "precision": 0,
>           "scale": 0,
>           "parameterType": 4,
>           "typeName": "INTEGER",
>           "className": "java.lang.Integer",
>           "name": "?1"
>         }
>       ],
>       "cursorFactory": {
>         "style": "LIST",
>         "clazz": null,
>         "fieldNames": null
>       }
>     }
>   }
> }
> {noformat}
> 2. execute by calling 'fetch' to Phoenix
> {noformat}
> request: {
>   "request": "fetch",
>   "connectionId": "36acc5c4-0136-874a-2fcf-a3ec747d7FD4",
>   "statementId": 1532322378,
>   "parameterValues": [
>     {
>       "type": "INTEGER",
>       "value": 1
>     }
>   ],
>   "offset": 0,
>   "fetchMaxRowCount": 100
> }
> {noformat}
> result:
> {noformat}
> {
>   "response": "fetch",
>   "frame": {
>     "offset": 0,
>     "done": true,
>     "rows": [
>       
>     ]
>   }
> }
> {noformat}
> using prepareAndExecute, we get back an update row-count, but prepareAndExecute cannot
be used for parameterized statements



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

Mime
View raw message