phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Steve Terrell <>
Subject Re: How do I query the phoenix query server?
Date Thu, 24 Mar 2016 16:39:27 GMT
As I recall, I did try setting auto commit to True, but it did not help.
With/without auto commit, my writes would work soon after I started
SQuirreL Client, but always stopped working after some time passed until I
restarted the client.

I discovered I needed the extra jar when I had a complex query using nested
AND and OR operators.  But I don't remember the exact expression.

On Thu, Mar 24, 2016 at 11:20 AM, Josh Elser <> wrote:

> Correct, James:
> Phoenix-4.7.0 uses Calcite-1.6.0. This included lots of goodies includes
> commit/rollback support. Phoenix-4.6.0 used Calcite-1.3.0. In general, if
> you want to use the QueryServer, I'd strongly recommend trying to go with
> Phoenix-4.7.0. You'll inherit *lots* of bugfixes/improvements.
> @F21: For implementing your own client, you might be interested in
> If you need
> help, please reach out (here or on A Go client
> would be fantastic. Making this an official-client for Avatica, it'd be
> great :)
> @Steve, are you saying that you found PQS to also require
> commons-collections to be added? The phoenix-server-$VERSION-runnable.jar
> should contain all necessary classes -- if that's not true, that's a bug we
> can fix.
> James Taylor wrote:
>> Steve,
>> For deletes and upsets through the query server in 4.6, did you set auto
>> commit to be true by default (set phoenix.connection.autoCommit to
>> true)? In 4.7 this has been fixed, but prior to this, I believe commit
>> and rollback were a noop. Is that right, Josh?
>> Thanks,
>> James
>> On Thursday, March 24, 2016, Steve Terrell <
>> <>> wrote:
>>     I forgot to mention, although the docs say only one jar is needed, I
>>     found that I also had to have commons-collections-3.2.1.jar in the
>>     class path, too.
>>     On Thu, Mar 24, 2016 at 10:07 AM, Steve Terrell
>>     <
>>     <javascript:_e(%7B%7D,'cvml','');>> wrote:
>>         Hi!  Everything I say below pertains only to Phoenix 4.6.0.
>>         Don't know what changes in 4.7.0.
>>         Judging from the port number, you must be using the thin client
>>         server.  Have you seen this page?
>>  .  It has JDBC info.
>>         I got the thin client jar to work with SQuirreL Client, but I
>>         found that sometimes upserts and deletes did not take effect,
>>         even though there was no error reply.  So I don't use the thin
>>         client.  (Had no problems with read-only queries.)
>>         So, I decided to use only
>>         the phoenix-4.6.0-HBase-0.98-client.jar JDBC instead for both
>>         read/write.
>>         In fact, I wrote my own query server that uses the latter JDBC
>>         connection so I can have clients that perform queries with HTTP
>>         without having to have a jar file.
>>         Hope this helps,
>>              Steve
>>         On Wed, Mar 23, 2016 at 7:57 PM, F21 <
>>         <javascript:_e(%7B%7D,'cvml','');>> wrote:
>>             I am interested in building a Go client to query the phoenix
>>             query server using protocol buffers.
>>             The query server is running on http://localhost:8765, so I
>>             tried POSTing to localhost:8765  with the marshalled
>>             protocol buffer as the body.
>>             Unfortunately, the server responds with:
>>             <head>
>>             <meta http-equiv="Content-Type"
>>             content="text/html;charset=ISO-8859-1"/>
>>             <title>Error 500 </title>
>>             </head>
>>             <body>
>>             <h2>HTTP ERROR: 500</h2>
>>             <p>Problem accessing /. Reason:
>>             <pre>    Cannot find parser for 123456</pre></p>
>>             <hr /><i><small>Powered by Jetty://</small></i>
>>             </body>
>>             </html>
>>             "123456" is my connection-id.
>>             There doesn't seem to be any documentation on how to query
>>             the query server (i.e, which endpoints and how the
>>             marshalled protocol buffer should be sent). If someone could
>>             point me in the right direction, that would be awesome!

View raw message