-
Notifications
You must be signed in to change notification settings - Fork 1.3k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Cannot import Time64 from CSV #3176
Comments
This should be fixed by apache/arrow-rs#3101 with the related arrow-rs version |
thank you @Jefffrey i think we could add some test cases later after arrow-rs new version upgraded ❯ select c2 from a;
+---------------------+
| c2 |
+---------------------+
| 2000-01-01T00:00:00 |
| 2000-01-01T00:00:00 |
| 2000-01-01T00:00:00 |
+---------------------+ |
Issue resolved with arrow-rs version upgraded jeffrey:~/Code/arrow-datafusion/datafusion-cli$ cat 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
jeffrey:~/Code/arrow-datafusion/datafusion-cli$ cargo run
Finished dev [unoptimized + debuginfo] target(s) in 0.11s
Running `/media/jeffrey/1tb_860evo_ssd/.cargo_target_cache/debug/datafusion-cli`
DataFusion CLI v15.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.001 seconds.
❯ select * from a;
+----+----------+---------------------+
| 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 |
+----+----------+---------------------+
3 rows in set. Query took 0.006 seconds.
❯ Would you still prefer some test cases be added, say to |
@alamb this issue looks like it can be closed |
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
Steps to reproduce the behavior:
create this
time.csv
the query for time doesn't work while timestamp works
Expected behavior
A clear and concise description of what you expected to happen.
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: