mvanschellebeeck opened a new issue, #4397:
URL: https://github.com/apache/arrow-datafusion/issues/4397
**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:
```bash
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](https://www.sqlite.org/sqllogictest/file?name=test/select1.test&ci=tip)
we want to incorporate into testing. See
https://github.com/apache/arrow-datafusion/issues/4248
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
