Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

ClickHouse tips #11: Best way to get query types

A fast and simple solution to know the types returned by a query
Tinybird
Team
Sep 22, 2021
 ・ 
  min read

There are situations when we might want to retrieve the type of a query, function, aggregation, etc in Clickhouse. This information could be really important when we want to identify and debug an issue.

Checking in the docs of Clickhouse, seems like using {% code-line %}toTypeName(x){% code-line-end %} would provide all that we need.

But there is a catch. For {% code-line %}toTypeName(x){% code-line-end %} to return the type, first, it will need to execute the query. This can lead to a long response time and we might get duplicated results that we do not care about like in the following example.

So, can we find a better solution? Yes, using {% code-line %}DESCRIBE{% code-line-end %}.

{% code-line %}DESCRIBE{% code-line-end %} will return the type after evaluating the query, without execution, and will return only one entry per column. Resulting in an incredible performance boost and more simple solution

Tinybird
Team
Share this post

Subscribe to our newsletter

Musings on transformations, tables and everything in between.