Cannot import Time64 from CSV #3176
Description
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
create this time.csv
c0,c1,c2
1,00:00:00,2000-01-01T00:00:00
2,00:01:00,2000-01-01T00:00:00
3,00:02:00,2000-01-01T00:00:00
the query for time doesn't work while timestamp works
DataFusion CLI v10.0.0
❯ create external table a (c0 int, c1 time, c2 timestamp) stored as csv with header row location 'time.csv';
0 rows in set. Query took 0.020 seconds.
❯ select c0 from a;
+----+
| c0 |
+----+
| 1 |
| 2 |
| 3 |
+----+
3 rows in set. Query took 0.039 seconds.
❯ select c1 from a;
ArrowError(ParseError("Unsupported data type Time64(Nanosecond)"))
❯ select c2 from a;
+---------------------+
| c2 |
+---------------------+
| 1999-12-31 16:00:00 |
| 1999-12-31 16:00:00 |
| 1999-12-31 16:00:00 |
+---------------------+
3 rows in set. Query took 0.009 seconds.Expected behavior
A clear and concise description of what you expected to happen.
Additional context
Add any other context about the problem here.