Milvus
Use SQL-style commands and the Builder API to operate Milvus collections and vectors. Connection setup is described in JDBC Milvus.
dbVisitor Usage
- Programmatic API: queries, writes, multiple results, and stored routine differences.
- Mapper API: annotations, Mapper reads and writes, and execution differences.
- Builder API: Supported operations, datasource-specific behavior, and usage.
- Query Operations: Execute queries, combine filters, and map results.
- Data Writes: Insert, update, delete, and handle write results.
- Pagination: Fetch a range and obtain totals.
- Vector Operations: Field mapping, search metrics, and supported queries.
- Key Generation: Assign identifiers or read generated IDs.
- Type Support: Choose Java types for stored values.
- Transaction Support — transaction API behavior and isolation settings.
Language Basics
Notation and Comments · Identifiers · Literals and Parameters · Operators · Hint Support
Data Types
Scalar Types · JSON · ARRAY · Vector Values
Length, Capacity and Dimensions · Field Constraints · JSON, ARRAY and Vector Binding
Query Statements
SELECT · COUNT / SELECT COUNT(*) · HYBRID
Write Statements
INSERT · UPSERT · UPDATE · DELETE · IMPORT
Definition Statements
CREATE DATABASE · ALTER DATABASE · DROP DATABASE
CREATE TABLE · ALTER TABLE · DROP TABLE · TRUNCATE TABLE
CREATE INDEX · ALTER INDEX · DROP INDEX
CREATE PARTITION · DROP PARTITION
CREATE ALIAS · ALTER ALIAS · DROP ALIAS
FUNCTION Definitions · ALTER TABLE … FUNCTION
SHOW Statements
SHOW DATABASES / DATABASE · SHOW TABLES / TABLE / CREATE TABLE
SHOW INDEXES / INDEX · SHOW PARTITIONS / PARTITION · SHOW ALIASES / ALIAS
SHOW STATS · SHOW PROGRESS · SHOW IMPORT / IMPORTS · SHOW FLUSH ALL
SHOW REPLICAS · SHOW RESOURCE GROUPS / GROUP
SHOW COMPACTION · SHOW PERSISTENT SEGMENTS · SHOW QUERY SEGMENTS
SHOW USERS / USER · SHOW ROLES / ROLE · SHOW GRANTS · SHOW PRIVILEGE GROUPS
SHOW VERSION · SHOW HEALTH
Administration Statements
ANALYZE · LOAD · RELEASE
FLUSH · COMPACT
Resource Group Statements · TRANSFER NODES / REPLICAS
User Statements · Role Statements · GRANT / REVOKE · Privilege Group Statements