Search Results
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, ...
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 ...