Which one is faster in Hive? "in" or "or"?

Question

"in" Example:

select * from t where something in ('a', 'b', 'c')

"or" Example:

select * from t where something='a' or something='b' or something='c'

Is there an efficiency difference between these two? Or they are the same under the hood?

They are going to be pretty much the same thing. – Gordon Linoff Feb 14 '19 at 02:26 — Gordon Linoff, Feb 14 '19 at 02:26

score 0 · Accepted Answer · answered Feb 14 '19 at 04:40

0

This depends largely on databases and optimizers. Best way to see explain plan for both queries. For smaller number of values it does not matter much but as number of values increases then IN clause usually outperforms OR.

This answer has great insight and comparison for different databases for in and or.

answered Feb 14 '19 at 04:40

Jainik

2,352
1
19
27

I'm gonna run some queries to see which one's faster. Thanks. – ruxtain Feb 14 '19 at 08:43

Which one is faster in Hive? "in" or "or"?

1 Answers1