Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-all.html
MySQL HeatWave Lakehouse has the following limitations for all file formats. Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
Columns with unsupported data types must be excluded, and defined as NOT SECONDARY before loading a table. Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
It steps through preparing data, using the ML_TRAIN routine to train a model, and using ML_PREDICT_* and ML_EXPLAIN_* routines to generate predictions and explanations. The tutorial also demonstrates how to assess the quality of a model using the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-supported-data-types.html
MySQL HeatWave AutoML has the following limitations for text usage: The ML_PREDICT_TABLE ml_results column contains the prediction results and the data. MySQL HeatWave AutoML does not support text columns with NULL values. MySQL HeatWave AutoML does ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
The ML_EMBED_TABLE routine runs multiple embedding generations in a batch, in parallel. Note In versions older than MySQL 9.2.1, to alter an existing table or create a new table, MySQL requires you to set the sql-require-primary-key system variable ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-rag-table.html
The ML_RAG_TABLE routine runs multiple retrieval-augmented generation (RAG) queries in a batch, in parallel. The output generated for every input query is the same as the output generated by the ML_RAG routine. Note In versions older than MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-25.html
For example, the following query can now be offloaded to MySQL HeatWave for execution: SELECT DISTINCT a FROM t1 ORDER BY c DESC; (Bug #32583856) Query plan statistics are now collected and stored in a statistics cache when a query is executed in ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
When you use the ML_EXPLAIN_TABLE and ML_EXPLAIN_ROW stored procedures to generate explanations for a prediction, you can now use the SHAP prediction explainer as an alternative to the default Permutation Importance prediction explainer. MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-metadata.html
getProceduresReturnsFunctions Pre-JDBC4 'DatabaseMetaData' API has only the 'getProcedures()' and 'getProcedureColumns()' methods, so they return metadata info for both stored procedures and functions. JDBC4 was extended with the 'getFunctions()' ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-statements-callable.html
For more information on MySQL stored procedures, please refer to Using Stored Routines. Notice that you have to use JDBC escape syntax, and that the parentheses surrounding the parameter placeholders are not optional: Example 7.4 Connector/J: Using ...