Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
It also displays the latest query results from the query text from the performance_schema.rpd_query_stats table and retrieves all the MySQL statements currently being executed in all MySQL active connections on the network. The pre-authenticated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
These parameters are based on the dialect parameters required to create the external table. This topic shows the different ways to export query results as a CSV file with JSON syntax. end-object dialect_option_key_value: { "format": "csv" | ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
The following JSON functions: JSON_TABLE() queries that include a LEFT JOIN clause require a primary key column specified for the base or intermediate table. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
MySQL HeatWave cannot load partitions from a table that contains dictionary-encoded columns. Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations.html
If a particular data type, function, operator, or SQL mode does not appear in those tables and lists, it should be considered unsupported. This section lists functionality that is not supported by MySQL HeatWave. It is not an exhaustive list with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-memory-usage.html
To view the memory usage for each MySQL HeatWave node: mysql> SELECT ID, MEMORY_USAGE, MEMORY_TOTAL, BASEREL_MEMORY_USAGE FROM performance_schema.rpd_nodes; +----+--------------+--------------+----------------------+ | ID | MEMORY_USAGE | ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-node-status.html
To view the status of each MySQL HeatWave node: mysql> SELECT ID, STATUS FROM performance_schema.rpd_nodes; +----+---------------+ | ID | STATUS | +----+---------------+ | 0 | AVAIL_RNSTATE | | 1 | AVAIL_RNSTATE | +----+---------------+ For column ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-sql-modes.html
Default DB System SQL modes are supported, which include ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, and NO_ENGINE_SUBSTITUTION. What's Next Learn how to perform the following tasks: Run ...In ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ease-of-use.html
For example, the following call to the ML_PREDICT_TABLE routine generates predictions for a table of input data: CALL sys.ML_PREDICT_TABLE('heatwaveml_bench.census_test', @census_model, 'heatwaveml_bench.census_predictions', NULL); All MySQL ...With ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explainers.html
mysql> CALL sys.ML_EXPLAIN ('table_name', 'target_column_name', model_handle, [options]); The following example generates a model explanation on the trained and loaded model with the shap model explainer. mysql> CALL ... After the ML_TRAIN routine, ...