Steve T created PHOENIX-2660:
--------------------------------
Summary: Need Detailed Documentation for HTTP Avatica Support
Key: PHOENIX-2660
URL: https://issues.apache.org/jira/browse/PHOENIX-2660
Project: Phoenix
Issue Type: Improvement
Affects Versions: 4.6.0, 4.7.0
Reporter: Steve T
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
[email protected] . 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
(v6.3.4#6332)
