lino
lino

Reputation: 207

How to visualize data using charts in Clickhouse

When running queries on sql.clickhouse.com, we get the option to visualize data using charts.

For example (Link to this query example):

select number AS NUMERO,arraySum(range(NUMERO)) as a from numbers(15) order by a desc

I get

NUMERO a
14 91
13 78
12 66
11 55
10 45
9 36
8 28
7 21
6 15
5 10
4 6
3 3
2 1
0 0
1 0

And I can choose between the "Results" and "Charts" options to visualize the data.

enter image description here

From http://localhost:8123/play, the option to generate charts isn’t available. But if I use 'FORMAT JSONCompactColumns', it generates a chart that I don’t quite understand because it doesn’t look the same enter image description here

How can I use the same visualization as sql.clickhouse.com locally?

Upvotes: 0

Views: 20

Answers (0)

Related Questions