QueryTable¶
Description¶
description: |
Query table `id` with vector search, full text search and optional SQL filtering.
Returns results in Arrow IPC file or stream format.
Request Schema¶
QueryTableRequest:
type: object
required:
- vector
- k
properties:
id:
type: array
items:
type: string
bypass_vector_index:
type: boolean
description: Whether to bypass vector index
columns:
type: array
nullable: true
items:
type: string
description: Optional list of columns to return
distance_type:
type: string
description: Distance metric to use
ef:
type: integer
minimum: 0
description: Search effort parameter for HNSW index
fast_search:
type: boolean
description: Whether to use fast search
filter:
type: string
description: Optional SQL filter expression
full_text_query:
type: object
nullable: true
description: Optional full-text search query. Provide either string_query or structured_query, not both.
properties:
string_query:
$ref: '#/components/schemas/StringFtsQuery'
structured_query:
$ref: '#/components/schemas/StructuredFtsQuery'
k:
type: integer
minimum: 0
description: Number of results to return
lower_bound:
type: number
format: float
description: Lower bound for search
nprobes:
type: integer
minimum: 0
description: Number of probes for IVF index
offset:
type: integer
minimum: 0
description: Number of results to skip
prefilter:
type: boolean
description: Whether to apply filtering before vector search
refine_factor:
type: integer
format: int32
minimum: 0
description: Refine factor for search
upper_bound:
type: number
format: float
description: Upper bound for search
vector:
type: object
nullable: true
description: Query vector(s) for similarity search. Provide either single_vector or multi_vector, not both.
properties:
single_vector:
type: array
items:
type: number
format: float
description: Single query vector
multi_vector:
type: array
items:
type: array
items:
type: number
format: float
description: Multiple query vectors for batch search
vector_column:
type: string
description: Name of the vector column to search
version:
type: integer
format: int64
minimum: 0
description: Table version to query
with_row_id:
type: boolean
description: If true, return the row id as a column called `_rowid`
Response¶
The response returns query results in Arrow IPC file or stream format containing the matching records based on the search criteria.