Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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:

http://forum.openoffice.org/en/forum/viewtopic.php?f=13&t=58501#p258835

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
add comment

Your Answer

 
discard

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.