Clickhouse: system.query_log table is not documented
It's missing from here: https://clickhouse.yandex/docs/en/system_tables/index.html
bobrik
All 7 comments
What's the meaning of type column? — that was my initial question, though.
bobrik
on 2 Jun 2017
https://github.com/BayoNet is going to add the documentation.
What's the meaning of type column? — that was my initial question, though.
1 - successful start of query execution
2 - successful end of query execution
3 - exception before start of query execution
4 - exception while query execution
Each query create one or two events in query_log table:
- two events with types 1 and 2: usual, successful case;
- two events with types 1 and 4;
- single event with type 3;
alexey-milovidov
on 4 Jun 2017
Are there any way to avoid writing INSERT queries into query_log ?
hagen1778
on 4 Jun 2017
There is no way. Please note, that INSERTs are logged without data.
alexey-milovidov
on 4 Jun 2017
can I safely truncate query_log table?
jangorecki
on 24 Feb 2019
can I safely truncate
query_logtable?
Yes, it's 100% safe.
filimonov
on 15 May 2019
Documentation is added and available on the official website:
https://clickhouse.yandex/docs/en/operations/system_tables/#system_tables-query-log
filimonov
on 15 May 2019
Related issues
jangorecki
·
3Comments
bseng
·
3Comments
SaltTan
·
3Comments
greenx
·
3Comments
fizerkhan
·
3Comments
Most helpful comment
https://github.com/BayoNet is going to add the documentation.
1 - successful start of query execution
2 - successful end of query execution
3 - exception before start of query execution
4 - exception while query execution
Each query create one or two events in
query_logtable: