Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-rp.html
SET @input_list creates a session variable that stores all the parameters for creating the external file and loading the table with the specified files. Review the following examples to see the different ways to use resource principals and Auto ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-auto-parallel-load-task.html
mysql> CALL sys.HEATWAVE_LOAD( '[{"db_name": "db_1", "tables": [{ "table_name": "table_1", "engine_attribute": { "file": [{"uri": "oci://bucket_1@tenant_1/data_file_1.csv"}] } }] }]', NULL); While you can specify all parameters in one command, it ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
URI: The Object Storage URL to store the export query results. The URL includes the Object Storage location with the region name, the tenancy, bucket, and the directory to store the export query results. This topic shows the different ways to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external table. This topic contains the following sections: Before You Begin Refresh Data Overview Perform Initial Load Refresh Data What's Next Before You ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of execution statistics is stored for each node that participates in the query. For MySQL HeatWave AutoML routines that include ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-nodes-table.html
NUM_OBJSTORE_GETS Number of GET requests from the node to the object store. NUM_OBJSTORE_PUTS The number of PUT requests from the node to the object store. NUM_OBJSTORE_DELETES The number of DELETE requests from the node to the object store. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
Parquet Delta lake tables (as of MySQL 9.5.0) Supported File Formats for Unstructured Data A Vector store can ingest files from the following unstructured formats: PPT, TXT, HTML, DOC, and PDF. To load unstructured data, see Ingest Files into a ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
Possible values include: Iris Setosa Iris Versicolour Iris Virginica Data is stored in the MySQL database in the following schema and tables: ml_data schema: The schema containing training and test dataset tables. Prepare Datasets Create and use the ... This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-metadata.html
When you run the ML_MODEL_IMPORT routine, the imported table has a model_metadata column that stores the metadata for the table. If you import a model from a table, model_metadata stores the name of the database and table. If you import a model ...