Multi-Insert / Delete


#1

Hi,

is it possible to have multi-inserts on a sql statement?
e.g. INSERT INTO testtable VALUES (1,2,3), (4,5,6);

Is there a plan, when you will support delete statements? Is there a way other than creating a new table from existing one with filtering the rows?

Best,
Peter


#2

Hi,

Currently the insert statement does not take multiple values. You can use COPY FROM or StreamInsert to insert multiple values.

We do intend to support DELETE as mentioned in the road map here https://github.com/mapd/mapd-core/blob/master/ROADMAP.md

regards