Search Results
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables. Review the following examples for different ways to create external tables. These ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-metadata.html
For example, you create a table that includes the _metadata_filename column: mysql> CREATE EXTERNAL TABLE table_1 ( col_1 int, col_2 int, _metadata_filename varchar(1024) ) FILE_FORMAT = (FORMAT csv) FILES = (URI = ... As of MySQL 9.6.1, MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table manually. Create External Table Manually Example To demonstrate how to create an external table manually, the following example specifies a ...