You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Is your feature request related to a problem or challenge? Please describe what you are trying to do.
Support the INSERT INTO expression, e.g. INSERT INTO t1(e,c,b,d,a) VALUES(103,102,100,101,104)
Executing with datafusion-cli:
DataFusion CLI v14.0.0
❯ CREATE TABLE abc AS VALUES (1,2,3), (4,5,6);
0 rows in set. Query took 0.004 seconds.
❯ SELECT * FROM abc;
+---------+---------+---------+
| column1 | column2 | column3 |
+---------+---------+---------+
| 1 | 2 | 3 || 4 | 5 | 6 |
+---------+---------+---------+
2 rows in set. Query took 0.005 seconds.
❯ INSERT INTO abc(column1, column2, column3) values (7,8,9);
NotImplemented("Unsupported SQL statement: Some(\"INSERT INTO abc (column1, column2, column3) VALUES (7, 8, 9)\")")
Additional context
The ability to insert values via the cli throughout a sessions forms the basis of a lot of sqllogictests we want to incorporate into testing. See #4248
Activity
alamb commentedon Nov 29, 2022
Anything involving arrow is going to be non ideal (aka is going to be very slow) with multiple "INSERT INTO" statements.
I suggest we implement support for
INSERT INTOstatements (and possibly #4396) as part of the test harness rather than in DataFusion itself