Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-validation.html
Creating a Validated Collection To enable JSON schema validation when you create a new collection, supply a validation JSON object as described above. Collections can be configured to verify documents against a JSON schema. This enables you to ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-validation.html
Creating a Validated Collection To enable JSON schema validation when you create a new collection, supply a validation JSON object as described above. Collections can be configured to verify documents against a JSON schema. This enables you to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
Auto Parallel Load uses the inferred schema to generate CREATE TABLE statements. MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.14.2, “Refresh Data Using Incremental Load”.
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL HeatWave query processing engine (RAPID) as the secondary engine for the table. Then, the MySQL HeatWave query processing engine ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
For example: mysql> SELECT COLUMN_NAME, COLUMN_COMMENT FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME LIKE 'airline_info' AND COLUMN_COMMENT LIKE '%ENCODING%'; +-------------+------------------------------+ | COLUMN_NAME | COLUMN_COMMENT | ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-update-vector-store.html
The following sections in this topic describe how to update a vector store: Before You Begin Load Data Incrementally into the Vector Store Table Delete and Recreate the Vector Store What's Next Before You Begin Complete the steps to set up a vector ... To keep up with the changes and updates in the documents in your Object Storage, you must update the vector embeddings loaded in the vector store table on a regular ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-index-creation.html
As of MySQL 9.5.0, MySQL HeatWave GenAI automatically creates vector indexes for frequenctly queried VECTOR columns in vector store and embedding tables using advanced index structures such as Hierarchical Navigable Small World (HNSW). Information ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
Then, it segments the parsed data, creates vector embeddings, and stores them for MySQL HeatWave GenAI to perform semantic searches. About Vector Processing To create vector embeddings, MySQL HeatWave GenAI uses in-database embedding models, which ... This section describes the Vector Store functionality available in MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-group-by-modifiers.html
Consider the following example: mysql> SELECT MAX(id) FROM t1 GROUP BY GROUPING SETS (()); The () represents an empty grouping set, which means the query creates a full-table aggregate. In the MySQL HeatWave secondary engine, the GROUP BY clause ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-prereqs.html
See Creating a DB System in the MySQL HeatWave on OCI Service Guide. See Creating a MySQL HeatWave Cluster in the MySQL HeatWave on AWS Service Guide. Manage AWS Access and Creating Lakehouse Mapping from the MySQL HeatWave on AWS Service Guide.