Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
mysql> CREATE TABLE airline_discount( id INT PRIMARY KEY, date DATE COMMENT 'RAPID_COLUMN=DATA_PLACEMENT_KEY=1', discount FLOAT COMMENT 'RAPID_COLUMN=DATA_PLACEMENT_KEY=2'); Query OK, 0 rows affected (0.2448 sec) When defining multiple columns as ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. SELECT statements are supported, but only the SELECT portion is offloaded to MySQL HeatWave. Define all tables accessed by the query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-table-id-table.html
The column contains the query used to create the MySQL HeatWave temporary table. As of MySQL 9.5.0, the column contains the query used to create the materialized view or the MySQL HeatWave temporary table. The rpd_table_id table provides the ID, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-temporal-functions.html
As of MySQL 8.4.0, MySQL HeatWave supports named time zones such as MET or Europe/Amsterdam for CONVERT_TZ(). For a workaround before MySQL 8.4.0, see Section 11.2.1.4, “Functions and Operator Limitations”. Table 5.11 Temporal Functions Name ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-uniform-resource-identifiers.html
What's Next Learn how to do the following: Create External Tables Using Auto Parallel Load. As of MySQL 9.3.1, (supported in MySQL HeatWave on OCI only) MySQL HeatWave Lakehouse lets you use Uniform Resource Identifiers (URI) in a unified way to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
In the following example, a view is created on the airport table, described in AirportDB Analytics Quickstart. mysql> CREATE VIEW airport_US AS SELECT airport.* FROM airport JOIN airport_geo ON airport.airport_id = airport_geo.airport_id WHERE ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl.html
What's Next Learn more about the following: MySQL HeatWave AutoML Learning Types MySQL HeatWave Ease of Use MySQL HeatWave AutoML Workflow Learn how to Create a Machine Learning Model. Review Machine Learning Use Cases to create machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ease-of-use.html
You can use a model created by ML_TRAIN with other MySQL HeatWave AutoML routines to generate predictions and explanations. What's Next Learn more about the following: MySQL HeatWave AutoML Learning Types MySQL HeatWave AutoML Workflow Oracle AutoML ...With MySQL HeatWave AutoML and a set of training data in a MySQL HeatWave DB system, you can train a predictive machine learning model with a single call to the ML_TRAIN SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-row.html
mysql> SET @variable = (JSON_OBJECT("column_name", value, "column_name", value, ...), model_handle, options); In the following example, create the @row_input session variable and enter the data to predict into the session variable. Generate ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
The input table does not have the columns that are created for the output table when generating predictions. When the output table is created, you can query a sample of the table to review predictions. ML_PREDICT_TABLE generates predictions for an ...