alamb commented on issue #7639:
URL:
https://github.com/apache/arrow-datafusion/issues/7639#issuecomment-1734372256
For the record the error is: `Error during planning: Mismatch between schema
and batches`
Here is a self contained reproducer
```sql
❯ CREATE EXTERNAL TABLE aggregate_test_100 (
c1 VARCHAR NOT NULL,
c2 TINYINT NOT NULL,
c3 SMALLINT NOT NULL,
c4 SMALLINT,
c5 INT,
c6 BIGINT NOT NULL,
c7 SMALLINT NOT NULL,
c8 INT NOT NULL,
c9 BIGINT UNSIGNED 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 './core/tests/data/aggregate_test_100_order_by_c1_asc.csv';
0 rows in set. Query took 0.003 seconds.
❯ CREATE TABLE ntile_table as SELECT NTILE(8) OVER (ORDER BY c4) as ntile_1,
NTILE(12) OVER (ORDER BY c12 DESC) AS ntile_2 FROM aggregate_test_100 LIMIT 10;
Error during planning: Mismatch between schema and batches
```
--
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]
