Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
See MySQL 9.5 Error Message Reference for Lakehouse error messages. As of MySQL 9.2.2, a detailed summary of warnings is available when loading data to Lakehouse. This includes warnings related to the schema inference stage of loading data. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
Rewrite queries that use named time zones with equivalent datetime values. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() JSON_EXTRACT() ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-data-split.html
The following data types for this column are supported: DATETIME TIMESTAMP DATE TIME YEAR semisupervised: If running an anomaly detection task, set this to true for semi-supervised learning, or false for unsupervised learning. As of MySQL 9.4.1, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
Order the table by the datetime_index values and select the first 80% of the samples for the training dataset. TRAIN_TEST_SPLIT Syntax mysql> CALL sys.TRAIN_TEST_SPLIT ('table_name', 'target_column_name', [options | NULL]); options: { ... MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30.html
(Bug #34145862) MySQL HeatWave AutoML You can now train MySQL HeatWave AutoML models on tables containing DATE, TIME, DATETIME, TIMESTAMP, and YEAR data types. (Bug #33899183) Support was added for the FROM_DAYS() temporal function, and GREATEST() ... Advisor MySQL HeatWave AutoML Functionality Added or Changed Advisor MySQL HeatWave Advisor Auto Encoding, which recommends string column encodings, now provides encoding recommendations that optimize query ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-2-0.html
(WL #15628) MySQL HeatWave now supports full-table aggregation and group-by support for the following temporal data types: DATE TIME DATETIME TIMESTAMP YEAR MySQL HeatWave now supports the following functions with temporal data types: SUM() AVG() ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
It specifies that the event executes one time only at the date and time given by timestamp, which must include both the date and time, or must be an expression that resolves to a datetime value. You may use a value of either the DATETIME or ...
https://dev.mysql.com/doc/refman/8.4/en/data-type-defaults.html
See Section 13.2.5, “Automatic Initialization and Updating for TIMESTAMP and DATETIME”. Data type specifications can have explicit or implicit default values. A DEFAULT value clause in a data type specification explicitly indicates a default ...
https://dev.mysql.com/doc/refman/8.4/en/json-attribute-functions.html
The functions in this section return attributes of JSON values. An error occurs if the argument is not a valid JSON document. An empty array, empty object, or scalar value has depth 1. A nonempty array containing only elements of depth 1 or ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...