metesynnada opened a new issue, #5127:
URL: https://github.com/apache/arrow-datafusion/issues/5127
**Describe the bug**
Try to insert a table in the fresh terminal:
```sql
insert into person (id, first_name, last_name) values (1, 'Alan', 'Turing');
```
which is a query used in tests as well. Result is
```
❯ insert into person (id, first_name, last_name) values (1, 'Alan',
'Turing');
NotImplemented("Unsupported SQL statement: Some(\"INSERT INTO person (id,
first_name, last_name) VALUES (1, 'Alan', 'Turing')\")")
```
I am not sure if it is a bug, however, I couldn't create a case that I can
use INSERT INTO. Even if I create the `person` table with some initial data, I
get the same error.
**To Reproduce**
Steps to reproduce the behavior:
- Create a table
```sql
CREATE EXTERNAL TABLE test_1 (
c1 VARCHAR NOT NULL,
c2 INT NOT NULL,
c3 SMALLINT NOT NULL,
c4 SMALLINT NOT NULL,
c5 INT NOT NULL,
c6 BIGINT NOT NULL,
c7 SMALLINT NOT NULL,
c8 INT NOT NULL,
c9 BIGINT NOT NULL,
c10 VARCHAR NOT NULL,
c11 FLOAT NOT NULL,
c12 DOUBLE NOT NULL,
c13 VARCHAR NOT NULL
)
STORED AS CSV WITH HEADER ROW
LOCATION 'testing/data/csv/aggregate_test_100.csv';
```
- Create the `person` table
```sql
CREATE TABLE person
AS (SELECT c2, c1, c10 FROM test_1);
```
- Insert a value into the table
```sql
insert into person (id, first_name, last_name) values (1, 'Alan', 'Turing');
```
**Expected behavior**
I would expect it to run.
**Additional context**
Add any other context about the problem here.
--
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]
