Search Results
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 ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-creating-lakehouse-data-mapping.html
Click the Copy button to copy the DDL statement for data mapping into your clipboard. Creating Lakehouse Mapping 9.2 Creating Lakehouse Mapping For MySQL HeatWave Lakehouse to process data in Amazon S3, it needs to first map the data in files on S3 ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-iam-role-cloudwatch.html
Creating an IAM Role and Policy for CloudWatch Monitoring 21.5.5 Creating an IAM Role and Policy for CloudWatch Monitoring Use the AWS Management Console to create an IAM role for using CloudWatch to monitor your DB Systems and MySQL HeatWave ...