Re: apache phoenix json api

2016-04-17 Thread Josh Elser
Also, you're using the wrong command. You want "prepareAndExecute" not "prepareAndExecuteBatch". Josh Elser wrote: Thanks, will fix this. Plamen Paskov wrote: Ah i found the error. It should be "sqlCommands": instead of "sqlCommands", The documentation syntax is wrong for this request type:

Re: apache phoenix json api

2016-04-17 Thread Josh Elser
statementId is an integer, not a string. Remove the quotation marks around the value "2". Plamen Paskov wrote: Now another error appears for prepare and execute batch request: Error 500 HTTP ERROR: 500 Problem accessing /. Reason:

Re: apache phoenix json api

2016-04-17 Thread Josh Elser
Thanks, will fix this. Plamen Paskov wrote: 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

Re: prepareAndExecute with UPSERT not working

2016-04-17 Thread Josh Elser
What version of Phoenix are you using? Plamen Paskov wrote: 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":

Re: Phoenix for CDH5 compatibility

2016-04-17 Thread Viswanathan J
What are the required phoenix jars to be copied into HBase libs. On Apr 17, 2016 1:17 PM, "Swapna Swapna" wrote: > Thank you Rafa and James. That helps. > > Regards > Swapna > > On Sat, Apr 16, 2016 at 7:41 AM, James Taylor > wrote: > >> There's

Re: Phoenix for CDH5 compatibility

2016-04-17 Thread Swapna Swapna
Thank you Rafa and James. That helps. Regards Swapna On Sat, Apr 16, 2016 at 7:41 AM, James Taylor wrote: > There's also the branch that Andrew setup here: > https://github.com/chiastic-security/phoenix-for-cloudera > > > On Saturday, April 16, 2016, rafa