https://signoz.io logo
#support
Title
# support
h

Harshith.R.S

06/26/2023, 6:50 AM
Hey how do I combine two clickhouse queries
s

Srikanth Chekuri

06/26/2023, 8:29 PM
You can write a single ClickHouse query that combines the result of two queries by using subqueries.
h

Harshith.R.S

06/27/2023, 2:31 AM
Can you give me an example
v

Vishal Sharma

06/27/2023, 3:24 AM
You can use
WITH
to write subqueries, here’s example: https://onelinerhub.com/clickhouse/using-subqueries-in-with-queries
Also I am curious to know why you had to write clickhouse query? For most of queries, query builder works. Have you tried query builder?
h

Harshith.R.S

06/27/2023, 3:33 AM
It says I've exhausted the amount of panels that can be created using query builder
v

Vishal Sharma

06/27/2023, 4:55 AM
You can upgrade to paid plan which will offer unlimited panels, alerts and more advanced features.
h

Harshith.R.S

06/27/2023, 5:08 AM
where can I check what features are available for free plan?
5 Views