Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-modify.html
A JSON document (for example, set("Greeting", mysqlx.expr("{'season':'winter', 'phrase': 'Happy Holiday'}")) Note set("$", mysqlx.expr("json_document") replaces all documents matched by modify() with the supplied json_document, except for the ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/crud-operations-overview.html
Operation Document Relational Create Section 4.3.1, “Collection.add()” Table.insert() Read Section 4.3.2, “Collection.find()” Table.select() Update Section 4.3.3, “Collection.modify()” Table.update() Delete Section 4.3.4, ... CRUD ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-list.html
Task type for tasks created using the execute_prepared_stmt_async procedure is Async_SQL. The task_list routine returns a paginated list of asynchronous tasks. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-list.html
Task type for tasks created using the execute_prepared_stmt_async procedure is Async_SQL. The task_status_list routine returns a paginated list of task statuses. This topic contains the following sections: Syntax Syntax Example See Also Syntax ...
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. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ...
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 ...