clickhouse-tableau-connector-jdbc icon indicating copy to clipboard operation
clickhouse-tableau-connector-jdbc copied to clipboard

Published 20 hours ago • verified publisher icon ClickHouse

TOO_MANY_SIMULTANEOUS_QUERIES from tableau

Open vgcrld opened this issue 1 year ago • 8 comments

I get the following from myTableau server and/or Tableau client connecting to the clickhouse when refreshing a tableau report.

Error executing subquery id: "4553" Code: 202. DB::Exception: Too many simultaneous queries. Maximum: 15. (TOO_MANY_SIMULTANEOUS_QUERIES) (version 22.8.20.11 (official build)) , server ClickHouseNode(addr=http:xxx-clickhouse-default-1.core.xxxx.com:443, db=default)@1273894842 Connector Class: clickhouse_jdbc, Version: 0.2.6

Is there a way to throttle how many connections are made at the JDBC (client) level? to avoid this limitation on the clickhouse server? It seems it should be possible to pass JDBC option to throttle how many QUERIES run ?

vgcrld avatar Oct 09 '23 18:10 vgcrld