Query failed: line 1:1: statement is too large (stack overflow while parsing)

Presto
Teradata Employee

Query failed: line 1:1: statement is too large (stack overflow while parsing)

Large In-list SQL with more than 1000 Values in in-list is giving Failure using QG 02.02 and Presto(teradata) 0.157.t.

 

SELECT Failed.  [9134] Error: 20107 (6bb82d97-38ac-4171-bec6-000000000030) Error occurred while executing the Import Query. [Teradata][Presto](100050) Query failed: line 1:1: statement is too large (stack overflow while parsing).

 

When "select-SQL" is submitted from Teradata via QG 02.02, Its is internally submitting Create Table TEMP as <select SQL>.  It is failing with above error.

I see this error is being generated from Presto (Not sure though) from below lines of code.

    https://github.com/prestodb/presto/blob/master/presto-parser/src/main/java/com/facebook/presto/sql/p...

 

Is there any parameter, that can adjust SQL Text Length in Presto?

1 REPLY
Teradata Employee

Re: Query failed: line 1:1: statement is too large (stack overflow while parsing)

Unfortunately there is no setting to adjust the allowed SQL text length. You can however try to adjust the stack space used by the Presto JVM by adding the following JVM parameter to Presto's jvm.config: -Xss:512K (I believe the default for Linux is 256K).