Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-dictionary-encoding.html
Load operations for tables with dictionary-encoded string columns that have a high number of distinct values can fail if there is not enough available memory on the DB System node. Dictionary encoding (SORTED) has the following characteristics: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
Check if you have the SELECT and INSERT privileges for the table that you want to analyze. In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, by defining them with the NOT ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
This topic describes how to view a chat session details. It contains the following sections: Before You Begin View Details What's Next Before You Begin Complete the steps to run MySQL HeatWave Chat. View Details To view the chat session details, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
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 data. As of MySQL 9.4.1, MySQL HeatWave GenAI ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
Some key benefits of using MySQL HeatWave GenAI are described below: The natural-language processing (NLP) capabilities of the LLMs let non-technical users have human-like conversations with the system in natural language. MySQL HeatWave GenAI is a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-rag.html
The ML_RAG routine runs retrieval-augmented generation which aims to generate more accurate responses for your queries. As of MySQL 9.5.0, you can use hybrid search, which combines semantic search and keyword-based search to effectively retrieve ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
This helps improve parsing of PDF documents that have a complex structure, or contain complex tables and images. This section describes how to generate vector embeddings for files or folders stored in Object Storage, and load the embeddings into a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
Deprecated synonym for JSON_MERGE_PRESERVE() JSON_MERGE_PATCH() Merge JSON documents, replacing values of duplicate keys JSON_MERGE_PRESERVE() Merge JSON documents, preserving duplicate keys JSON_OBJECT() Create JSON object literal JSON_OVERLAPS() ...Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
This topic shows the different ways to export query results as a CSV file with SQL syntax. INTO OUTFILE {URL | URI} 'uri' [FORMAT csv] [CHARACTER SET 'charset_name'] [HEADER {ON | OFF}] [{FIELDS | COLUMNS} [NULL AS 'null_char'] [TERMINATED BY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-json.html
Tables created with json format must only have a single column that conforms to the JSON data type, see: The JSON Data Type. MySQL HeatWave Lakehouse has the following limitations for JSON files. As of MySQL 9.3.1, Lakehouse can load up to 4192192 ...