Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-json-non-json.html
You can create the following types of URIs: OCIFS Syntax: oci://bucket_name@namespace_name/object_path Example: oci://bucket_1@tenant_1/data_files/ PAR URI Syntax. The option to export query results as an ND-JSON file is available as of MySQL 9.3.1. This topic contains the following sections: Before You Begin Syntax Parameter Descriptions Examples What's Next Before You Begin Review the following: Overview of Exporting Query Results Requirements to Export Query Results Syntax Use the following SQL SELECT INTO syntax to export query results to ND-JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-Parquet-non-json.html
You can create the following types of URIs: OCIFS Syntax: oci://bucket_name@namespace_name/object_path Example: oci://bucket_1@tenant_1/data_files/ PAR URI Syntax. This topic shows the different ways to export query results as a Parquet file with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
After exporting query results successfully, the output displays the number of rows written and the folder created to save the export query result. As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-delta.html
Writing, updating, and creating of delta lake tables in MySQL HeatWave Lakehouse is not supported. MySQL HeatWave Lakehouse has the following limitations for delta lake tables. Support for delta lake tables is restricted to delta tables with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-json.html
Tables created with json format must only have a single column that conforms to the JSON data type, see: The JSON Data Type. MySQL HeatWave Lakehouse has the following limitations for JSON files. As of MySQL 9.3.1, Lakehouse can load up to 4192192 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
Tip If you need to manually create a table but do not have the appropriate table definition, you can load the table automatically in dryrun mode and review the load script. MySQL HeatWave Lakehouse has the following limitations for Parquet files.
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-bulk-load.html
The state of the table should be as though it has been freshly created. MySQL HeatWave on OCI does not support LOAD DATA with ALGORITHM=BULK. MySQL HeatWave on AWS does support LOAD DATA with ALGORITHM=BULK, but does not support the INFILE and URL ...
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. Perform the following steps sequentially for each table that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-quickstart-prereqs.html
What's Next Learn more about creating a MySQL HeatWave DB System. You need an operational MySQL HeatWave DB System with the MySQL HeatWave Cluster enabled to do the following: Load and manage data in the MySQL HeatWave Cluster. However, some of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd_vector_indexes-table.html
The rpd_vector_indexes table provides information about vector indexes created for different vector store or embedding tables. SPACE: Vector distance metric, which can be one of: DOT, EUCLIDEAN, and COSINE. Queries using the same distance metric ...