Member since
01-26-2016
3
Posts
4
Kudos Received
0
Solutions
01-26-2016
01:28 AM
1 Kudo
I believe I am on HDP 2.2 http://hortonworks.com/blog/microsoft-azure-hdinsight-on-linux-expands-application-platforms/
... View more
01-26-2016
01:14 AM
1 Kudo
Thanks for the quick answer, would you happen to know when it would become available?
... View more
01-26-2016
12:20 AM
2 Kudos
I am looking to combine multiple upsert requests into one request and pass it to the phoenix query server. I am sending the following json to upsert one record POST https://tishihdiphoenix.azurehdinsight.net/hbasephoenix/ HTTP/1.1
request:{"request":"prepareAndExecute","connectionId":"000000-0000-0000-00000001","sql":""UPSERT INTO Table( col1 ) VALUES ( value1 )":100}
Authorization: Basic YWRtaW46Tm9tb3JlTm9tb3JlIT0x
Host: tishihdiphoenix.azurehdinsight.net
Content-Length: 0
Connection: Keep-Alive I want to be able to upsert multiple statements with different values in one json. I tried changing the sql statement to something like UPSERT INTO Table( col1 ) VALUES ( value1 ), ( value2 ) but that didn't work. I followed the steps to prepare request and then created statement. I got a create response but I couldn't get either the fetch or the execute to work.
Fetch response > Statement not found, potentially expired. 000000-0000-0000-00000001::1453337888</pre></p>
Execute response > com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException: Unrecognized field "statementHandle" (class org.apache.calcite.avatica.remote.Service$SchemasRequest), not marked as ignorable (2 known properties: , "catalog", "schemaPattern"])
at [Source: java.io.StringReader@204e1f9c; line: 1, column: 312] (through reference chain: org.apache.calcite.avatica.remote.SchemasRequest["statementHandle"])
Any ideas on what I might need to do after create statement
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix