v.21.2Improvements
Add normalizeQueryKeepNames and normalizedQueryHashKeepNames for Improved Query Log Analysis
AddnormalizeQueryKeepNamesandnormalizedQueryHashKeepNamesto normalize queries without masking long names with?. This helps better analyze complex query logs. #18910 (Amos Bird).
Why it matters
This feature addresses the issue of losing meaningful identifier names in query normalization when they are masked with?. By preserving the original names in the normalized queries, users can more effectively analyze, track, and debug complex query patterns in logs.How to use it
Use the new functionsnormalizeQueryKeepNames(query) and normalizedQueryHashKeepNames(query) to obtain normalized query strings and their hashes without masking identifier names. Integrate these functions in query analysis workflows to retain full detail of original query components.