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/heatwave/en/mys-hw-async-exec.html
As of MySQL 9.3.1, you can run SQL statements as asynchronous tasks that run in the background. This lets your current session to continue without waiting for these SQL statements or tasks to complete. It is particularly helpful for long-running ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
To track the progress of the task, run the task query displayed on the screen: SELECT mysql_tasks.task_status_brief("TaskID"); Replace TaskID with the displayed task ID. This quickstart shows how to set up a GenAI-powered Help Chat that uses the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
Workaround: Ensure that you use the --sqlc flag when you connect to your database system: mysqlsh -uAdmin -pPassword -hPrivateIP --sqlc Replace the following: Admin: the admin name. This section describes some commonly encountered issues and errors ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
Deprecated synonym for JSON_MERGE_PRESERVE() JSON_MERGE_PATCH() Merge JSON documents, replacing values of duplicate keys JSON_MERGE_PRESERVE() Merge JSON documents, preserving duplicate keys JSON_OBJECT() Create JSON object literal JSON_OVERLAPS() ...Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
mysql> SET @input_list = '[{ "db_name": "lakehouse_db", "tables": [{ "table_name": "table_1", "engine_attribute": { "dialect": {"format": "csv"}, "file": [{"par": "https://objectstorage.us-ashburn-1.oraclecloud.com/p/.../n/tenancy_1/b/bucket_1/o/", ... Review the following examples to see the different ways to use pre-authenticated requests (PAR) and Auto Parallel Load to specify files when creating external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-rp.html
mysql> SET @input_list = '[{ "db_name": "lakehouse_db", "tables": [{ "table_name": "table_1", "engine_attribute": { "dialect": {"format": "csv"}, "file": [{ "region": "us-ashburn-1", "namespace": "tenant_1", "bucket": "bucket_1", "pattern": ...
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-resource-principal.html
mysql> CREATE EXTERNAL TABLE table_1(col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "csv"}, "file": [{"region": "regionName", "namespace": "tenant_1", "bucket": "bucket_1", "pattern": ... Review the following examples to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-models-delete.html
Users that create models or have the required privileges to a model on the MODEL_CATALOG table can delete them. Before You Begin Review how to Create a Machine Learning Model. Delete a Model To delete a model from the model catalog table: Query the ...