Is it possible to pass query parameters in the request body for Clickhouse's http interface?

Question

According to the docs, the Clickhouse's http interface allows me to pass query parameters in a query string like this:

First, I can write a query with a parameter:

SELECT * FROM foo WHERE id = {id:text}

This query is passed in the body request, and the value for id is passed in the query string as follows:

http://clickhouse-host:8123/param_id=1

However, I wonder if there's a way to pass both the query and its parameters in the body request. I could not find how to achieve this in the docs.

Answer 1

This works for me:

curl 'http://localhost:8123/?param_size=100' -d "SELECT * FROM numbers({size:UInt32})"