Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
The execute_prepared_stmt_async routine creates a task that executes SQL statements asynchronously within an event stored in the schema_name schema. @task_id (VARCHAR(36)): output parameter that returns the unique identifier (UUID) of the created ...schema_name (VARCHAR(255)): specifies the schema to run the given SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-connect-to-db-sys.html
Connect to the DB System After you have created and configured your DB System, connect to the DB System. This topic provides links to relevant documents that describe how to connect to a MySQL HeatWave DB System. For MySQL HeatWave on Oracle Cloud ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-authenticate-service.html
Note If the dynamic group belongs to the default identity domain, you can omit specifying the identity domain name. GroupName: the dynamic group name CompartmentID: the compartment ID of the DB system For more information, see Resource Principals.
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON array JSON_CONTAINS() Whether JSON document contains specific object at path. Deprecated synonym for JSON_MERGE_PRESERVE() ...Table ...
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. Refer to the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-permissions.html
Pre-Authenticated Request Requirements When you create pre-authenticated requests (PAR) to export query results, do the following: For Pre-Authenticated Request Target, select Bucket or Objects with prefix. What's Next Depending on the type of file ...Required Privileges to Export Query Results Review MySQL HeatWave Lakehouse Privileges to confirm you have the required privileges to use MySQL HeatWave ...
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: You can use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in ...
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 ...