Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load then automatically loads these tables into MySQL HeatWave. Therefore, within 24 hours of the first query that accesses a table, Auto Parallel Load automatically loads the table into MySQL HeatWave if there is sufficient memory.
https://dev.mysql.com/doc/heatwave/en/mys-hw-change-propagation.html
After tables are loaded into MySQL HeatWave, data changes are automatically propagated from DB System tables to their counterpart tables in the MySQL HeatWave Cluster. See Section 4.4.2, “Unload Data Manually”, and Section 4.2, “Load Data ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-exclude-table-columns.html
Before loading a table into MySQL HeatWave, exclude the columns with unsupported data types. Excluding Table Columns The NOT SECONDARY column attribute prevents a column from being loaded into MySQL HeatWave when executing a table load operation.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
When you run MySQL HeatWave Chat, it automatically loads the default LLM. By default, MySQL HeatWave Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
It can scale horizontally by adding more servers to the cluster, or ', 'vertically by upgrading the hardware.' ) ); mysql>INSERT INTO input_table (Input) VALUES( CONCAT( 'Artificial Intelligence or AI refers to the simulation of human intelligence ... The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
If you find unsupported format files, then try one of the following: Delete the files with unsupported formats from the folder, and run the VECTOR_STORE_LOAD command again to load the vector embeddings into the vector store table again. Move the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON array JSON_CONTAINS() Whether JSON document contains specific object at path. JSON_DEPTH() Maximum depth of JSON document ...Table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-par.html
To specify multiple external files for one external table, you can create a folder in the Object Storage bucket and upload the required files into that folder. What's Next After successfully creating external tables and specifying the files to load ... 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-create-table-auto-parallel-load-task.html
Create a session variable with the characteristics of the input_list to create the external table and specify the file to use to load data into the table. Run the HEATWAVE_LOAD command with the characteristics of the input_list in normal mode to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
The pre-authenticated request (PAR) URL is hidden in the log file for security reasons. The following example exports the query results as a CSV file to the object storge location represented as a PAR URL. It also displays the latest query results ...