Search Results
https://dev.mysql.com/doc/heatwave/en/import-data.html
This topic describes how to import data into the DB System. Import Data Use MySQL Shell Shell for importing data into a DB System. Its dump and load utilities are specifically built for this task and support all types of data exports and imports.
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The execute_prepared_stmt_from_app_async routine creates an asynchronous task associated with a specific application user. Application-level asynchronous task lets you filter and track tasks for individual application users using an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the background. This lets your current session to continue without waiting for these SQL statements or tasks to complete. It is particularly helpful for long-running ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
You can use MySQL HeatWave Auto Unload to unload data automatically. This topic contains the following sections: Before You Begin Overview for Unloading Data Automatically Unload Specific Tables Unload All Data Auto Unload Examples What's Next ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. To learn how to download the sample database, see AirportDB Analytics Quickstart. Setting Secondary Engine Definition By default, SELECT queries are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL HeatWave query processing engine (RAPID) as the secondary engine for the table. Then, the MySQL HeatWave query processing engine ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
This topic describes how to encode string columns to improve the performance of queries that access them. This topic contains the following sections: Before You Begin Supported Encoding Types Select the Encoding Type Define String Column Encoding ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT SECONDARY attribute. These columns are typically not needed for analytic queries and are therefore ...
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-metadata-queries-secondary-engine.html
To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES table. If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table ...