[jira] [Created] (POOL-313) Code generation fails when running SQL expressions against a wide dataset (thousands of columns)

["Iaroslav Zeigerman (JIRA)" <ji...@apache.org>]

Iaroslav Zeigerman created POOL-313:
---------------------------------------

             Summary: Code generation fails when running SQL expressions against a wide dataset (thousands of columns)
                 Key: POOL-313
                 URL: https://issues.apache.org/jira/browse/POOL-313
             Project: Commons Pool
          Issue Type: Bug
    Affects Versions: 2.0
            Reporter: Iaroslav Zeigerman


When reading the CSV file that contains 1776 columns Spark and Janino fail to generate the code with message:
{noformat}
Constant pool has grown past JVM limit of 0xFFFF
{noformat}

When running a common select with all columns it's fine:
{code}
      val allCols = df.columns.map(c => col(c).as(c + "_alias"))
      val newDf = df.select(allCols: _*)
      newDf.show()
{code}

But when I invoke the describe method:
{code}
newDf.describe(allCols: _*)
{code}

it fails with the following stack trace:
{noformat}
	at org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$.org$apache$spark$sql$catalyst$expressions$codegen$CodeGenerator$$doCompile(CodeGenerator.scala:889)
	at org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$$anon$1.load(CodeGenerator.scala:941)
	at org.apache.spark.sql.catalyst.expressions.codegen.CodeGenerator$$anon$1.load(CodeGenerator.scala:938)
	at org.spark_project.guava.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3599)
	at org.spark_project.guava.cache.LocalCache$Segment.loadSync(LocalCache.java:2379)
	... 30 more
Caused by: org.codehaus.janino.JaninoRuntimeException: Constant pool has grown past JVM limit of 0xFFFF
	at org.codehaus.janino.util.ClassFile.addToConstantPool(ClassFile.java:402)
	at org.codehaus.janino.util.ClassFile.addConstantIntegerInfo(ClassFile.java:300)
	at org.codehaus.janino.UnitCompiler.addConstantIntegerInfo(UnitCompiler.java:10307)
	at org.codehaus.janino.UnitCompiler.pushConstant(UnitCompiler.java:8868)
	at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4346)
	at org.codehaus.janino.UnitCompiler.access$7100(UnitCompiler.java:185)
	at org.codehaus.janino.UnitCompiler$10.visitIntegerLiteral(UnitCompiler.java:3265)
	at org.codehaus.janino.Java$IntegerLiteral.accept(Java.java:4321)
	at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3290)
	at org.codehaus.janino.UnitCompiler.fakeCompile(UnitCompiler.java:2605)
	at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4362)
	at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3975)
	at org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:185)
	at org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3263)
	at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
	at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3290)
	at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4368)
	at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:2662)
	at org.codehaus.janino.UnitCompiler.access$4400(UnitCompiler.java:185)
	at org.codehaus.janino.UnitCompiler$7.visitMethodInvocation(UnitCompiler.java:2627)
	at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
	at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2654)
	at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1643)
....
{noformat}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)