CODEWITHSUNDEEP
amazon-athena
somename
somename

Reputation: 968

How many values allowed in "In Clause" statement in Amazon Athena

Is there a limit on the number of values that can be passed in the "In Clause" of Amazon Athena query? Tried to look that up in the documentation but can not find any reference. Thank you.

For example Select * from tablename where columnName in (1,2,3..); -

How many values allowed to be passed in the IN CLAUSE of the above statement?

Upvotes: 1

Views: 4072

Answers (1)

Nicolas Busca
Nicolas Busca

Reputation: 1305

The only limitation is the length of the query, which is limited to 262144 bytes (or characters):

https://docs.aws.amazon.com/athena/latest/ug/service-limits.html

Upvotes: 3

Related Questions