Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-access-object-storage.html
To allow MySQL HeatWave Lakehouse to process data in Amazon S3, see Creating Lakehouse Mapping. MySQL HeatWave on OCI can access external data stored on Oracle Cloud Infrastructure in Object Storage.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-load.html
mysql> SET @db_list = '["tpch"]'; This assumes that Lakehouse Auto Parallel Load will analyze the data, infer the table structure, and create the database and all tables. Note Do not use the external_tables option as of MySQL 8.4.0. The Auto ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax.html
To set options when creating external tables, you have the following options: As of MySQL 9.4.0, you can use SQL syntax to set table-level and column-level options for external tables. You can use table-level and column-level ENGINE_ATTRIBUTE ...
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 ...