This post introduces the NEAREST BY JOIN, a new capability for Databricks Runtime that integrates vector search as a first-class SQL join. It details the architectural approach, including query rewrite strategies, optimizations within the Photon execution engine, and the implementation of a vector index in an open storage format. This capability aims to enable efficient and scalable similarity search directly within SQL queries, making vector search accessible to a broader range of data analytics and AI workloads.
All Databricks trails