Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
Review How To Load Data From Object Storage Using Auto Parallel Load. As of MySQL 9.4.0, you can use the CREATE EXTERNAL TABLE statement, which automatically sets ENGINE to lakehouse, and SECONDARY_ENGINE to rapid. What's Next After successfully ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.2.0, MySQL HeatWave Lakehouse can automatically detect these values. To review all syntax options for loading external files, see Auto Parallel Load Syntax and Lakehouse External Table Syntax. As of MySQL 9.4.0, you can use the CREATE ... To load data manually using uniform resource identifiers (URI), which is available as of MySQL 9.3.1 and supported in MySQL HeatWave on OCI only, review the following examples for different ways to set them ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
The counter auto-increments for each MySQL HeatWave and MySQL HeatWave AutoML query. For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query. For MySQL HeatWave AutoML, this ... The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-table.html
If the input table does not have a primary key, the output table will have a new primary key column that auto increments. A table can include extra columns, and still use the MySQL HeatWave AutoML model. ML_EXPLAIN_TABLE explains predictions for an ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-table.html
If the input table does not have a primary key, the output table has a new primary key column that auto increments. A table can include extra columns, and still use the MySQL HeatWave AutoML model. ML_PREDICT_TABLE generates predictions for an ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-train.html
The column can be one of the supported datetime column types, DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing index. MySQL 9.0.0 introduces changes to how MySQL HeatWave AutoML stores models. Before training models, make sure to ... Run the ML_TRAIN routine on a training dataset to produce a trained machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-training-a-forecasting-model.html
The following data types for this column are supported: DATETIME, TIMESTAMP, DATE, TIME, and YEAR, or an auto-incrementing index. Before training the model, it is good practice to define the model handle instead of automatically creating one. If you ... After preparing the data for a forecasting model, you can train the ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-0-0.html
MySQL HeatWave AutoML MySQL HeatWave Autopilot MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML has increased the maximum model size from 900MB. (WL #15931) ...
https://dev.mysql.com/doc/connector-j/en/connector-j-config-failover.html
Sometimes, the driver might eventually fall back to the original host automatically before the client application continues to run, in which case the host switch is transparent and the client application will not even notice it. The failover support ...A failover happens when connection-related errors occur for an underlying, active ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table.html
To reset the current auto-increment value: ALTER TABLE t1 AUTO_INCREMENT = 13; You cannot reset the counter to a value less than or equal to the value that is currently in use. For both InnoDB and MyISAM, if the value is less than or equal to the ...