Since Hadoop came out, there have been various commercial and/or open-source attempts to expose some compatibility with SQL.

I am seeking one which is good for low-latency querying, and supports the most common CRUD, including [the basics!] along these lines: CREATE TABLE, INSERT INTO, SELECT * FROM, UPDATE Table SET C1=2 WHERE, DELETE FROM, and DROP TABLE.

I will be utilising them from Python, however there does seem to be a Python JDBC wrapper. Additionally it needs to be scalable for big and small data (starting on a single-node "cluster").

Here is what I've found thus far:

Which—from this list or elsewhere—would you recommend, and why?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.