Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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 ?


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.

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.