Search Results
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
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 HeatWave processes . Table 5.9 Mathematical Functions Name Description ABS() Return ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-misc-functions.html
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 HeatWave processes . Table 5.13 Miscellaneous Functions Name Description ETAG() ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
What's Next Learn how to perform the following tasks: Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . Ensure that the following requirements are met before offloading queries to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-runtimes.html
Runtime data is useful for query optimization, troubleshooting, and estimating the cost of running a particular query or workload. This topic describes how you can view MySQL HeatWave query runtimes and runtime estimates using the MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-sql-modes.html
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 HeatWave processes . Default DB System SQL modes are supported, which include ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-functions-operators.html
With the exception of the FORMAT() function, string functions and operators described in the following table are supported with variable-length encoded columns. FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-data-types.html
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 HeatWave processes . Columns with unsupported data types must be excluded, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-temporal-functions.html
As of MySQL 8.4.0, MySQL HeatWave supports named time zones such as MET or Europe/Amsterdam for CONVERT_TZ(). For a workaround before MySQL 8.4.0, see Section 11.2.1.4, “Functions and Operator Limitations”. Table 5.11 Temporal Functions Name ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-vector-functions.html
It accepts the following arguments: A column of VECTOR data type.