Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a CSV file which I am using as a database with LibreOffice DB.
What I'm doing is explained in detail in this answer.

I can do some operations, but when I try to enter the following into the SQL editor:

select SUM(Dollars) from original

I get the following error:

The query cannot be executed. It is too complex. Only Count(*) is supported.

So I think its an error from the ODBC or maybe JDBC driver. Where can I find a better driver for my MacBook OSX 10.7.2? Or what else should I do?

share|improve this question
up vote 1 down vote accepted

I think the problem is that the Base driver for file-based database drivers (i.e. those using csv files as databases) simply does not support most of the standard SQL aggregate functions. The best you can do is to keep the most current version installed and wait if you intend to stay with CSV format.

I would strongly suggest moving from CSV to a "real" database format such as LibreOffice's native database format. That will enable full use of SQL syntax. Instructions on how to do that are available here:

share|improve this answer
it was just a project for my brother, i didn't really want to mess with a full db app. But i guess its the right way to go. – patrickinmpls Oct 23 '13 at 23:36

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.