Support Questions
Find answers, ask questions, and share your expertise

Phoenix IN clause limits

I am trying to determine the best practices for using the IN clause in Phoenix. Is there a practical (if not physical) limit to how many vales we should include? Would 1000 elements be OK? If we want to pull back result sets which match a couple thousand keys, we planned on batching the keys into sets of 1000 on the application side and passing that to Phoenix, but want to make sure we are not going to get bit.

Running HDP 2.4

0 REPLIES 0