Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-comparison-functions-operators.html
Table 5.3 Comparison Functions and Operators Name VARLEN Support Description BETWEEN ... What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-masking-deindentification-functions.html
The following table shows data masking and de-identification functions supported by MySQL HeatWave.
https://dev.mysql.com/doc/heatwave/en/mys-hw-encryption-compression-functions.html
Table 5.6 Encryption and Compression Functions Name Description COMPRESS() Return the result as a binary string. What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for ...Note Deprecated as of MySQL 9.4.0 and scheduled for removal in a future ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-flow-control-functions-operators.html
The VARLEN Support column identifies functions and operators that support variable-length encoded string columns.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
This feature collects information on the schemas, tables, and columns that you have access to, and then uses a Large Language Model (LLM) to generate an SQL query for the question pertaining to your data. As of MySQL 9.4.1, MySQL HeatWave GenAI ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-search.html
When you enter a query, MySQL HeatWave GenAI performs a vector-based similarity search to retrieve similar content from the vector store and embedding tables available in the DB system. As of MySQL 9.2.1, you can use both inbuilt vector store ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-logical-functions.html
Table 5.8 Logical Operators Name Description AND, && Logical AND NOT, ! Negates value ||, OR Logical OR XOR Logical XOR What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-mathematical-functions.html
Table 5.9 Mathematical Functions Name Description ABS() Return the absolute value. What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-misc-functions.html
Table 5.13 Miscellaneous Functions Name Description ETAG() Compute hash for each row, using one or more column or other values. What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize ...
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. What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP ...Numeric data types: BIGINT BOOL DECIMAL DOUBLE FLOAT INT INTEGER MEDIUMINT SMALLINT TINYINT Temporal data types: DATE DATETIME TIME TIMESTAMP YEAR Temporal types are only supported with strict SQL ...