Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-table.html
model_handle: Specifies the model handle or a session variable containing the model handle. The ML_EXPLAIN_TABLE call specifies the fully qualified name of the table to generate explanations for, the session variable containing the model handle, and ... ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-load.html
model_handle: Specifies the model handle or a session variable containing the model handle. mysql> CALL sys.ML_MODEL_LOAD('ml_data.iris_train_user1_1636729526', NULL); An example that specifies a session variable containing the model handle. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-onnx-import-overview.html
None or string indicate a variable batch size, and an integer indicates a fixed batch size. You cannot directly load models in ONNX format (.onnx) into a MySQL table. The models require string serialization and conversion to Base64 encoding before ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-explanations.html
You can use the session variable for the model that is valid for the duration of the connection. After training a regression model, you can query the default model explanation or query new model explanations. Explanations help you understand which ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression.html
Machine learning regression models generate predictions based on the relationship between a dependent variable and one or more independent variables. Some examples of regression analysis include predicting sales during different seasons, predicting ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-row.html
The ML_EMBED_ROW routine uses the specified embedding model to encode the specified text or query into a vector embedding. The routine returns a VECTOR that contains a numerical representation of the specified text. This topic contains the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-retrieve-schema-metadata.html
Retrieves the most relevant tables to a given natural-language statement and ranks them in the order of their relevance. The output generated by the routine can be used to enhance large language model (LLM) prompts, NL_SQL workflows, and ...
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-9-4-0.html
The primary and secondary engines for MySQL HeatWave Lakehouse tables are now determined by session variables, eliminating the need to specify engines explicitly. This enhancement also lets you specify the primary engine for MySQL HeatWave temporary ... Note MySQL HeatWave User Guide has been restructured and improved to provide better visibility of high-level ...
https://dev.mysql.com/doc/refman/9.7/en/correlated-subqueries.html
The optimizer can transform a correlated scalar subquery to a derived table when the subquery_to_derived flag of the optimizer_switch variable is enabled. The subquery may contain LIMIT 1 but no other LIMIT clause; it must use a literal 1, and no ...