Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/method-chaining.html
X DevAPI supports a number of modern practices to make working with CRUD operations easier and to fit naturally into modern development environments. This section explains how to use method chaining instead of working with SQL strings of JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
mysql> SELECT log->>"$.sql" AS "SQL Script" FROM sys.heatwave_autopilot_report WHERE type = "sql" ORDER BY id; To concatenate generated DDL statements into a single string that can be copied and pasted for execution, issue the statements that follow. Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
Syntax Example mysql> CALL mysql_tasks.execute_prepared_stmt_async('DO SLEEP(5); SELECT JSON_OBJECT("Async Task completed at", now()) into @task_result', NULL, 'DemoAsyncTask', NULL, @task_id); In this example, the first SQL statement DO SLEEP(5) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-column-limits.html
The maximum column limit for base relations, tables as loaded into MySQL HeatWave, is 1017. MySQL HeatWave has the following column limits: As of MySQL 9.2.2, the maximum column width is 4192192 bytes. In previous versions of MySQL, the maximum ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
Benefits MySQL HeatWave GenAI lets you integrate generative AI into the applications, providing an integrated end-to-end pipeline including vector store generation, vector search with RAG, and an inbuilt chatbot. MySQL HeatWave GenAI is a feature ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
This creates an asynchronous task in the background which loads the vector embeddings into the specified vector store table quickstart_embeddings. This quickstart shows how to set up a GenAI-powered Help Chat that uses the information available in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-requirements.html
If you want to use the uniform resource identifier for accessing files in the Object Storage bucket that you want to ingest into the vector store, you need to enable the DB System to access the Oracle Cloud Infrastructure (OCI) Object Storage bucket. To use MySQL HeatWave GenAI, you need the following: A MySQL HeatWave DB system that meets the following requirements: The MySQL HeatWave DB system must be version 9.0.0 - Innovation or ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-load.html
Syntax Examples for external_tables Option While it is possible to define the entire load command on a single line, for readability the configuration is divided into option definitions using SET. Note Do not use the external_tables option as of ...