[
https://issues.apache.org/jira/browse/PHOENIX-2320?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15229164#comment-15229164
]
Josh Elser commented on PHOENIX-2320:
-------------------------------------
[~tsriniv...@gmail.com], I'm not sure what versions of HDI correspond to the
Apache Phoenix/Calcite versions. I'd recommend contacting the vendor for help,
or, if you can provide the information to correlate this back to Apache
versions, I'd be happy to try to help out.
> Not able to run upsert query over phoenix query server.
> -------------------------------------------------------
>
> Key: PHOENIX-2320
> URL: https://issues.apache.org/jira/browse/PHOENIX-2320
> Project: Phoenix
> Issue Type: Wish
> Reporter: Appasaheb Sawant
> Assignee: Josh Elser
>
> Not able to run upsert query over phoenix query server. Select query works
> but for upsert query records are not inserted into phoenix.
> This is CODE
> <?php
> $ch = curl_init();
> curl_setopt($ch, CURLOPT_URL,"http://localhost:8765/";);
> curl_setopt($ch, CURLOPT_POST, true);
> curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
> $headers = array();
> // For Select.
> //$headers[] = 'request:
> {"request":"prepareAndExecute","connectionId":"aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa","sql":"select
> * from BLOG.POST"}';
> // For Upsert.
> $headers[] = 'request:
> {"request":"prepareAndExecute","connectionId":"aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa","sql":"UPSERT
> INTO BLOG.POST (POST_ID,TITLE,CONTENT) values (\'aa11111\',\'Test
> Title\',\'this is test post content\')"}';
> curl_setopt($ch, CURLOPT_HTTPHEADER, $headers);
> $server_output = curl_exec ($ch);
> curl_close ($ch);
> OUTPUT
>
> {"response":"Service$ExecuteResponse","results":[{"response":"resultSet","connectionId":"aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa","statementId":1164383384,"ownStatement":false,"signature":null,"firstFrame":null,"updateCount":1}]}
> But record is not inserted ...
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
