chunk_id:

INT AUTO_INCREMENT PRIMARY KEY

model_object:

LONGTEXT DEFAULT NULL

model_metadata:

JSON

See Model Metadata.

If there is no corresponding row in the model_object_catalog for an existing model_handle in the MODEL_CATALOG:

There should be only one row in the output table with chunk_id = 0, model_object = NULL and model_metadata = MODEL_CATALOG.model_metadata.

If there is at least one row in the model_object_catalog for an existing model_handle in the MODEL_CATALOG:

model_handle: The model handle for the model. See Work with Model Handles.

output_table_name: The name for the output table.

An example that exports an AutoML model with metadata to the model catalog (ML_SCHEMA_user1.model_export). The output table name is model_export. You can then use SHOW_CREATE_TABLE to view information on the table for the exported model.

mysql> CALL sys.ML_MODEL_EXPORT(@iris_model, 'ML_SCHEMA_user1.model_export');
Query OK, 0 rows affected (0.06 sec)

mysql> SHOW CREATE TABLE ML_SCHEMA_user1.model_export;
+--------------+--------------------------------------------------------------------+
| Table        | Create Table                                                       |
+--------------+--------------------------------------------------------------------+
| model_export | CREATE TABLE `model_export` (
`chunk_id` int NOT NULL AUTO_INCREMENT,
`model_object` longtext,
`model_metadata` json DEFAULT NULL,
PRIMARY KEY (`chunk_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci |
+--------------+--------------------------------------------------------------------+
1 row in set (0.00 sec)

Grant Other Users Access to a Model

Manage External ONNX Models