MohamedAbdeen21 commented on issue #9785:
URL:
https://github.com/apache/arrow-datafusion/issues/9785#issuecomment-2019926129
I'm not sure what to do next regarding this. Do we just prevent the panic
and leave it at that? do we perform schema validation if the table exists?
Also keep in mind that if we only prevent the panic, queries such as the
following can make a table useless.
```sql
CREATE EXTERNAL TABLE test(name string) PARTITIONED BY (year string, month
string) STORED AS parquet LOCATION 'tmp/';
-- notice the different ordering in the PARTITIONED BY clause
INSERT INTO test VALUES('name', '2024', '03');
CREATE EXTERNAL TABLE test2(name string) PARTITIONED BY (month string, year
string) STORED AS parquet LOCATION 'tmp/';
-- now table have both partitions (year -> month and month -> year)
INSERT INTO test2 VALUES('name', '2024', '03');
-- both fail
SELECT * FROM test;
SELECT * FROM test2;
```
--
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]
