clidey
[BUG] - Query result from scratchpad shows error in clickhouse
Describe the bug I have the following query in the scratchpad
select hostname, type, event_time, query, databases, tables, COLUMNS('exp*'), address, port
from system.query_log
order by event_date, event_time
limit 10
When I selected the ClickHouse database and executed the above query, an error occurred, and it is displayed as shown in the following screenshot.
I think this happens when one of result columns has array type...
To Reproduce As explained above
Expected behavior The normal SQL execution results are displayed.
Screenshots
Additional context .
Hi @touchinno , thanks for trying out WhoDB! It looks like you're missing your screenshot as it's the same code block twice.
Hi @touchinno , thanks for trying out WhoDB! It looks like you're missing your screenshot as it's the same code block twice.
<Ctrl-V> screenshot uploaded ^^
Thank you for uploading your screenshot!
By any chance, are you using a public test database, or are you able me with an idea of how your system.query_log table looks like in terms of column data types?
Thank you for uploading your screenshot!
By any chance, are you using a public test database, or are you able me with an idea of how your system.query_log table looks like in terms of column data types?
That table is the system table which contains information about executed queries managed by clickhouse server.
https://clickhouse.com/docs/en/operations/system-tables/query_log
should be fixed in the latest version when we release, sorry for the delay!
new version released and this should be sorted, so closing it out! Let us know if you come across it/other issues :)