Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Supported Encoding Types MySQL HeatWave supports Variable-length encoding(VARLEN) and Dictionary encoding (SORTED). The following table provides an overview of encoding type characteristics: Table 5.15 Column Encoding Type Characteristics Encoding ... This topic describes how to encode string columns to improve the performance of queries that access ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
To use this file, visit Bank Marketing and download the bank+marketing.zip file. To learn more about each method, see the following: Access Object Storage with Uniform Resource Identifiers and URI load examples. Access Object Storage with Resource ... If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table ...
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. This allows side by side comparisons of target column labels, ground truth, and predictions in the same table. ML_PREDICT_ROW ignores any extra columns, and appends ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-row.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about training and loading models, see Train a Model and Load a Model. After training and loading the model, you can generate predictions on one or more rows of data. Input ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-similar-items.html
For known items, the output includes a list of predicted items that have similar ratings and are appreciated by similar users. The predictions are expressed in cosine similarity, and range from 0, very dissimilar, to 1, very similar. Before You ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-similar-users.html
For known users, the output includes a list of predicted users that have similar behavior and taste. The predictions are expressed in cosine similarity, and range from 0, very dissimilar, to 1, very similar. Before You Begin Review and complete the ... This topic describes how to generate recommendations for similar ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-ml-embed-table.html
This topic contains the following sections: ML_EMBED_TABLE Syntax Syntax Examples See Also To learn about the privileges you need to run this routine, see Section 7.3, “MySQL HeatWave GenAI Roles and Privileges”. ML_EMBED_TABLE Syntax mysql> ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
Click the Workspace tab, and then click the Data Imports tab. The Amazon S3 bucket and DB System must be in the same region. Once you finish the data import, it is recommended that you review the Amazon S3 bucket's access permissions and remove ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connection-compression-xdevapi.html
Connector/J supports data compression for X DevAPI connections when working with MySQL Server 8.0.19 and later. For details on how to configure connection compression for Connector/J, see the descriptions for the connection properties ...General ...
https://dev.mysql.com/doc/refman/8.4/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Its value is constructed from the User and Host columns of the user ... Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL ...