You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Kevin Risden (JIRA)" <ji...@apache.org> on 2018/03/04 23:07:00 UTC

[jira] [Commented] (CALCITE-1081) Need Detailed Documentation for HTTP Avatica Support

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

Kevin Risden commented on CALCITE-1081:
---------------------------------------

Looks like some of this was duplicated with CALCITE-1195 and now published to [https://calcite.apache.org/avatica/docs/protocol_testing.html|https://calcite.apache.org/avatica/docs/protocol_testing.html.]

[~elserj] - Is there more to do here?

> Need Detailed Documentation for HTTP Avatica Support
> ----------------------------------------------------
>
>                 Key: CALCITE-1081
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1081
>             Project: Calcite
>          Issue Type: Improvement
>          Components: avatica
>            Reporter: Steve T
>            Assignee: Josh Elser
>            Priority: Major
>
> I was unable to find any documentation on how to use the Avatica features.  I was not even able to find them on the Avatica site.  Would be great if Phoenix had a least a few examples of how to us the feature such as the one I wrote below.  It took me 2-3 days to figure it out with the help of user@phoenix.apache.org .  Should have only taken about 15 minutes.  Granted, the JSON format is outdated in recent versions, but you get the idea.  I couldn't even figure out which requests were required and what sequence they had to be in.
> {code:title=example_upsert.sh|borderStyle=solid}
> #!/bin/bash
> curl -XPOST -H 'Content-Type application/json; charset=UTF-8' -d '{"connectionId": "00000000-0000-0000-0000-000000000000", "request": "openConnection"}' http://10.0.100.28:8765/
> curl -XPOST -d '{"connectionId": "00000000-0000-0000-0000-000000000000", "request": "connectionSync", "connProps": {"autoCommit": null, "connProps": "connPropsImpl", "transactionIsolation": null, "catalog": null, "readOnly": null, "dirty": null, "schema": null}}' http://10.0.100.28:8765/
> curl -XPOST -d '{"connectionId": "00000000-0000-0000-0000-000000000000", "request": "connectionSync", "connProps": {"autoCommit": true, "connProps": "connPropsImpl", "transactionIsolation": null, "catalog": null, "readOnly": null, "dirty": null, "schema": null}}' http://10.0.100.28:8765/
> curl -XPOST -d "{\"request\":\"createStatement\",\"connectionId\":\"00000000-0000-0000-0000-000000000000\"}" http://10.0.100.28:8765/
> echo
> echo Enter the statementId:
> read statement_id
> echo
> echo Enter the value:
> read value
> curl -XPOST -d "{\"request\":\"prepareAndExecute\",\"connectionId\":\"00000000-0000-0000-0000-000000000000\",\"sql\":\"upsert into CAT_MAP(CHA, CAT, MAP) values('TEST_RECORD_CHANNEL', 'Test::Record::Channel::Category', '$value')\", \"statementId\":$statement_id}" http://10.0.100.28:8765/
> curl -XPOST -d "{\"request\":\"prepareAndExecute\",\"connectionId\":\"00000000-0000-0000-0000-000000000000\",\"sql\":\"upsert into CAT_MAP(CHA, CAT, MAP) values('TEST_RECORD_CHANNEL2', 'Test::Record::Channel::Category', '$value')\", \"statementId\":$statement_id}" http://10.0.100.28:8765/
> curl -XPOST -d "{\"request\":\"closeStatement\",\"connectionId\":\"00000000-0000-0000-0000-000000000000\", \"statementId\":$statement_id}" http://10.0.100.28:8765/
> curl -XPOST -d '{"connectionId": "00000000-0000-0000-0000-000000000000", "request": "closeConnection"}' http://10.0.100.28:8765/
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)