Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-column-limits.html
MySQL HeatWave has the following column limits: As of MySQL 9.2.2, the maximum column width is 4192192 bytes. In previous versions of MySQL, the maximum column width is 65532 bytes. Any table with multiple columns wherein the aggregate data size is ...This includes the size of all the data and column metadata stored in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. It contains the following sections: Before You Begin Generate and Run an SQL Query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-overview.html
AWS S3 URL: For MySQL HeatWave on AWS, you must use AWS S3 URLs. See Manage AWS Access from the MySQL HeatWave on AWS Service Guide to learn more. Supported File Formats You can export the query results in the following file formats: CSV (As of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
MySQL HeatWave Lakehouse has the following limitations for Parquet files. As of MySQL 9.1.2, you can load Parquet files with row groups that total up to 10GB with large MySQL HeatWave Cluster shapes. As of MySQL 9.3.2, limited support is available ...Consider the following limitations: To load Parquet files with the VECTOR data type (from Parquet strings or from Parquet (numeric) Lists), you must load the table manually with is_strict_mode set to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
As of MySQL 9.2.1, if the region is not specified, the instance's associated region is used as the default region. mysql> CREATE EXTERNAL TABLE table_1(col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "csv"}, "file": ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the following limitations: MySQL HeatWave cannot load partitions with Auto Parallel Load. MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table is offloaded and loaded into the MySQL HeatWave Cluster Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ... To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load-partitions.html
As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. Loading Partitions using Secxondary _Load Clause To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated processing. Verify if the query is offloaded to MySQL HeatWave for processing. To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain.html
MySQL 9.0.0 introduces support for large models that changes how MySQL HeatWave AutoML stores models. For example: mysql> CALL sys.ML_MODEL_LOAD('ml_data.iris_train_user1_1636729526', NULL); See Load a Model and Work with Model Handles to learn more. mysql> CALL sys.ML_EXPLAIN('bank_marketing_test.bank_train', 'y', @bank_test, NULL); The following example trains the Fast SHAP model explainer and SHAP prediction ...