Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
Move the files with supported formats to another folder, create a new PAR and run the VECTOR_STORE_LOAD command with the new PAR to load the vector embeddings into the vector store table again. This section describes some commonly encountered ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
This topic describes how to run a SELECT query and insert the results into a target table using the INSERT ... The target table can be an InnoDB table and does not need to use a secondary engine. When the query is offloaded to MySQL HeatWave, it is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-overview.html
Pre-Authenticated Request (PAR): Create a temporary URL that is the export destination for the query results. This section provides an overview of exporting query results to Object Storage. Methods to Export Query Results You can export query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
These parameters are based on the dialect parameters required to create the external table. This topic shows the different ways to export query results as a CSV file with JSON syntax. end-object dialect_option_key_value: { "format": "csv" | ...
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. Loading delta lake tables is only supported in MySQL HeatWave on OCI.
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. MySQL HeatWave Lakehouse has the following limitations for JSON files. As of MySQL 9.3.1, Lakehouse can load up to 4192192 bytes (~4MB) of data per ...
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.