Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
After exporting query results successfully, the output displays the number of rows written and the folder created to save the export query result. As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-json.html
Tables created with json format must only have a single column that conforms to the JSON data type, see: The JSON Data Type. MySQL HeatWave Lakehouse has the following limitations for JSON files. As of MySQL 9.3.1, Lakehouse can load up to 4192192 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
Tip If you need to manually create a table but do not have the appropriate table definition, you can load the table automatically in dryrun mode and review the load script. MySQL HeatWave Lakehouse has the following limitations for Parquet files.
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-bulk-load.html
The state of the table should be as though it has been freshly created. MySQL HeatWave on OCI does not support LOAD DATA with ALGORITHM=BULK. MySQL HeatWave on AWS does support LOAD DATA with ALGORITHM=BULK, but does not support the INFILE and URL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY clauses in the following cases: In queries that contain distinct aggregations. Cursors inside stored programs are not supported ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
You can manually load data from InnoDB tables in your DB System into MySQL HeatWave Cluster by using SQL data definition language (DDL) such as CREATE TABLE and ALTER TABLE statements. Perform the following steps sequentially for each table that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-pre-authenticated-requests.html
Before You Begin Review the following: Additional MySQL HeatWave Lakehouse Requirements MySQL HeatWave Lakehouse Privileges Supported File Formats PAR Privileges To create pre-authenticated requests to access Object Storage resources, you require ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-quickstart-prereqs.html
What's Next Learn more about creating a MySQL HeatWave DB System. You need an operational MySQL HeatWave DB System with the MySQL HeatWave Cluster enabled to do the following: Load and manage data in the MySQL HeatWave Cluster. However, some of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-table-id-table.html
MATERIALIZATION_QUERY Available as of MySQL 9.3.0, contains the query used to create the MySQL HeatWave temporary table. The rpd_table_id table provides the ID, name, and schema of the tables loaded in MySQL HeatWave. The rpd_table_id table has ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. To learn how to download the sample database, see AirportDB Analytics Quickstart.