.parquet
...
```
Run the query `SELECT * from source ORDER BY time` and write the
results (maintaining the order) to a parquet file named
`output.parquet` with a maximum parquet row group size of 10MB:
```sql
> COPY (SELECT * from source ORDER BY time) TO 'output.parquet' OPTIONS (MAX_ROW_GROUP_SIZE 10000000);
+-------+
| count |
+-------+
| 2 |
+-------+
```
## INSERT
### Examples
Insert values into a table.
INSERT INTO table_name { VALUES ( expression [, ...] ) [, ...] | query }
```sql
> INSERT INTO target_table VALUES (1, 'Foo'), (2, 'Bar');
+-------+
| count |
+-------+
| 2 |
+-------+
```
## DELETE
Removes rows from a table.
DELETE FROM table_name [ WHERE condition ]
`DELETE` returns the number of removed rows in a column named `count`.
If you omit the `WHERE` clause, DataFusion removes all rows.
DataFusion removes a row only if the condition is true for that row. SQL three-valued logic applies: if the condition evaluates to `NULL`, the row remains. For example, `WHERE value > 15` keeps a row with a `NULL` value, because `NULL > 15` is `NULL`.
Not all tables support `DELETE`. See [Table support for DELETE and UPDATE](#table-support-for-delete-and-update).
### Examples
Remove the rows that match a condition:
```sql
> DELETE FROM target_table WHERE id > 1;
+-------+
| count |
+-------+
| 2 |
+-------+
```
Remove all rows:
```sql
> DELETE FROM target_table;
+-------+
| count |
+-------+
| 3 |
+-------+
```
## UPDATE
Changes the values of existing rows.
UPDATE table_name SET column = expression [, ...] [ WHERE condition ]
`UPDATE` returns the number of affected rows in a column named `count`.
If you omit the `WHERE` clause, DataFusion changes all rows. The three-valued logic of `DELETE` also applies here.
Each assignment expression reads the row values from before the statement. `SET a = b, b = a` therefore exchanges the two values.
Not all tables support `UPDATE`. See [Table support for DELETE and UPDATE](#table-support-for-delete-and-update).
### Examples
Set one column in the rows that match a condition:
```sql
> UPDATE target_table SET name = 'Baz' WHERE id = 2;
+-------+
| count |
+-------+
| 1 |
+-------+
```
Set two columns, one from an expression:
```sql
> UPDATE target_table SET value = value * 2, name = 'Doubled' WHERE id < 3;
+-------+
| count |
+-------+
| 2 |
+-------+
```
## Table support for DELETE and UPDATE
Not all table providers support `DELETE` and `UPDATE`. In-memory tables created with `CREATE TABLE` support both statements. File-based tables created with `CREATE EXTERNAL TABLE` and views do not. Support for custom table providers depends on the provider.
### Known limitations
- `DELETE` ignores `LIMIT`: [#24998](https://github.com/apache/datafusion/issues/24998).
- `UPDATE ... FROM` is not supported: [#19950](https://github.com/apache/datafusion/issues/19950).