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 ...Compare this with the examples found in Section 4.3, “Collection CRUD Function Overview” to see the differences and similarities between the CRUD functions for tables and collections in the X ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/shell-automatic-code-execution-results.html
When you use X DevAPI in a programming language that fully specifies the syntax to be used, for example, when executing SQL statements through an X DevAPI session or working with any of the CRUD operations, the actual operation is performed only ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-report-table.html
From MySQL version 8.0.32 onwards, the heatwave_advisor_report table, is deprecated and replaced with the heatwave_autopilot_report table in the sys schema. When MySQL runs Advisor, it sends detailed output to the heatwave_advisor_report table in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-report-table.html
It contains data from the last execution of Advisor or Auto Parallel Load. Data is only available for the current session and is lost when the session terminates or when the server shuts down. When Advisor or Auto Parallel Load run, they send ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Then, the MySQL HeatWave query processing engine (RAPID) is set as the secondary engine for the table, using ALTER TABLE statement. Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-par.html
Review the following examples to see the different ways to use pre-authenticated requests (PAR) to specify files when creating external tables manually. Create the external tables that will ingest the loaded data by either using SQL syntax or JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-uri.html
As of MySQL 9.3.1, and only on MySQL HeatWave on OCI, you can use uniform resource identifiers (URI) to specify files for loading data when creating external tables manually. Review the following examples for different ways to create external ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
MySQL HeatWave can unload up to 1,000 partitions in a single statement. Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the following limitations: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
You can manually load data from InnoDB tables in your DB System into MySQL HeatWave Cluster by using SQL data definition language (DDL) such as CREATE TABLE and ALTER TABLE statements. MySQL version 8.2.0 or higher has a guided load feature which ...Perform the following steps sequentially for each table that you want to load: Exclude table columns with unsupported data types or columns not used in queries Define a secondary engine on the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-supported-file-formats.html
You cannot set the embedding model with SQL syntax for the CREATE TABLE statement. Review the various file formats supported for loading structured, semi-structured, and unstructured data in MySQL HeatWave from different sources. Parquet Delta lake ...