Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Then, the MySQL HeatWave query processing engine (RAPID) is set as the secondary engine for the table, using ALTER TABLE statement. Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables manually. Create the external tables that will ingest the loaded data by either using SQL syntax or JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
MySQL HeatWave can unload up to 1,000 partitions in a single statement. Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the following limitations: ...
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. MySQL version 8.2.0 or higher has a guided load feature which ...Perform the following steps sequentially for each table that you want to load: Exclude table columns with unsupported data types or columns not used in queries Define a secondary engine on the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
You cannot set the embedding model with SQL syntax for the CREATE TABLE statement. Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different sources. Parquet Delta lake ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-tpch-quickstart.html
The utility is capable of completing a large data import many times faster than a standard single-threaded upload using a LOAD DATA statement. The tpch Analytics Quickstart shows how to import data into the DB System using the MySQL Shell Parallel ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-unload-tables.html
To unload a table manually, specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement: mysql> ALTER TABLE tbl_name SECONDARY_UNLOAD; The following example unloads the data_table_1 table. To unload partitions, specify the SECONDARY_UNLOAD ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-generate.html
To generate a random new statement for a particular prompt every time you run it, increase the temperature. The ML_GENERATE routine uses the specified large language model (LLM) to generate text-based content as a response for the given ...