Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
| | Expected time for applying all Index creation suggestions: 25 s | | | +--------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ To ... To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output that includes the following information: New indexes to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of the number of rows returned COUNT(DISTINCT) Return the count of a number of different values ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dictionary-encoding.html
Dictionary encoding (SORTED) has the following characteristics: Best suited to string columns with a low number of distinct values relative to the cardinality of the table. Load operations for tables with dictionary-encoded string columns that have ...Dictionary encoding reduces the space required for column values on the MySQL HeatWave nodes but requires space on the DB System node for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
View Details To view the chat session details, inspect the @chat_options variable: mysql> SELECT JSON_PRETTY(@chat_options); The output includes the following details about a chat session: Vector store tables: in the database which were referenced ... This topic describes how to view a chat session ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-index-creation.html
As of MySQL 9.5.0, MySQL HeatWave GenAI automatically creates vector indexes for frequenctly queried VECTOR columns in vector store and embedding tables using advanced index structures such as Hierarchical Navigable Small World (HNSW). Information ...Control Automatic Vector Index Creation and Usage To disable automatic index creation, use the rapid_auto_vector_index_enabled ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
Export File Prefix After the query results are exported to Object Storage, the export file prefix is added to the rpd_query_stats table. Exported query results are in CSV, Parquet, or JSON (As of MySQL 9.3.1) format. The number of output files and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse tables to Object Storage. This feature is available for MySQL HeatWave on OCI and MySQL HeatWave on AWS. The capability to convert the output into ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-joins.html
The plan evaluation count is reset to zero after each derived table, after an outer query, and after each subquery. Outer join queries without an equality condition defined for the two tables. Antijoins, with the exception of supported IN and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-pre-authenticated-requests.html
What's Next Learn how to do the following: Create External Tables Using Auto Parallel Load. Pre-authenticated requests (PAR) allow you to access a bucket or an object in Oracle Cloud Infrastructure (OCI) Object Storage without having your own ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-resource-principal.html
What's Next Learn how to do the following: Create External Tables Using Auto Parallel Load. Resource principals allow you to authenticate and access Oracle Cloud Infrastructure (OCI) Object Storage resources. You require the appropriate privileges ...