[IGNITE-6092] Bulk Inserts are not Supported

• Type: New Feature
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 2.1
• Assignee: Unassigned
• Reporter: Denis A. Magda
• Created: 16/Aug/17 20:46
• Updated: 29/Aug/18 08:02

Description

Presently the bulk inserts like these are not supported by Ignite's SQL engine:

INSERT INTO City (id, name)
VALUES (1, 'Forest Hill'),
       (2, "Denver"),
       (3, "St. Petersburg")

INSERT INTO Person (id, name, city_id)
VALUES (1, 'John Doe', 3),
       (2, "Jane Roe", 2),
       (3, "Mary Major", 1),
       (4, "Richard Miles", 2)

Let's plan to support them for the nearest release. I've used DBeaver tool to validate the statements above:
https://apacheignite-tools.readme.io/docs/dbeaver