Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
This section describes how to generate vector embeddings for files or folders stored in Object Storage, and load the embeddings into a vector store table. If not already done, create an Oracle Cloud Infrastructure (OCI) bucket for storing files ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
As of MySQL 9.4.0, you can use the CREATE EXTERNAL TABLE statement. For example: mysql> CREATE EXTERNAL TABLE table_1 (col_1 INT) In versions earlier than MySQL 9.4.0, you must use the CREATE TABLE statement, and manually set ENGINE to lakehouse, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-materialized-views.html
Create and Query a Materialized View To create or alter a materialized view, you use the CREATE VIEW or ALTER VIEW statements. You cannot directly update a materialized view, so INSERT, UPDATE, and DELETE statements do not work with materialized ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. Execute EXPLAIN Statement Before running a query, you can use EXPLAIN to ...To ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
Loading Tables Statement To load a table into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement and use the following syntax. ALTER TABLE table_name SECONDARY_LOAD [PARTITION (...)] [GUIDED {ON | OFF}]; Specify the ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-24.html
SELECT statements where the SELECT query is offloaded to MySQL HeatWave and the result set is inserted into a table on the MySQL Database Service instance. SELECT performance in cases where the SELECT portion of the statement is a long running, ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-4-1.html
(WL #16847) MySQL HeatWave GenAI MySQL HeatWave GenAI now lets you generate SQL queries from natural-language statements using the new NL_SQL routine, making it easier for you to interact with databases. (WL #16513) MySQL HeatWave Lakehouse now ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
Maximum bytes per transaction: The maximum number of bytes that can be loaded from a data file with a single LOAD DATA statement. If a data file's size exceeds this value, multiple LOAD DATA statements load data from the file in chunks. For example, ... Importing Data Using the Data Import Feature 7.2.1.2 Importing Data Using the Data Import Feature Use the data import feature in the MySQL HeatWave Console to import data from an Amazon S3 bucket to a DB System in the same ...
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-error-logging.html
Server Error Logging 3.1.2.3 Server Error Logging MySQL HeatWave on AWS logs MySQL Server diagnostic information such as errors, warnings, and status updates to the Performance Schema error_log table. You can use a command-line client such as MySQL ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-security.html
Default Value false Since Version 3.0.3 allowLoadLocalInfileInPath Enables "LOAD DATA LOCAL INFILE ..." statements, but only allows loading files from the specified path. Since Version 8.0.22 allowMultiQueries Allow the use of ";" to delimit ...