Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-find.html
mysql-js> myColl.find("$**.b3**.b2").execute(); { "a": "bar", "b": { "b1": 6, "b2": 7, "b3": { "b1": 99, "b2": 98, "b3": { "b1": 999, "b2": 998 } } }, "_id": "000061313aa10000000000000001" } 1 document in set, 1 warning (0.0011 sec) ... The % and _ ... The find(SearchConditionStr) function is for searching documents in a collection, similar to the SELECT statement for an SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...Data is only available for the current session and is lost when the session terminates or when the server is shut ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave and update table statistics. When you run the ANALYZE TABLE statement for a table loaded in MySQL HeatWave, the analysis is performed on MySQL ...Before You Begin Ensure that the enable_secondary_engine_statistics system variables is set to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-column-limits.html
MySQL HeatWave has the following column limits: As of MySQL 9.2.2, the maximum column width is 4192192 bytes. In previous versions of MySQL, the maximum column width is 65532 bytes. Any table with multiple columns wherein the aggregate data size is ...This includes the size of all the data and column metadata stored in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This topic contains the following sections: Before You Begin Generate and Run an SQL ...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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-overview.html
AWS S3 URL: For MySQL HeatWave on AWS, you must use AWS S3 URLs. See Manage AWS Access from the MySQL HeatWave on AWS Service Guide to learn more. Supported File Formats You can export the query results in the following file formats: CSV (As of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-Parquet-non-json.html
INTO OUTFILE {URL | URI} 'uri' [FORMAT parquet] [COMPRESSION {snappy | gzip | brotli | zstd | lz4 | uncompressed}] Note As of MySQL 9.5.0, you can enclose options for FORMAT and COMPRESSION with or without quotation characters. You can use one of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-parquet.html
MySQL HeatWave Lakehouse has the following limitations for Parquet files. As of MySQL 9.1.2, you can load Parquet files with row groups that total up to 10GB with large MySQL HeatWave Cluster shapes. As of MySQL 9.3.2, limited support is available ...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 with is_strict_mode set to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-resource-principal.html
As of MySQL 9.2.1, if the region is not specified, the instance's associated region is used as the default region. mysql> CREATE EXTERNAL TABLE table_1(col_1 int, col_2 int, col_3 int) ENGINE_ATTRIBUTE='{"dialect": {"format": "csv"}, "file": ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the following limitations: MySQL HeatWave cannot load partitions with Auto Parallel Load. MySQL ...