Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-prepare.html
mysql> CREATE TABLE house_price_training ( id INT PRIMARY KEY, house_size INT, address TEXT, state TEXT, price INT ); Insert the sample data into the table. mysql> CREATE TABLE house_price_testing ( id INT PRIMARY KEY, house_size INT, address TEXT, ... This topic describes how to prepare the data to use for a regression machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-hw-chat.html
include_document_uris: limits the documents used for context retrieval by including only the specified document URIs. vector_store_columns: optional parameter which specifies column names for finding relevant vector and embedding tables for context ... The HEATWAVE_CHAT routine automatically calls the ML_RAG routine which loads an LLM and runs a semantic search on the available vector stores by ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-3-2.html
(WL #16368) MySQL HeatWave GenAI Content generation using MySQL HeatWave GenAI now supports speculative decoding, which enables faster response token generation and speeds up text generation if the target Large Language Model (LLM) supports ... Note ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-importing-data-data-import.html
Text files: Names of data files in S3 bucket: Specify the names of data files in the Amazon S3 bucket. Apart from text files, you can specify text files in compressed formats such as gzip (.gz) and zstd (.zst). Fields optionally enclosed: Select the ... Importing Data Using the Data Import Feature 7.2.1.2 Importing Data Using the Data Import Feature Use the data import feature in the MySQL HeatWave Console to import data from an Amazon S3 bucket to a DB System in the same ...
https://dev.mysql.com/doc/refman/8.4/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). Output is larger than for physical backup, particularly when saved in text ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/8.4/en/gis-data-formats.html
Two standard spatial data formats are used to represent geometry objects in queries: Well-Known Text (WKT) format Well-Known Binary (WKB) format Internally, MySQL stores geometry values in a format that is not identical to either WKT or WKB format.
https://dev.mysql.com/doc/refman/8.4/en/information-functions.html
This function can be used for the default value of a VARCHAR or TEXT column, as shown in the following CREATE TABLE statement: CREATE TABLE t (c VARCHAR(288) DEFAULT (CURRENT_USER())); DATABASE() Returns the default (current) database name as a ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-innodb-ft-index-cache-table.html
The INNODB_FT_INDEX_CACHE table provides token information about newly inserted rows in a FULLTEXT index. Before querying it, set the value of the innodb_ft_aux_table system variable to the name (including the database name) of the table that ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-row-format.html
Tables that use the REDUNDANT row format store the first 768 bytes of variable-length column values (VARCHAR, VARBINARY, and BLOB and TEXT types) in the index record within the B-tree node, with the remainder stored on overflow pages. Tables that ...
https://dev.mysql.com/doc/refman/8.4/en/json.html
When the server later must read a JSON value stored in this binary format, the value need not be parsed from a text representation. The space required to store a JSON document is roughly the same as for LONGBLOB or LONGTEXT; see Section 13.7, ...The ...