[CALCITE-5227] Janino upgrade breaks SELECTs with many projects causing JVM crashes

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.30.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Daniel Glöckner
• Created: 04/Aug/22 11:52
• Updated: 28/Feb/24 06:03

Description

In our case we have SELECTs with > 1000 project fields. You might say this is a bit crazy but this is how our data model looks like

We recently upgraded to Calcite 1.30 and noticed JVM crashes for such SELECTs.

After thorough analysis we found that the byte code produced by newer Janino versions is 350 times larger compared to the byte code produced by javac.

I created a unit test to reproduce the issue in Calcite code base: https://github.com/apache/calcite/commit/f4d4815dff5537c56b34b36794c71d7a9829eec6

The Janino issue is tracked here: https://github.com/janino-compiler/janino/issues/174

Issue Links

• is related to: CALCITE-3745 CompileException in UnitCompiler when using multiple class loaders
• is related to: CALCITE-5278 Upgrade Janino from 3.1.6 to 3.1.8
• relates to: CALCITE-5361 Upgrade janino version to 3.1.9
• links to: GitHub Pull Request #2900