Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-collections-basic-crud.html
The following example shows the basic usage of CRUD operations (see Section 4.3, “Collection CRUD Function Overview” for more details) when working with documents: After establishing a connection to a MySQL Server instance, a new collection that ... Working with collections of documents is straightforward when using X ...
https://dev.mysql.com/doc/heatwave/en/hw-automl-privileges.html
mysql> GRANT CREATE, DROP, INSERT, SELECT, ALTER, DELETE, UPDATE ON database_name.* TO 'user_name'@'%'; Lakehouse and Tracking/Monitoring Privileges You need the following privileges to access external Lakehouse tables that have machine learning ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
This topic describes how to create a new table and insert data using a SELECT query. However, if the SELECT query returns a large result set, queries that produce large result sets performance may be limited because inserting the data into the DB ...When the query is offloaded to MySQL HeatWave, it is processed faster, improving the overall performance of the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate text summaries for unstructured files available in Object Storage. You need to first ingest these documents into vector store tables using Auto Parallel Load. The generated table contains ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
The function definition must not contain CREATE, INSERT, ALTER, UPDATE, or DELETE statements. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in GROUP BY clauses in the following cases: In ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
Ensure that the following requirements are met before offloading queries to MySQL HeatWave: Use a SELECT statement. SELECT statements are supported, but only the SELECT portion is offloaded to MySQL HeatWave. Define all tables accessed by the query ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-error-messages.html
Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Each error message includes an error number, SQLSTATE value, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-how-to-import-onnx.html
mysql> LOAD DATA LOCAL INFILE '/Users/user1/iris_base64.onnx' INTO TABLE onnx_temp CHARACTER SET binary FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\r' (onnx_string); Insert the loaded string into a session variable. mysql> LOAD DATA LOCAL INFILE ... This topic describes how to import an external ONNX ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
Use ML_PREDICT_ROW and ML_EXPLAIN_ROW with Lakehouse Data To avoid using the FROM clause, you can insert the data to predict and explain directly into a JSON object. mysql> CALL sys.ML_MODEL_LOAD(@bank_model, NULL); Insert the data to predict and ...