/2016 5:37 PM, Plamen Paskov wrote:
Hi Francis,
Thank you for supporting me ! I appreciate that!
Below are the commands i executed and the respective responses. As
you will see the new data is missing.
And these are the details about my setup:
OS: Ubuntu 14.04.3 LTS
hbase: Version 1.1.2.2.3.4.0
quot;:0,
"autoIncrement":false,
"caseSensitive":false,
"searchable":true,
"currency":false,
"nullable":0,
"signed":false,
Why does your commit response have a result set in it? A
CommitResponse is essentially empty.
http://calcite.apache.org/avatica/docs/json_reference.html#commitresponse
Plamen Paskov wrote:
i confirm that the data is missing when connecting using sqlline.py
command line client. If i upsert a r
using something like SquirrelSQL or sqlline to see if the
data was inserted properly?
Another thing I would try is to use separate prepare and execute
requests when SELECTing rather than using prepareAndExecute.
On 19/04/2016 9:21 PM, Plamen Paskov wrote:
Yep
Here are the responses (the new da
"precision": 0,
"scale": 0,
"tableName": "US_POPULATION",
"catalogName": "",
"type": {
"type": "scalar",
"id": 12,
"name": "VA
uot;: 0,
"tableName": "SYSTEM.TABLE",
"catalogName": "",
"type": {
"type": "scalar",
"id": 12,
"name": "VARCHAR",
"rep": "
owCount": -1
}
On 19.04.2016 09:50, F21 wrote:
Can you show the requests you are currently sending? This is what a
PrepareAndExecute request should look like:
https://calcite.apache.org/docs/avatica_json_reference.html#prepareandexecuterequest
On 19/04/2016 4:47 PM, Plamen Paskov wrote:
uot;2".
Plamen Paskov wrote:
Now another error appears for prepare and execute batch request:
Error 500
HTTP ERROR: 500
Problem accessing /. Reason:
com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException:
Unrecognized field "statementId" (class
org.apache.calcite.av
Hey folks,
I'm trying to UPSERT some data via the json api but no luck for now. My
requests looks like:
{
"request": "openConnection",
"connectionId": "6"
}
{
"request": "createStatement",
"connectionId": "6"
}
{
"request": "prepareAndExecute",
"connectionId": "6",
"statementId"
"3",
"statementId": "2",
"sqlCommands": [ "UPSERT INTO us_population VALUES('C1','City
1',10)", "UPSERT INTO us_population VALUES('C2','City 2',100)" ]
}
Any help will be appreciat
Ah i found the error. It should be "sqlCommands": instead of "sqlCommands",
The documentation syntax is wrong for this request type:
http://calcite.apache.org/avatica/docs/json_reference.html#prepareandexecutebatchrequest
On 14.04.2016 11:09, Plamen Paskov wrote:
@Josh: th
ned and closed.
I don't think there are any books (as of yet), but the references and
digging through the code should be quite useful. I also recommend
checking out the avatica project (which is a sub project of calcite)
which is used to power the query server.
Also, the query server uses pro
erver so that it can give you a statementId. Then, use
that statementId in your PrepareAndExecute request and all should be
fine :)
On 13/04/2016 8:24 PM, Plamen Paskov wrote:
Hi guys,
I just setup apache phoenix 4.7 and set the serialization to JSON.
Now i'm trying to run a select sta
Hi guys,
I just setup apache phoenix 4.7 and set the serialization to JSON. Now
i'm trying to run a select statement but what i receive is this:
{
"response": "executeResults",
"missingStatement": true,
"rpcMetadata": {
"response": "rpcMetadata",
"serverAddress": "ip-172-31-27-198
14 matches
Mail list logo
