search

tinybirdco / clickhouse_knowledge_base

The Tinybird Knowledge Base for ClickHouse®
https://www.tinybird.co/clickhouse/knowledge-base
Apache License 2.0
71 stars 4 forks source link

normalized_query_hash tip #13

Closed alrocar closed 2 years ago

alrocar commented 2 years ago

Leaving an issue open for now, will create a PR with more details.

When looking for distinct queries in the query_log @Algunenano suggested to discard similar ones (for instance same where filter with different values), you can deduplicate those with the same normalized_query_hash.

Algunenano commented 2 years ago

Related:

No idea how the 2 projects are merged together

alrocar commented 2 years ago

Oh OK! so we already have a tip for that 😅

No idea how the 2 projects are merged together

@sdairs I understand all new stuff should go under this GitHub repo?

sdairs commented 2 years ago

@alrocar correct, you can submit new tips directly as a PR to this repo :) I am still working through the backlog of tips submitted previously