Skip to content

Support for session-id for multiple query statement #116

@pavelnemirovsky

Description

@pavelnemirovsky

Does chproxy tolerate the session-id field when it's passed between the proxy and Java ClickHouse JDBC client?
I am referring to the following functionality ...

To use temporary tables you need to have an active session. It's enough to add session_id parameter with some value to the URL of ClickHouse request.

So for example:
replace http://127.0.0.1:8123/
to http://127.0.0.1:8123/?session_id=mysession

Later requests with the same session_id will 'remember' temporary tables, settings, etc. you did in previous queries with that session_id.

Please also remember that sessions use exclusive locks, so you can't run 2 requests with the same session_id concurrently. And by default session lifetime equals 60 seconds, but can be adjusted.

Check the official documentation https://clickhouse.yandex/docs/en/interfaces/http/```

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions