![]() ![]() The batch involving multiple partitions needs to be well-designed as it involves coordination between multiple nodes. We should note that we'll not be able to undo any batch query since t he batch query does not support rollback functionality. VALUES (2c11bbcd-4587-4d15-bb57-4b23a546bd7f,0e9ef8f7-d32b-4926-9d37-27225933a5f5,'banana') įirst, we use the BEGIN BATCH statement without any optional parameters like UNLOGGED or USING TIMESTAMP to initiate the batch query, and then include all the DML operations, i.e., the insert statements for the product table.įinally, we use the APPLY BATCH statement to execute the batch. INSERT INTO product (product_id, variant_id, product_name) Let's go through the above syntax with an example: BEGIN BATCH ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |