Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
mysql> CREATE DATABASE bank_data; mysql> USE DATABASE bank_data; Set up the CREATE EXTERNAL TABLE statement and the ENGINE_ATTRIBUTE options to specify the parameters needed to process the external files. In versions earlier than MySQL 9.4.0, you ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental load. This feature is currently only available for MySQL HeatWave on OCI. mysql> SET @input_list = '[{ "db_name": "lakehouse_db", "tables": [{ "table_name": ...Once an event for an external file location is emitted due to a change to an object, Lakehouse automatically refreshes the data into the external ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain-table.html
Depending on your MySQL version, we recommend the following: Before MySQL 9.4.1, use the batch_size option to limit operations to batches of 10 to 100 rows by splitting large tables into smaller tables. A table can include extra columns, and still ... ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-predict-row.html
A table can include extra columns, and still use the MySQL HeatWave AutoML model. mysql> SELECT sys.ML_PREDICT_ROW(JSON_OBJECT("column_name", value, "column_name", value, ...), model_handle, options); Run ML_PREDICT_ROW on multiple rows of data by ... ML_PREDICT_ROW generates predictions for one or more rows of unlabeled data specified in JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-score.html
ML_SCORE Syntax mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...) "key","value": { ['threshold', 'N'] ['topk', 'N'] ['remove_seen', ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-an-anomaly-detection-model.html
mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('anomaly_detection_semi_supervised_use_case', NULL); Score the model with the ML_SCORE routine and use the accuracy metric.
https://dev.mysql.com/doc/connector-j/en/connecting-using-kerberos.html
Kerberos is a ticket-based server-client mutual authentication protocol that is supported by the MySQL Server (commercial versions only) . Kerberos Authentication Workflow The main usage of Kerberos authentication in MySQL is to allow users to ...
https://dev.mysql.com/doc/connector-j/en/connector-j-named-pipe.html
As a workaround, the MySQL Server that Connector/J wants to connect to must be started with the system variable named_pipe_full_access_group, which specifies a Windows local group containing the user by which the client application JVM (and thus ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
MySQL Connector/ODBC defines BLOB values as LONGVARBINARY and TEXT values as LONGVARCHAR. You can make more bytes significant in sorting or grouping by increasing the value of max_sort_length at server startup or runtime. For example, both mysql and ... A BLOB is a binary large object that can hold a variable amount of ...
https://dev.mysql.com/doc/refman/8.4/en/column-count-limit.html
Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given table. Row Size Limits The maximum row size for a given table is determined by several factors: ... This section describes limits on the number of columns in tables and the size of individual ...