Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-indexing.html
To make large collections of documents more efficient to navigate you can create an index based on one or more fields found in the documents in the collection. Creating an Index Collection indexes are ordinary MySQL indexes on virtual columns that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-bulk-load-mysql-server.html
MySQL includes a bulk load extension to the LOAD DATA statement that is only available in MySQL HeatWave on AWS. It can do the following: Optimize the loading of data sorted by primary key. Monitor bulk load progress with the Performance Schema (As ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.html
CAST() from and to all the MySQL HeatWave supported numeric, temporal, string and text data types. CAST() of ENUM columns to CHAR, DECIMAL, FLOAT, and to SIGNED and UNSIGNED numeric values. CAST() operates on the ENUM index rather than the ENUM ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
The following sections in this topic describe how to summarize exiting content using MySQL HeatWave GenAI: Before You Begin Summarize Text Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and privileges.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
MySQL HeatWave Lakehouse has the following limitations for Parquet files. Consider the following limitations: To load Parquet files with the VECTOR data type (from Parquet strings or from Parquet (numeric) Lists), you must load the table manually ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-data-types.html
The following string and text data types are unsupported: BINARY VARBINARY Decimal values with a precision greater than 18 in expression operators are unsupported, with the exception of the following: Arithmetic operators, see: Section 5.3.2, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() JSON_EXTRACT() Bit functions and operators. Rewrite queries that use named time zones with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-mathematical-functions.html
Table 5.9 Mathematical Functions Name Description ABS() Return the absolute value. ATAN2(), ATAN() Return the arc tangent of the two arguments CEIL() Return the smallest integer value not less than the argument. CEILING() Return the smallest integer ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-partitioning.html
When data is loaded into MySQL HeatWave, it is partitioned by the table primary key and sliced horizontally for distribution among MySQL HeatWave nodes by default. To use this feature, define data placement keys on the most frequently used JOIN ...