Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
View Details To view the chat session details, inspect the @chat_options variable: mysql> SELECT JSON_PRETTY(@chat_options); The output includes the following details about a chat session: Vector store tables: in the database which were referenced ... This topic describes how to view a chat session ...
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 ...Control Automatic Vector Index Creation and Usage To disable automatic index creation, use the rapid_auto_vector_index_enabled ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse tables to Object Storage. This feature is available for MySQL HeatWave on OCI and MySQL HeatWave on AWS. The capability to convert the output into ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-json.html
Tables created with json format must only have a single column that conforms to the JSON data type. In addition, stored generated columns or the _metadatq_filename column can be part of the table schema. MySQL HeatWave Lakehouse has the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-joins.html
The plan evaluation count is reset to zero after each derived table, after an outer query, and after each subquery. Outer join queries without an equality condition defined for the two tables. Antijoins, with the exception of supported IN and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-pre-authenticated-requests.html
What's Next Learn how to do the following: Create External Tables Using Auto Parallel Load. Pre-authenticated requests (PAR) allow you to access a bucket or an object in Oracle Cloud Infrastructure (OCI) Object Storage without having your own ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-uniform-resource-identifiers.html
What's Next Learn how to do the following: Create External Tables Using Auto Parallel Load. As of MySQL 9.3.1 (supported in MySQL HeatWave on OCI only), MySQL HeatWave Lakehouse lets you use Uniform Resource Identifiers (URI) in a unified way to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Unload Advisor Recommends tables to unload, reducing MySQL HeatWave memory usage. The recommendations are based upon when the tables were last queried. Workload optimization for online analytical processing, OLAP, includes using dictionary encoding ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl-workflow.html
The data can originate from either DB System tables or external Lakehouse tables. A typical MySQL HeatWave AutoML workflow is described below: When you run the ML_TRAIN routine, MySQL HeatWave AutoML retrieves the data to use for training. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-train.html
Train Model Train the model with the ML_TRAIN routine and use the training_data table previously created. mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', JSON_OBJECT('task', 'task_name'), model_handle); Replace table_name, ... After ...