Merging (feature) Use Map data type for system logs tables#23934
Conversation
|
Functional stateless tests (address) failed query: |
|
@hexiaoting we recently checked and a lot of users rely on our system tables, for example there are tools that are not longer supported by maintainers that rely on some system.tables structure. As additional change we need to keep old columns as virtual storage columns. Check for example system.dictionaries. That way there will be no backward incompatible changes. |
|
@kitaisreal |
|
@hexiaoting yes, it will be best solution for us, because if we merge it as is, there will be issues that some tool that cannot be updated is commited to our system tables column names. |
OK, I will rewrite the implementation. |
|
@kitaisreal I have check Another way, If I using alias like: So, any advice? |
|
@kitaisreal I need your help. Can you give me some advices when you are free, Thank you. |
|
@hexiaoting sorry for the delay, I need to investigate this. Maybe it will require some additional refactoring, but we cannot change logs tables in backward incompatible way, please check #23435. |
I hereby agree to the terms of the CLA available at: https://yandex.ru/legal/cla/?lang=en
Merging #18762
Changelog category (leave one):
Changelog entry (a user-readable short description of the changes that goes to CHANGELOG.md):
Use Map data type for system logs tables (system.query_log, system.query_thread_log, system.processes, system.OpenTelemetrySpanLog).
These tables will be auto created with new datatypes, old queries maybe incompatible.
Close #18698