TechPrufer
Get started
Milvus
Milvus logoMilvus · Feature trail

Metadata Management

1 post · Dec 2019

What this trail covers

Milvus has evolved its metadata management capabilities, including detailed field descriptions for Tables and TableFiles, support for partitioning with new fields like owner_table, partition_tag, and version, and enhanced file status tracking. This post details the fields within the metadata tables, including `id`, `table_id`, `state`, `dimension`, `created_on`, `flag`, `index_file_size`, `engine_type`, `nlist`, `metric_type` for the `Tables` table, and `owner_table`, `partition_tag`, `version` for TableFiles. It also provides instructions on how to view this metadata using SQLite or MySQL backends.

All Milvus trails
  1. Milvus Metadata Management (2)This post details the fields within the `Tables` and `TableFiles` metadata tables in Milvus versions 0.5.0 and 0.6.0. It explains the purpose of fields such as id, index_file_size, engine_type, metric_type, state, created_on, owner_table, partition_tag, and version. It also describes file status, file size, and vector row counts within the `TableFiles` table.
  2. Milvus Metadata Management (2) Fields in the Metadata TableThis post details the specific fields within Milvus's metadata tables, specifically the `Tables` and `TableFiles` tables. For the `Tables` table, it describes fields such as `id`, `table_id`, `state`, `dimension`, `created_on`, `flag`, `index_file_size`, `engine_type`, `nlist`, and `metric_type`. It also introduces new fields for partition management in version 0.6.0: `owner_table`, `partition_tag`, and `version`. For the `TableFiles` table, it details fields like `id`, `table_id`, `engine_type`, `file_id`, `file_type`, `file_size`, `row_count`, `updated_time`, `created_on`, and `date`.
  3. Milvus Metadata Management (1)This post details how to view Milvus metadata by configuring the `backend_url` to use either SQLite or MySQL. It provides specific SQL queries for inspecting the `Tables` and `TableFiles` tables in both configurations and includes screenshots of the output.
  4. Milvus Metadata Management (1) How to View MetadataThis post details how to view Milvus metadata by connecting to either SQLite (meta.sqlite file) or MySQL databases. It provides SQL queries for retrieving information from the 'Tables' and 'TableFiles' tables and includes instructions for installing and using the respective command-line clients.