Have the presto jdbc driver handle set-cookie responses that may come from load balancers.

[alee-r7]

We've been wanting to run more than 1 presto cluster behind an ELB and have our applications use the Presto JDBC driver to issues queries against. Unfortunately it doesn't work since a single request is composed of multiple http requests and those requests will be distributed to each cluster.

What would be nice is if we can take advantage of AWS ELB's stick session policy. This would require the Cookie header to be set. But with the JDBC driver you can't set it. If I could set any type of custom or fixed cookie header in my request, then my application could generate unique id for that request before sending out the request.

[alee-r7]

Actually this approach is wrong. In order for this to work the driver will need to look for Set-cookie responses and resent those cookies in the follow up requests after the initial. This way you can use the ELB generated session cookies vs. having Presto define it. I've gotten it to work by reimplementing the StatementClient in the JDBC driver to look for the Set-Cookie response for the AWS ELB. Then resending it works.

I would suggest to allow the presto JDBC driver to handle set-cookie responses as an option and custom configure which cookie value they to resend.

[findepi]

@alee-r7 , did you see #9684 ?

[alee-r7]

No I haven't but looks like that should work if it supports cookies. I guess I'll wait until it gets merged into master and then AWS upgrades their version of Presto.

[findepi]

#9684 is merged, closing this.