It turns out that you can have more than 80,000 parameters in a prepared 
statement.

From: Jon Strayer <jstra...@proofpoint.com>
Reply-To: "user@phoenix.apache.org" <user@phoenix.apache.org>
Date: Friday, August 9, 2019 at 6:40 PM
To: "user@phoenix.apache.org" <user@phoenix.apache.org>
Subject: Maximum sql string length

We’ve been querying one table and then creating a query against another table 
using a prepared statement with a very large number of parameters in a IN 
clause.  A code review brought up a very good question, is there a limit to the 
size of the IN clause?  Or, is there a limit to the size of the SQL use to 
create a prepared statement.

I assume there is some limit, but is it “well, how much memory do you have?” 
Or, “we have a 64k buffer”?


Reply via email to