Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
MySQL HeatWave Lakehouse has the following limitations for Parquet files. 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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-data-types.html
The following string and text data types are unsupported: BINARY VARBINARY Decimal values with a precision greater than 18 in expression operators are unsupported, with the exception of the following: Arithmetic operators, see: Section 5.3.2, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY clauses in the following cases: In queries that contain distinct aggregations. Cursors inside stored programs are not supported ...
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-temporal-functions.html
As of MySQL 8.4.0, MySQL HeatWave supports named time zones such as MET or Europe/Amsterdam for CONVERT_TZ(). For a workaround before MySQL 8.4.0, see Section 11.2.1.4, “Functions and Operator Limitations”. Table 5.11 Temporal Functions Name ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-onnx-metadata.html
To learn more about model metadata in the model catalog, see Model Metadata. ONNX Inputs Info Use the data_types_map to map the data type of each column to an ONNX model data type. For example, to convert inputs of the type tensor(float) to ...
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-26-u2.html
Functionality Added or Changed The following function support was added: YEARWEEK(date), YEARWEEK(date,mode) The mode argument for the two-argument form of the WEEK() function: WEEK(date[,mode]) MAKEDATE() “Zero” handling for dates such as ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
Advisor Auto Parallel Load Auto Scheduling Functionality Added or Changed Advisor The new MySQL HeatWave Advisor provides string column encoding and data placement key recommendations based on machine learning models, data analysis, and MySQL ...