Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. To learn how to download the sample database, see AirportDB Analytics Quickstart. Setting Secondary Engine Definition By default, SELECT queries are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
See MySQL 9.4 Error Message Reference for Lakehouse error messages. As of MySQL 9.2.2, a detailed summary of warnings is available when loading data to Lakehouse. This includes warnings related to the schema inference stage of loading data. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
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 INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-1-0.html
MySQL HeatWave GenAI MySQL HeatWave Lakehouse MySQL HeatWave MySQL HeatWave GenAI MySQL HeatWave GenAI now lets you extract and encode text from images stored in unstructured documents using Optical Character Recognition (OCR). The extracted text ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-genai-languages.html
Supported Languages 14.2.5 Supported Languages As of MySQL 9.0.1-u1, MySQL HeatWave GenAI supports natural-language communication, ingesting documents, as well as generating text-based content in multiple languages. The quality of the generated ...
https://dev.mysql.com/doc/connector-j/en/connector-j-reference-type-conversions.html
MySQL Connector/J is flexible in the way it handles conversions between MySQL data types and Java data types. In general, any MySQL data type can be converted to a java.lang.String, and any numeric type can be converted to any of the Java numeric ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after plugin startup contains the server description and startup options. Elements ...
https://dev.mysql.com/doc/refman/8.4/en/cast-functions.html
Table 14.15 Cast Functions and Operators Name Description Deprecated BINARY Cast a string to a binary string Yes CAST() Cast a value as a certain type CONVERT() Cast a value as a certain type Cast functions and operators enable conversion of values ...
https://dev.mysql.com/doc/refman/8.4/en/charset-national.html
Standard SQL defines NCHAR or NATIONAL CHAR as a way to indicate that a CHAR column should use some predefined character set. For example, these data type declarations are equivalent: CHAR(10) CHARACTER SET utf8 NATIONAL CHARACTER(10) NCHAR(10) As ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...