Reputation: 207
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.
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
How can I use the same visualization as sql.clickhouse.com locally?
Upvotes: 0
Views: 20