Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. var res = mySession.sql('SELECT name, age FROM ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-modify.html
The modify(SearchConditionStr) function is for modifying documents in a collection, similar to an UPDATE statement for an SQL database. It takes a search condition string (SearchConditionStr) as a parameter to specify the documents that are to be ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/working-with-sql-result-sets.html
When you execute an SQL operation on a Session using the sql() method, an SqlResult is returned. Iterating over an SqlResult is identical to working with results from CRUD operations. res = mySession.sql('SELECT name, age FROM users').execute() row ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-analytics.html
When a MySQL HeatWave Cluster is enabled, queries that meet certain prerequisites are automatically offloaded from the DB System to the MySQL HeatWave Cluster for accelerated processing. Queries are issued from a MySQL client or application that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-auto-parallel-load.html
Auto Parallel Load is a feature of MySQL HeatWave that automates many of the steps for loading data, which include the following: Excluding schemas, tables, and columns that cannot be loaded. Defining RAPID as the secondary engine for tables that ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load.html
You can load data into a MySQL HeatWave Cluster by using the Auto Parallel Load feature. Auto Parallel Load, which can be run manually from any MySQL client or connector, is implemented as a stored procedure named heatwave_load, which resides in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-overview.html
MySQL HeatWave GenAI is a feature of MySQL HeatWave that lets you communicate with unstructured data in MySQL HeatWave using natural-language queries. However, as these LLMs are trained on public data, the responses to your queries are generated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-incremental-load.html
Available as of MySQL 9.0.0, Lakehouse Incremental Load allows you to refresh the data in an external table. This topic contains the following sections: Before You Begin Refresh Data Overview Perform Initial Load Refresh Data What's Next Before You ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
The Lakehouse feature of MySQL HeatWave enables query processing on data in Object Storage. MySQL HeatWave Lakehouse reads the source data from Object Storage, transforms it to the memory optimized MySQL HeatWave format, saves it in the MySQL ...