phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Josh Elser (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PHOENIX-2320) Not able to run upsert query over phoenix query server.
Date Wed, 06 Apr 2016 21:30:25 GMT

    [ 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:
-------------------------------------

[~tsrinivasr@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)

Mime
View raw message