[QUESTION] query

[ashkryab]

Can I replace sqlite to hive (SELECT * USERS WHERE ID > 0 AND gender LIKE "male" OR name LIKE "%ohn%" SORT BY age DESC )

Or this plugin work only with key-valur pair?

[ashkryab]

why do you compare with sqlite?

[simc]

I compare it with SQLite because you can use Hive most of the time instead of SQLite.

You can do filtering in code. If you have a very large database and you need filtering, you should stick to SQLite.

[Nipodemos]

just to be sure, how much "very large" means?
1,000?
10,000?
100,000?
1,000,000?

i always wanted to know 😄

[simc]

Below 100,000 should be no problem for hive.

If your rely on filtering (which you have to do yourself), I wouldn't use more than 1000-5000.