[GitHub] [arrow-datafusion] Jefffrey commented on issue #1999: Error occurs when only using partition columns in query

[GitBox <gi...@apache.org>]

Jefffrey commented on issue #1999:
URL: https://github.com/apache/arrow-datafusion/issues/1999#issuecomment-1313538875

   Issue seems resolves as of 96512ac05df40deb42632992cece656842d6debb as unable to reproduce:
   
   Created file structure as shown:
   
   ```
   jeffrey:~/tmpdata$ pwd
   /home/jeffrey/tmpdata
   jeffrey:~/tmpdata$ tree *test
   csvtest
   └── year=2021
       ├── month=09
       │   └── day=09
       │       └── time.csv
       └── month=10
           └── day=09
               └── time.csv
   parttest
   └── year=2021
       ├── month=09
       │   └── day=09
       │       └── part-0.parquet
       └── month=10
           └── day=09
               └── part-0.parquet
   ```
   
   Then selecting their partitioned columns:
   
   ```sql
   DataFusion CLI v14.0.0
   ❯ create external table parttest stored as parquet partitioned by (year, month, day) location '/home/jeffrey/tmpdata/parttest';
   0 rows in set. Query took 0.003 seconds.
   ❯ select distinct year, month, day from parttest;
   +------+-------+-----+
   | year | month | day |
   +------+-------+-----+
   | 2021 | 10    | 09  |
   | 2021 | 09    | 09  |
   +------+-------+-----+
   2 rows in set. Query took 0.105 seconds.
   ❯ create external table csvtest stored as csv partitioned by (year, month, day) location '/home/jeffrey/tmpdata/csvtest';
   0 rows in set. Query took 0.018 seconds.
   ❯ select distinct year, month, day from csvtest;
   +------+-------+-----+
   | year | month | day |
   +------+-------+-----+
   | 2021 | 09    | 09  |
   | 2021 | 10    | 09  |
   +------+-------+-----+
   2 rows in set. Query took 0.008 seconds.
   ```
   
   Can see selects fine with no errors.


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org