Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-csv.html
Consider the following limitations: You cannot give the VECTOR data type a default value other than NULL. MySQL HeatWave Lakehouse has the following limitations for CSV files. Lakehouse does not support CSV files with more than 4MB per line. As of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
MySQL HeatWave Lakehouse has the following limitations for Parquet files. Consider the following limitations: To load Parquet files with the VECTOR data type (from Parquet strings or from Parquet (numeric) Lists), you must load the table manually ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
mysql> SET @input_list = '[{ "db_name": "lakehouse_db", "tables": [{ "table_name": "table_1", "engine_attribute": { "dialect": {"format": "csv"}, "auto_refresh_event_source": "ocid1.stream.oc1.iad...", "file": [{"uri": ... As of MySQL 9.4.1, you can ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. To use this feature, define data placement keys on the most frequently used JOIN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-tables.html
mysql> CALL sys.HEATWAVE_RELOAD([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ["only_user_loaded_tables",{true|false}] ["output",{"normal"|"silent"}] } } Use key-value pairs in JSON format to specify options.
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different sources. Parquet Delta lake tables (as of MySQL 9.5.0) Supported File Formats for Unstructured Data A Vector ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ease-of-use.html
For example: CALL sys.ML_TRAIN('heatwaveml_bench.census_train', 'revenue', NULL, @census_model); The ML_TRAIN routine leverages Oracle AutoML technology to automate training of machine learning models. For example, the following call to the ...With ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-onnx-metadata.html
If the task is NULL, do not provide predictions_name or prediction_probabilities_name as this causes an error. To learn more about model metadata in the model catalog, see Model Metadata. ONNX Inputs Info Use the data_types_map to map the data type ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-a-forecasting-model.html
mysql> CREATE TABLE electricity_demand ( date DATE PRIMARY KEY, demand FLOAT NOT NULL, temperature FLOAT NOT NULL ); Insert the sample data into the table. This topic describes how to prepare the data to use for a forecasting machine learning model. To prepare the data for this use case, you set up a training dataset and a testing ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-supervised-learning.html
The dataset for this type of model must have a column whose only allowed values are 0 (normal), 1, (anomalous), and NULL (unlabeled). All rows in the dataset are used to train the unsupervised component, while the rows with a value different than ...