CODEWITHSUNDEEP
questdb
funnymay
funnymay

Reputation: 391

How do I query a CSV dataset that's been imported?

I have imported data from CSV into Questdb using the web console but I can't query any values from it. I can see it in the list of tables but if I run something like this:

select * from imported-data.csv;

I get an error saying:

function, literal or constant is expected

Upvotes: 1

Views: 72

Answers (1)

Brian Smith
Brian Smith

Reputation: 1315

If the table hasn't been renamed, you have to escape the filename with singlequotes, i.e.:

select * from 'imported-data.csv';

And if you want to rename the table to something else, you can also easily do this with RENAME:

RENAME TABLE 'imported-data.csv' TO 'newTable';

Upvotes: 1

Related Questions