What started as an investigation into filtering inconsistent dot-key notation in JSON logs ended up optimising our query performance by 30%.
How do handle data that was ingested before a path was promoted to "hot"? Those logs will have the path the primary column rather than the secondary.
hi Richard, if a path is not promoted, those paths will be inserted in the primary column as you expected.
How do handle data that was ingested before a path was promoted to "hot"? Those logs will have the path the primary column rather than the secondary.
hi Richard, if a path is not promoted, those paths will be inserted in the primary column as you expected.