Re: PSQ processlist

2019-09-10 Thread Josh Elser
As you might already know, JDBC is "stateful" in what it does. You have a Connection, which creates Statements, and the combination of those two track queries being run. However, HTTP is a stateless protocol. As such, PQS has to cache things in memory in order to make this approach work. To

Re: PSQ processlist

2019-09-10 Thread Aleksandr Saraseka
Thank you Josh, this is very helpful. Another question - can we kill long running query in PQS somehow ? On Mon, Sep 9, 2019 at 5:09 PM Josh Elser wrote: > Not unique to PQS, see: > > https://issues.apache.org/jira/browse/PHOENIX-2715 > > On 9/9/19 9:02 AM, Aleksandr Saraseka wrote: > > Hello. >

Re: PSQ processlist

2019-09-09 Thread Josh Elser
Not unique to PQS, see: https://issues.apache.org/jira/browse/PHOENIX-2715 On 9/9/19 9:02 AM, Aleksandr Saraseka wrote: Hello. Does Phoenix Query Server have any possibility to track running queries ? Like user connects with thin client and run some long running query, can I understand who an