Milvus

Samples Overview

Qarbine provides a wide variety of sample templates, and queries. Some are application oriented examples, while others are database administrator (DBA) oriented.

Below are a few of the component samples to consider. Review the Qarbine Catalog for the latest components. See the latest set of components for Pinecone in the folder depicted below.

  

  

List Collections

This template is at “example/Milvus/DBA/Collections”. It provides the basic collection name information within the associated Milvus environment. Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

list tables

Describe Collections

This template is at “example/Milvus/DBA/Describe collections”. It provides the detailed collection information within the associated Milvus environment. Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

describe tables

List a Collection’s Partitions

This template is at “example/Milvus/DBA/Collection @collection partitions”. It provides the basic partition name information for a selected collection within the associated Milvus environment. A prompt appears when running the template.

  

Below is a sample snippet from the results.

  

The associated data source uses the following Qarbine virtual query

list partitions COLLECTION

The prompt’s selection is used as the COLLECTION value above.

Describe a Collection’s Partitions

This template is at “example/Milvus/DBA/Collection @collection partitions with details”. It provides the partition information on a chosen collection within the associated Milvus environment. A prompt appears when running the template.

  

Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

describe partitions COLLECTION PARTITION

The prompt’s selection is used as the COLLECTION value above.

List a Collection’s Indexes

This template is at “example/Milvus/DBA/Collection @collection indexes”. It provides the index names of the chosen collection within the associated Milvus environment. A prompt appears when running the template.

  

Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

list indexes COLLECTION

The prompt’s selection is used as the COLLECTION value above.

Describe a Collections’s Indexes

This template is at “example/Milvus/DBA/Collection @collection indexes with details”. It provides the index details of the chosen collection within the associated Milvus environment. A prompt appears when running the template.

  

Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

describe indexes COLLECTION

Describe a Collection’s Statistics

This template is at “ReportTemplate`q_catalog|qf_example/Milvus/DBA/Collection @collection statistics”. It provides the statistical information for the chosen collection within the associated Milvus environment. A prompt appears when running the template.

  

Below is a sample snippet from running the template.

  

The associated data source uses the following Qarbine virtual query

describe statistics COLLECTION

The prompt’s selection is used as the COLLECTION value above.

List Aliases

This data source is at “example/Milvus/DBA/Aliases”. It provides the list of all aliases within the associated Milvus environment. The associated data source uses the following Qarbine virtual query

list aliases

List a Collections’s Aliases

This data source is at “example/Milvus/DBA/Collection @collection aliases”. It provides the list of all aliases for a chosen collection within the associated Milvus environment. A prompt appears when running the data source.

  

The associated data source uses the following Qarbine virtual query

list aliases COLLECTION

The prompt’s selection is used as the COLLECTION value above.

Describe an Alias

This template is at “example/Milvus/DBA/Describe @alias”. It provides detailed alias information within the associated Milvus environment. The associated data source uses the following Qarbine virtual query

describe alias ALIAS

General Schema

This general purpose template is at “Qarbine_admin/Cached schemas for prompted data service”. It displays information on all of the cached schemas. These schemas are saved as users interact with the data tools such as the Data Source Designer, Query by Example, and Report by Example. If a particular collection is not shown in the output, simply open up one of these tools and select it from the collection drop down to create it. Then rerun the template.

Running the template prompts for a data service.

  

Below is a sample snippet from running the template.