# SQL statement too large **URL:** \ **Category:** Elasticsearch\ **Tags:** elastic-stack-sql\ **Created:** [December 13, 2018, 10:58am UTC](https://discuss.elastic.co/t/sql-statement-too-large/160719 "2018-12-13T10:58:55Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Amr\_Abdeldayem](https://avatars.discourse-cdn.com/v4/letter/a/a698b9/32.png) [@Amr\_Abdeldayem](https://discuss.elastic.co/u/Amr_Abdeldayem)\ **Post date:** [December 13, 2018, 10:58am UTC](https://discuss.elastic.co/t/sql-statement-too-large/160719/1 "2018-12-13T10:58:55Z")
Caused by: java.sql.SQLSyntaxErrorException: line 7:51: SQL statement too large; halt parsing to prevent memory errors (stopped at depth 200) Method is JDBC driver and Sql query request: select count(\*) as count,mainBusinessProcessDefinitionKey.name as name from ksa\_request\_index where id in (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264,265,266,267,268,269,270,271,272,273,274,275,276,277,278,279,280,281,282,283,284,285,286,287,288,289,290,291,292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308,309,310,311,312,313,314,315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345,346,347,348,349,350,351,352,353,354,355,356,357,358,359,360,361,362,363,364,365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400) group by mainBusinessProcessDefinitionKey.name; ---
**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\ **Post date:** [December 13, 2018, 11:15am UTC](https://discuss.elastic.co/t/sql-statement-too-large/160719/2 "2018-12-13T11:15:20Z")
What does the SQL statement look like? ---
**Author:** ![Amr\_Abdeldayem](https://avatars.discourse-cdn.com/v4/letter/a/a698b9/32.png) [@Amr\_Abdeldayem](https://discuss.elastic.co/u/Amr_Abdeldayem)\ **Post date:** [December 13, 2018, 11:20am UTC](https://discuss.elastic.co/t/sql-statement-too-large/160719/3 "2018-12-13T11:20:06Z")
I added it in description ---
**Author:** ![nik9000](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nik9000/32/44947_2.png) [@nik9000](https://discuss.elastic.co/u/nik9000)\ **Post date:** [December 14, 2018, 10:05pm UTC](https://discuss.elastic.co/t/sql-statement-too-large/160719/4 "2018-12-14T22:05:55Z")
This protection exists because of the kind of parser that SQL uses and because of the "funny" state that the JVM can get into after a stack overflow. It isn't the amount of text but the size of that list. You may want to remove the duplicate elements from it. I'll ping the folks that work on SQL to have a look and see if there is anything they can do. ---
**Author:** ![costin](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/costin/32/44950_2.png) [@costin](https://discuss.elastic.co/u/costin)\ **Post date:** [December 15, 2018, 9:00am UTC](https://discuss.elastic.co/t/sql-statement-too-large/160719/5 "2018-12-15T09:00:12Z")
We're actively looking into the issue: [https://github.com/elastic/elasticsearch/issues/36592#issuecomment-447332326](https://github.com/elastic/elasticsearch/issues/36592#issuecomment-447332326) ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [January 12, 2019, 9:00am UTC](https://discuss.elastic.co/t/sql-statement-too-large/160719/6 "2019-01-12T09:00:13Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.