Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-parquet-json.html
This topic shows the different ways to export query results to Parquet files. end-object dialect_option_key_value: { "format": "parquet" | "compression": {"uncompressed"|"snappy"|"gzip"|"brotli"|"zstd"|"lz4"} } Parameter Descriptions for URI ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-Parquet-non-json.html
This topic shows the different ways to export query results as a Parquet file with SQL syntax. Before You Begin Review the following: Overview of Exporting Query Results Requirements to Export Query Results Syntax Use the following SQL SELECT INTO ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-data-types.html
The following string and text data types are unsupported: BINARY VARBINARY Decimal values with a precision greater than 18 in expression operators are unsupported, with the exception of the following: Arithmetic operators, see: Section 5.3.2, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
This topic describes how to create materialized views on MySQL HeatWave, which is supported as of MySQL 9.5.0. A materialized view is a database object that stores the results of a query, rather than computing the result dynamically each time the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-offload.html
The sys.processlist and sys.x$processlist views in the MySQL sys Schema also include an execution_engine column.
https://dev.mysql.com/doc/heatwave/en/mys-hw-pre-authenticated-requests.html
Pre-authenticated requests (PAR) allow you to access a bucket or an object in Oracle Cloud Infrastructure (OCI) Object Storage without having your own credentials. A pre-authenticated request is a unique URL, and anyone who has this URL can access ...
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-columns-table.html
The rpd_columns table provides column encoding information for columns of tables loaded in MySQL HeatWave. The rpd_columns table has these columns: TABLE_ID A unique identifier for the table. DATA_PLACEMENT_INDEX The data placement key index ID ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-running-queries.html
When MySQL HeatWave is enabled and the data you want to query is loaded, queries that qualify are automatically offloaded from the DB System to MySQL HeatWave for accelerated processing. Simply run the query from a client, application, or interface ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load-partitions.html
As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. Loading Partitions using Secondary _Load Clause To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION ...