Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data-uri.html
These examples use an input_list variable to set up the creation of the external table and the files to load the table. As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-change-propagation.html
As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled for the table. In previous versions of MySQL, RAPID_LOAD_POOL_TRANSACTIONAL indicates that change propagation is enabled for the table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
Warning (code 3877): 1 InnoDB parallel read thread was requested to load airportdb.airport_geo (session variable value: 4). You can load tables into HeatWave using the SECONDARY_LOAD clause. Loading Tables Statement To load a table into MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-column-encoding-reference.html
MySQL HeatWave supports two string column encoding types: Variable-length encoding: This is the default encoding type. It applies to string columns by default when tables are loaded with the exception of string columns defined explicitly as ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
For Auto Parallel Load, columns with BINARY must have variable-length encoding. Columns with unsupported data types must be excluded, and defined as NOT SECONDARY before loading a table. Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-temporal-functions.html
As of MySQL 8.4.0, MySQL HeatWave supports named time zones such as MET or Europe/Amsterdam for CONVERT_TZ(). For a workaround before MySQL 8.4.0, see Section 11.2.1.4, “Functions and Operator Limitations”. Table 5.11 Temporal Functions Name ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-row.html
The ML_EXPLAIN_ROW routine generates explanations for one or more rows of unlabeled data. A loaded and trained model with the appropriate prediction explainer is required to run ML_EXPLAIN_ROW. ML_EXPLAIN_ROW does not support recommendation, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-active.html
model_info: The name of the JSON array session variable that contains the active user and model information. Use this routine to check which models are loaded and active for which users. All active users and models share the amount of memory defined ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-unload.html
mysql> CALL sys.ML_MODEL_UNLOAD('ml_data.iris_train_user1_1636729526'); An example that specifies a session variable containing the model handle. As of MySQL 9.0.0, ML_MODEL_UNLOAD does not check whether the model specified is in the model catalog.
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-row.html
mysql> SELECT sys.ML_PREDICT_ROW(JSON_OBJECT("output_col_name", schema.`input_col_name`, "output_col_name", schema.`input_col_name`, ...), model_handle, options) FROM input_table_name LIMIT N; model_handle: Define the model handle or a session ...