This is an automated comment for commit 511ef1e with description of existing statuses. It's updated for the latest CI running

❌ Click here to open a full report in a separate page

Step 1: #60807

Couldn't reproduce the 02892_orc_filter_pushdown failure locally on mac os. But in CI it failed 5/5 times on ARM and 0/39184 times on non-ARM, so it's not flaky: https://play.clickhouse.com/play?user=play#U0VMRUNUCiAgICB0ZXN0X3N0YXR1cywKICAgIHBvc2l0aW9uKGNoZWNrX25hbWUsICdhYXJjaDY0JykgPiAwIGFzIGFybSwKICAgIG1pbihwdWxsX3JlcXVlc3RfbnVtYmVyKSBhcyBwcjEsCiAgICBtYXgocHVsbF9yZXF1ZXN0X251bWJlcikgYXMgcHIyLAogICAgY291bnQoKQpGUk9NIGNoZWNrcwpXSEVSRSBub3coKSAtIHRvSW50ZXJ2YWxEYXkoOTApIDw9IGNoZWNrX3N0YXJ0X3RpbWUgYW5kIHBvc2l0aW9uKHRlc3RfbmFtZSwgJzAyODkyX29yY19maWx0ZXJfcHVzaGRvd24nKSA+IDAKZ3JvdXAgYnkgYWxsCg==

My other PR #63675 removes Annoy (in favor of USearch). All exclusions no-cpu-aarch64 in 02354_vector_search*.sql are removed by the other PR.

I doubt about the complete removal of Annoy, because at least one big, nice company is successfully using it...
But Annoy is a simple algorithm - we can rewrite the library.

If you look at vector search extensions in other relational and vector DBs, you find HNSW in almost all systems, and Annoy only rarely implemented. From what I read, Annoy doesn't work great with high dimensionality. This was the main reason to remove it.

Actually, #63675 provides a generic "vector similarity" index and the algorithms is specified like this:

CREATE TABLE tab (id Int32, vec Array(Float32), INDEX vec_idx(vec) TYPE vector_similarity('hnsw', 'L2Distance'));

So if we want, we can add it back, perhaps implemented from scratch.

Ah, ok. Let's remove it for now. Possibly add it back later.
At least the data could be re-indexed.

#64563 for 02892_orc_filter_pushdown.

Only Annoy and Intel QPL are not going to be supported.