-
Notifications
You must be signed in to change notification settings - Fork 1.9k
Closed
Labels
enhancementNew feature or requestNew feature or request
Description
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
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or request