alamb commented on issue #959: URL: https://github.com/apache/arrow-datafusion/issues/959#issuecomment-1873389955
Thanks @Jefffrey I also verified the query runs correctly using an explicitly created external table as well ```sql ❯ create external table test stored as parquet location 'flink.parquet'; 0 rows in set. Query took 0.003 seconds. ❯ select * from test order by reported_date desc; +--------------------------+----------------------+----------+-------------+ | system_time | reported_date | province | total_daily | +--------------------------+----------------------+----------+-------------+ | 2021-08-30T20:38:07.488Z | 2021-08-25T00:00:00Z | ON | 807 | | 2021-08-30T20:38:07.488Z | 2021-08-25T00:00:00Z | BC | 719 | | 2021-08-30T20:38:07.488Z | 2021-08-24T00:00:00Z | BC | 708 | | 2021-08-30T20:38:07.488Z | 2021-08-24T00:00:00Z | ON | 634 | | 2021-08-30T20:38:07.488Z | 2021-08-23T00:00:00Z | ON | 509 | | 2021-08-30T20:38:07.488Z | 2021-08-23T00:00:00Z | BC | 559 | | 2021-08-30T20:38:07.488Z | 2021-08-22T00:00:00Z | ON | 489 | | 2021-08-30T20:38:07.488Z | 2021-08-22T00:00:00Z | BC | 465 | | 2021-08-30T20:38:07.488Z | 2021-08-21T00:00:00Z | ON | 681 | | 2021-08-30T20:38:07.488Z | 2021-08-21T00:00:00Z | BC | 563 | | 2021-08-30T20:38:07.488Z | 2021-08-20T00:00:00Z | BC | 696 | | 2021-08-30T20:38:07.488Z | 2021-08-20T00:00:00Z | ON | 710 | | 2021-08-30T20:38:07.488Z | 2021-08-19T00:00:00Z | ON | 706 | | 2021-08-30T20:38:07.488Z | 2021-08-19T00:00:00Z | BC | 672 | | 2021-08-30T20:38:07.488Z | 2021-08-18T00:00:00Z | ON | 651 | | 2021-08-30T20:38:07.488Z | 2021-08-18T00:00:00Z | BC | 774 | | 2021-08-30T20:38:07.488Z | 2021-08-17T00:00:00Z | BC | 622 | | 2021-08-30T20:38:07.488Z | 2021-08-17T00:00:00Z | ON | 511 | | 2021-08-30T20:38:07.488Z | 2021-08-16T00:00:00Z | ON | 434 | | 2021-08-30T20:38:07.488Z | 2021-08-16T00:00:00Z | BC | 388 | | 2021-08-30T20:38:07.488Z | 2021-08-15T00:00:00Z | ON | 450 | | 2021-08-30T20:38:07.488Z | 2021-08-15T00:00:00Z | BC | 452 | | 2021-08-30T20:38:07.488Z | 2021-08-14T00:00:00Z | BC | 427 | | 2021-08-30T20:38:07.488Z | 2021-08-14T00:00:00Z | ON | 506 | | 2021-08-30T20:38:07.488Z | 2021-08-13T00:00:00Z | ON | 544 | | 2021-08-30T20:38:07.488Z | 2021-08-13T00:00:00Z | BC | 546 | | 2021-08-30T20:38:07.488Z | 2021-08-12T00:00:00Z | BC | 704 | | 2021-08-30T20:38:07.488Z | 2021-08-12T00:00:00Z | ON | 530 | | 2021-08-30T20:38:07.488Z | 2021-08-11T00:00:00Z | BC | 539 | | 2021-08-30T20:38:07.488Z | 2021-08-11T00:00:00Z | ON | 535 | | 2021-08-30T20:38:07.488Z | 2021-08-10T00:00:00Z | ON | 386 | | 2021-08-30T20:38:07.488Z | 2021-08-10T00:00:00Z | BC | 540 | | 2021-08-30T20:38:07.488Z | 2021-08-09T00:00:00Z | BC | 360 | | 2021-08-30T20:38:07.488Z | 2021-08-09T00:00:00Z | ON | 335 | | 2021-08-30T20:38:07.488Z | 2021-08-08T00:00:00Z | BC | 298 | | 2021-08-30T20:38:07.488Z | 2021-08-08T00:00:00Z | ON | 337 | | 2021-08-30T20:38:07.488Z | 2021-08-07T00:00:00Z | BC | 390 | | 2021-08-30T20:38:07.488Z | 2021-08-07T00:00:00Z | ON | 343 | | 2021-08-30T20:38:07.488Z | 2021-08-06T00:00:00Z | BC | 428 | | 2021-08-30T20:38:07.488Z | 2021-08-06T00:00:00Z | ON | 446 | | . | | . | | . | +--------------------------+----------------------+----------+-------------+ 1095 rows in set (40 shown). Query took 0.004 seconds. ``` -- 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]
