[QUESTION] query about hive

[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.

[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 😄