Search Results
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1057; Symbol: HW_ER_UNEXPECTED_NULL_JOIN Message: Root-level UNION ALL - unexpected NULL JOIN under STREAM Access Path. Workaround: Equality or NULL-safe equality should be present in the JOIN predicate. Error number: 1113; Symbol: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave Autopilot Advisor Auto Query Time Estimation feature, or by querying the performance_schema.rpd_query_stats table. Runtime data is ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
mysql> CREATE TABLE `iris_train` ( `sepal length` float DEFAULT NULL, `sepal width` float DEFAULT NULL, `petal length` float DEFAULT NULL, `petal width` float DEFAULT NULL, `class` varchar(16) DEFAULT NULL); Insert the training data into the table.
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-an-anomaly-detection-model.html
For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('anomaly_detection_semi_supervised_use_case', NULL); Score the model ... After generating predictions, you can score the model to assess its ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-train-test-split.html
TRAIN_TEST_SPLIT Syntax mysql> CALL sys.TRAIN_TEST_SPLIT ('table_name', 'target_column_name', [options | NULL]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['task', ... MySQL 9.4.1 introduces the TRAIN_TEST_SPLIT ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-troubleshooting.html
} } if (stmt != null) { try { stmt.close(); } catch (SQLException sqlEx) { // You'd probably want to log this as well... This section explains the symptoms and resolutions for the most commonly encountered issues with applications using MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-reading.html
A successful call to audit_log_read() to read events returns a JSON string containing an array of audit events: If the final value of the returned array is not a JSON null value, there are more events following those just read and audit_log_read() ... The audit log plugin supports functions that provide an SQL interface for reading JSON-format audit log ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-ndb-comment-options.html
NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB table. Table-level options for controlling read from any replica and partition balance can be ...
https://dev.mysql.com/doc/refman/8.4/en/getting-information.html
To find out which database is currently selected, use the DATABASE() function: mysql> SELECT DATABASE(); +------------+ | DATABASE() | +------------+ | menagerie | +------------+ If you have not yet selected any database, the result is NULL. What ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-events-table.html
If the event's timing is determined by an EVERY clause instead of an AT clause (that is, if the event is recurring), the value of this column is NULL. This is displayed as a DATETIME value, and is NULL if no start date and time are defined for the ... The EVENTS table provides information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...