Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

query with more than 20 OR conditions

query with more than 20 OR conditions

Expert Contributor

Hi all,

I have a question.... I have to query a 9 million row table with more than 40 columns... the query will check somany metrics in the WHERE condition like x>1 OR y>2.5 OR a>4 etc .... number of conditions are more than 20 .... this is taking forever when i run all together with a where clause and OR conidtions. ... what is the best way to do this ?


Re: query with more than 20 OR conditions

New Contributor

How long does your query take if the table is empty, or only has a few rows? If it still takes a long time, you might be seeing an optimizer performance bug.

Don't have an account?
Coming from Hortonworks? Activate your account here