Multistatement query is not executing

[AKGP]

I had an issue with running the multi statement query. Please provide a solution for this.

[southwolf]

Search Google. Clickhouse HTTP mode does not support multi statement.

https://groups.google.com/forum/#!topic/clickhouse/Bd-WWGhahO8
ClickHouse/clickhouse-java#51

[nezed]

Thats right, since node-clickhouse uses HTTP interface, multi statement queries aren't supported.
Pay attention! Clickhouse is OLAP oriented DBMS and designed for queries with large data aggregation.

In case if you're still need to run few queries at the time, you may try following:

SELECT
  (SELECT 1) AS a,
  (SELECT 2) AS b

or

const [a, b] = await Promise.all([
  ch.querying('SELECT 1'),
  ch.querying('SELECT 2'),
])

.querying isn't recommended for large datasets!