Search Results
https://dev.mysql.com/doc/x-devapi-userguide/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
See MySQL 9.4 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
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() GROUP_CONCAT() SPACE() when the input is a floating point. Rewrite queries that use ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-data-split.html
As of MySQL 9.4.1, you can automatically create training and testing datasets with the TRAIN_TEST_SPLIT routine. Overview The TRAIN_TEST_SPLIT routine takes your datasets and prepares new tables for training and testing machine learning models. Two ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT routine, which automatically splits your data into training and testing datasets. Two new tables in the same database are created with the following names: [original_table_name]_train ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-30.html
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 performance. Recommendations are based on ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-2-0.html
Functionality Added or Changed MySQL HeatWave Guided Load reduces the number of steps to manually load data, see Load Data Manually. (WL #15811) MySQL HeatWave now supports the following string functions: BIN() BIT_LENGTH() ELT() EXPORT_SET() ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The ...