Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/devapi-users-working-with-relational-tables.html
The X DevAPI SQL CRUD functions allow you to work with relational tables in manners similar to using traditional SQL statements. The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/using-sql.html
In addition to the simplified X DevAPI syntax of the Session object, the Session object has a sql() function that takes any SQL statement as a string. The following example uses a Session to call an SQL Stored Procedure on the specific node.
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Workaround: Use the existing aggregation functions to express the functionality of a user-defined function. The following list contains all current MySQL HeatWave errors in numerical order. The entry for each error contains the error number, name ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
Auto Encoding does not generate recommendations for a given table if existing encodings do not require modification. Using the right string column encodings can reduce the amount of memory required on MySQL HeatWave nodes and improve query ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-execution.html
Autopilot Indexing only evaluates SQL statements in the SQL statement digest history that access existing tables. Autopilot Indexing provides recommendations for schemas with a representative workload that has at least five queries in the SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-analyzing-tables.html
An ACE statistics model already exists for a table and no updates were made to the table since the last time the ACE statistics model was built. As of MySQL 9.3.0, you can use the ANALYZE TABLE statement to analyze tables loaded into MySQL HeatWave ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
MySQL 9.0.0 adds support for Lakehouse Incremental Load with the refresh_external_tables option, see: Section 4.3.13.2, “Refresh Data Using Incremental Load”. This adds an include list to exactly specify the tables and columns to load for a set ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
Unlike the MySQL temporary table that exists in DB System, MySQL HeatWave temporary tables are stored in the MySQL HeatWave Cluster by the MySQL HeatWave engine and are used for MySQL HeatWave processing. As of MySQL 9.3.0, you can create temporary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
If the specified table doesn't exist, a new table is created. 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 ...