Gabriel39 opened a new pull request, #4441: URL: https://github.com/apache/doris-website/pull/4441
Ordinary SQL search over Lance is not described in the current 4.x reference. This documents the branch-4.2 behavior introduced by https://github.com/apache/doris/pull/69346 (implementation PR is still open; this documentation depends on it). For example, an eligible `ORDER BY cosine_similarity_approximate(embedding, [0.1,0.2,0.3,0.4]) DESC LIMIT 10` becomes native Lance cosine retrieval, with `1 - _distance` projected as similarity. Exact functions and ACL/EXISTS queries retain scalar distance evaluation and global Top-N. - Add matching English/Chinese guidance for five approximate vector functions, MATCH/BM25, ordering and result conversion, native versus scalar NULL/NaN/zero-vector semantics, UInt8 Hamming validation, bounded row-ID prefilters, and JOIN/EXISTS boundaries. - Add English/Chinese SQL references for `cosine_distance_approximate`, `cosine_similarity_approximate`, `hamming_distance`, and `hamming_distance_approximate`, including normal, zero/empty, NULL, and out-of-range examples. - Add navigation entries, link from Lance Catalog, and clarify that ordinary SQL rewritten to search TVFs can qualify for two-phase output reads. Version scope: this change intentionally updates **4.x English and Chinese only**. The implementation targets `branch-4.2`, not Doris master; current/development and older-version pages are not being advertised as supporting it. This explains the governance version-counterpart warnings. Availability wording requires a Doris 4.2 build containing this capability, rather than implying every build with the explicit TVFs already supports rewriting. Validation: all 12 changed documentation pages compiled with the Docusaurus MDX processor; changed-page link checks found no broken links; SQL-function structure checks passed; paired English/Chinese SQL blocks match; all six added sidebar references resolve; whitespace and added-content disclosure checks passed. SEO descriptions satisfy the configured length range. Remaining SEO duplicate-title warnings reflect shared SQL identifiers across locales and existing versioned titles. Full-repository sidebar lint reports unrelated existing findings. Full site build and live SQL execution were not run. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
