Search Results
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
This topic describes how to encode string columns to improve the performance of queries that access them. This topic contains the following sections: Before You Begin Supported Encoding Types Select the Encoding Type Define String Column Encoding ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
MySQL HeatWave Lakehouse has the following limitations for all file formats. Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
Columns with unsupported data types must be excluded, and defined as NOT SECONDARY before loading a table. Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-varlen-encoding.html
Variable-length encoding is automatically applied when tables are loaded into MySQL HeatWave with the exception of string columns defined explicitly as dictionary-encoded columns. You can define the encoding type while creating the table or later ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-supported-data-types.html
MySQL HeatWave AutoML has the following limitations for text usage: The ML_PREDICT_TABLE ml_results column contains the prediction results and the data. MySQL HeatWave AutoML does not support text columns with NULL values. MySQL HeatWave AutoML does ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now monitored and recorded in the Performance Schema tables rpd_query_stats and rpd_exec_stats. Where a single MySQL HeatWave AutoML query ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-bulk-ingesting.html
Importing Data Using the Bulk Ingest Feature 7.2.2.2 Importing Data Using the Bulk Ingest Feature Connect to a DB System and bulk ingest data from an Amazon S3 bucket to a DB System in the same region. This task requires the following: A client ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
Importing Data Using the Data Import Feature 7.2.1.2 Importing Data Using the Data Import Feature Use the data import feature in the MySQL HeatWave Console to import data from an Amazon S3 bucket to a DB System in the same region. This task ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-result-sets.html
clobberStreamingResults This will cause a streaming result set to be automatically closed, and any outstanding data still streaming from the server to be discarded if another query is executed before all the data has been read from the server.