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-monitoring.html
This section provides queries that you can use to monitor MySQL HeatWave.
https://dev.mysql.com/doc/heatwave/en/mys-hw-performance-monitoring.html
Use SQL queries to access this data and check the system status and performance. The MySQL Performance Schema collects statistics on the usage of MySQL HeatWave. The Auto Shape Prediction feature in MySQL HeatWave Autopilot uses MySQL statistics ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-quickstart-prereqs.html
You need an operational MySQL HeatWave DB System with the MySQL HeatWave Cluster enabled to do the following: Load and manage data in the MySQL HeatWave Cluster. However, some of these components have some additional requirements that are listed in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd_vector_indexes-table.html
Queries using the same distance metric are accelerated by the index. The rpd_vector_indexes table provides information about vector indexes created for different vector store or embedding tables. SPACE: Vector distance metric, which can be one of: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-columns-table.html
The rpd_columns table provides column encoding information for columns of tables loaded in MySQL HeatWave. The rpd_columns table has these columns: TABLE_ID A unique identifier for the table. DATA_PLACEMENT_INDEX The data placement key index ID ...
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 ...