Search Results
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/collection-add.html
The collection needs to be created with the Schema.createCollection() function before documents can be inserted. // Create a new collection var myColl = db.createCollection('my_collection'); // Insert a document myColl.add({ name: 'Laurie', age: 19 ... The Collection.add() function is for storing documents in a collection, similar to the INSERT statement for an SQL ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/collection-add.html
The collection needs to be created with the Schema.createCollection() function before documents can be inserted. # Create a new collection myColl = db.create_collection('my_collection') # Insert a document myColl.add({ 'name': 'Laurie', 'age': 19 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
Additionally, organizations can leverage the machine learning (ML) and generative artificial intelligence (GenAI) features of MySQL HeatWave for building predictive models, creating and enhancing AI-powered applications using proprietary data, and ... MySQL HeatWave is a fully-managed cloud service that enables organizations to efficiently run analytics, transactional processing, machine learning, generative AI, and vector processing using a single service without the need for extract, transfer, and load ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
The execute_prepared_stmt_async routine creates a task that executes SQL statements asynchronously within an event stored in the schema_name schema. @task_id (VARCHAR(36)): output parameter that returns the unique identifier (UUID) of the created ...schema_name (VARCHAR(255)): specifies the schema to run the given SQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-connect-to-db-sys.html
Connect to the DB System After you have created and configured your DB System, connect to the DB System. This topic provides links to relevant documents that describe how to connect to a MySQL HeatWave DB System. For MySQL HeatWave on Oracle Cloud ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-authenticate-service.html
Note If the dynamic group belongs to the default identity domain, you can omit specifying the identity domain name. GroupName: the dynamic group name CompartmentID: the compartment ID of the DB system For more information, see Resource Principals.
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
JSON_ARRAY() Create JSON array JSON_ARRAY_APPEND() Append data to JSON document JSON_ARRAY_INSERT() Insert into JSON array JSON_CONTAINS() Whether JSON document contains specific object at path. Deprecated synonym for JSON_MERGE_PRESERVE() ...Table ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-access-object-storage.html
To allow MySQL HeatWave Lakehouse to process data in Amazon S3, see Creating Lakehouse Mapping. MySQL HeatWave on OCI can access external data stored on Oracle Cloud Infrastructure in Object Storage.
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-load.html
mysql> SET @db_list = '["tpch"]'; This assumes that Lakehouse Auto Parallel Load will analyze the data, infer the table structure, and create the database and all tables. Note Do not use the external_tables option as of MySQL 8.4.0. The Auto ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax.html
To set options when creating external tables, you have the following options: As of MySQL 9.4.0, you can use SQL syntax to set table-level and column-level options for external tables. You can use table-level and column-level ENGINE_ATTRIBUTE ...