search

shshemi / tabiew

A lightweight TUI application to view and query tabular data files, such as CSV, TSV, or parquet.
MIT License
540 stars 14 forks source link

:reset fails with "sql parser error: ..." #23

Open dolzenko opened 1 week ago

dolzenko commented 1 week ago

I opened my file, performed :S min(my_column) command, it worked, but getting back to original state with :reset is not working for me, fails with sql parser error: Expected: identifier, found: 2024.11 at Line: 1, Column: 15 instead.

Thanks for the great project btw :heart:

shshemi commented 1 week ago

Hey, Thank you for reporting. Would you kindly share the name of the file that you opened with Tabiew?

technologicalsingularity commented 1 week ago

Hey everybody, I'm try to: Q SELECT * FROM 2024-11-13_08-39-53.830246501 WHERE ra = '10.10.10.12'. This is jsonl file named 2024-11-13_08-39-53.830246501 (without file extension). I have error: sql parser error: Expected: identifier, found: 2024 at Line: 1, Column: 15. But sequence of S,F,O works fine. There is not first time where I have errors with polars-sql (in my other projects). How to force polars-sql work (may be I do not understand something).

dolzenko commented 1 week ago

Yes, my file name is 2024.11.11.pa

shshemi commented 1 week ago

Yes, my file name is 2024.11.11.pa

The bug is fixed, and will work as expected in the next release.

shshemi commented 1 week ago

, I'm try to: Q SELECT * FROM 2024-11-13_08-39-53.830246501 WHERE ra = '10.10.10.12'.

Please, try to execute your query as follow:

SELECT * FROM '2024-11-13_08-39-53.830246501' WHERE ra = '10.10.10.12'
shshemi commented 1 week ago

The problem is now fixed in version 0.7.1