harelba / q

q - Run SQL directly on delimited files and multi-file sqlite databases
http://harelba.github.io/q/
GNU General Public License v3.0
10.19k stars 421 forks source link

query error: no such table: #247

Closed Dialga closed 3 years ago

Dialga commented 3 years ago

select * from file.csv works but select*from file.csv doesn't work, which works in sqlite.

harelba commented 3 years ago

true, and interesting. I'll do some testing.

harelba commented 3 years ago

This is a limitation because of the way q parses the sql queries (It expects a space before the FROM part).

This would work:

q "select* from aaa"

There are no plans to fix this, as this is very complicated relative to the gain.