You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by 不疯不成魔 <si...@qq.com> on 2016/08/02 07:50:43 UTC
kylin查询栈溢出异常
您好!
万分感谢您能在百忙之中抽出空查阅我的邮件,谢谢!
在kylin的使用过程中,project、model、cube已经建立成功,但是在之后的使用中发现如下问题(具体日志请查阅附件一):
public Class getElementType() {
return java.lang.Object[].class;
}
at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
... 80 more
Caused by: org.codehaus.janino.JaninoRuntimeException: Baz$3.apply(): Operand stack overflow at offset 1052
at org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:490)
at org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:299)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2309)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:656)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:620)
at org.codehaus.janino.UnitCompiler.access$200(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$2.visitAnonymousClassDeclaration(UnitCompiler.java:343)
at org.codehaus.janino.Java$AnonymousClassDeclaration.accept(Java.java:894)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4194)
at org.codehaus.janino.UnitCompiler.access$7300(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitNewAnonymousClassInstance(UnitCompiler.java:3260)
at org.codehaus.janino.Java$NewAnonymousClassInstance.accept(Java.java:4131)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3952)
at org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
at org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
at org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1901)
at org.codehaus.janino.UnitCompiler.access$2100(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$4.visitReturnStatement(UnitCompiler.java:944)
at org.codehaus.janino.Java$ReturnStatement.accept(Java.java:2544)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:956)
at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:997)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2283)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:391)
at org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:345)
at org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1139)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:320)
at org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:383)
at org.codehaus.janino.ClassBodyEvaluator.compileToClass(ClassBodyEvaluator.java:315)
at org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:233)
at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:192)
at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:47)
at org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:340)
at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.getBindable(EnumerableInterpretable.java:140)
at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:105)
... 90 more
Re: kylin查询栈溢出异常
Posted by Yiming Liu <li...@gmail.com>.
The master branch has upgraded the Calcite version. You could try to build
by yourself.
2016-08-03 9:27 GMT+08:00 不疯不成魔 <si...@qq.com>:
> oh,thanks!I am looking forward to the next version!
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "ShaoFeng Shi";<sh...@apache.org>;
> 发送时间: 2016年8月3日(星期三) 上午9:17
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: Re: kylin查询栈溢出异常
>
>
>
> This is a bug in Apache Calcite:
> https://issues.apache.org/jira/browse/CALCITE-1097
> It has been fixed in Calcite 1.7, while Kylin 1.5.3 uses 1.6;
>
> When Kylin upgrade Calcite version, this problem will be solved.
>
> 在 2016年8月3日 上午8:58,不疯不成魔 <si...@qq.com>写道:
>
> > hi,the version is 1.5.3
> >
> >
> >
> >
> > ------------------ 原始邮件 ------------------
> > 发件人: "ShaoFeng Shi";<sh...@apache.org>;
> > 发送时间: 2016年8月3日(星期三) 上午8:55
> > 收件人: "dev"<de...@kylin.apache.org>;
> >
> > 主题: Re: kylin查询栈溢出异常
> >
> >
> >
> > Hi, which version of Kylin are you running?
> >
> > 在 2016年8月2日 下午5:34,不疯不成魔 <si...@qq.com>写道:
> >
> > > 上封邮件遗漏了测试过程,具体如下:
> > > 在"Insight"中进行sql语句查询的时候,发现如果聚合指标超过84个以后,就会报"Operand stack overflow at
> > > offset 1052"这类错误,我测试的query语句如下:
> > > select t2.org_level2_no,t2.org_level2_name,
> > >
> > >
> >
> sum(t1.p1),sum(t1.p2),sum(t1.p3),sum(t1.p4),sum(t1.p5),sum(t1.p6),sum(t1.p7),sum(t1.p8),sum(t1.p9),sum(t1.p10),
> > >
> > >
> >
> sum(t1.p11),sum(t1.p12),sum(t1.p13),sum(t1.p14),sum(t1.p15),sum(t1.p16),sum(t1.p17),sum(t1.p18),sum(t1.p19),sum(t1.p20),
> > >
> > >
> >
> sum(t1.p21),sum(t1.p22),sum(t1.p23),sum(t1.p24),sum(t1.p25),sum(t1.p26),sum(t1.p27),sum(t1.p28),sum(t1.p29),sum(t1.p30),
> > >
> > >
> >
> sum(t1.p31),sum(t1.p32),sum(t1.p33),sum(t1.p34),sum(t1.p35),sum(t1.p36),sum(t1.p37),sum(t1.p38),sum(t1.p39),sum(t1.p40),
> > >
> > >
> >
> sum(t1.p41),sum(t1.p42),sum(t1.p43),sum(t1.p44),sum(t1.p45),sum(t1.p46),sum(t1.p47),sum(t1.p48),sum(t1.p49),sum(t1.p50),
> > >
> > >
> >
> sum(t1.p51),sum(t1.p52),sum(t1.p53),sum(t1.p54),sum(t1.p55),sum(t1.p56),sum(t1.p57),sum(t1.p58),sum(t1.p59),sum(t1.p60),
> > >
> > >
> >
> sum(t1.p61),sum(t1.p62),sum(t1.p63),sum(t1.p64),sum(t1.p65),sum(t1.p66),sum(t1.p67),sum(t1.p68),sum(t1.p69),sum(t1.p70),
> > >
> > >
> >
> sum(t1.p71),sum(t1.p72),sum(t1.p73),sum(t1.p74),sum(t1.p75),sum(t1.p76),sum(t1.p77),sum(t1.p78),sum(t1.p79),sum(t1.p80),
> > >
> > >
> >
> sum(t1.p81),sum(t1.p82),sum(t1.p83),sum(t1.p84),sum(t1.p85),sum(t1.p86),sum(t1.p87),sum(t1.p88),sum(t1.p89),sum(t1.p90),
> > > sum(t1.p91),sum(t1.p92),sum(t1.p93),sum(t1.p94),sum(t1.p95),sum(t1.p96)
> > > from td_power_view t1
> > > join di_org_no t2 on t1.org_no = t2.org_level5_no
> > > where t1.record_time='20150404'
> > > group by t2.org_level2_no,t2.org_level2_name
> > > order by t2.org_level2_no;
> > >
> > >
> > >
> > >
> > >
> > > ------------------ 原始邮件 ------------------
> > > 发件人: "不疯不成魔";<si...@qq.com>;
> > > 发送时间: 2016年8月2日(星期二) 下午3:50
> > > 收件人: "dev"<de...@kylin.apache.org>;
> > >
> > > 主题: kylin查询栈溢出异常
> > >
> > >
> > >
> > > 您好!
> > > 万分感谢您能在百忙之中抽出空查阅我的邮件,谢谢!
> > > 在kylin的使用过程中,project、model、cube已经建立成功,但是在之后的使用中发现如下问题(具体日志请查阅附件一):
> > >
> > > public Class getElementType() {
> > > return java.lang.Object[].class;
> > > }
> > > at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
> > > at
> > >
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
> > > at
> > >
> >
> org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
> > > at
> > org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
> > > at
> > org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
> > > at
> > >
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
> > > at
> > >
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
> > > at
> > >
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
> > > at
> > >
> >
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
> > > at
> > >
> >
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
> > > at
> > >
> >
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
> > > at
> > >
> >
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
> > > ... 80 more
> > > Caused by: org.codehaus.janino.JaninoRuntimeException: Baz$3.apply():
> > > Operand stack overflow at offset 1052
> > > at
> > > org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:490)
> > > at
> > > org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:299)
> > > at
> > org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2309)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> > > at
> > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> > > at
> > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:656)
> > > at
> > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:620)
> > > at
> > > org.codehaus.janino.UnitCompiler.access$200(UnitCompiler.java:183)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler$2.visitAnonymousClassDeclaration(UnitCompiler.java:343)
> > > at
> > >
> org.codehaus.janino.Java$AnonymousClassDeclaration.accept(Java.java:894)
> > > at
> > org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4194)
> > > at
> > > org.codehaus.janino.UnitCompiler.access$7300(UnitCompiler.java:183)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler$10.visitNewAnonymousClassInstance(UnitCompiler.java:3260)
> > > at
> > >
> org.codehaus.janino.Java$NewAnonymousClassInstance.accept(Java.java:4131)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > > at
> > >
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3952)
> > > at
> > > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > > at
> > org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > > at
> > >
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> > > at
> > > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > > at
> > org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > > at
> > >
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> > > at
> > > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > > at
> > org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > > at
> > >
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > > at
> > > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1901)
> > > at
> > > org.codehaus.janino.UnitCompiler.access$2100(UnitCompiler.java:183)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler$4.visitReturnStatement(UnitCompiler.java:944)
> > > at
> > org.codehaus.janino.Java$ReturnStatement.accept(Java.java:2544)
> > > at
> > org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:956)
> > > at
> > >
> org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:997)
> > > at
> > org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2283)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> > > at
> > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> > > at
> > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:391)
> > > at
> > > org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:183)
> > > at
> > >
> >
> org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:345)
> > > at
> > >
> >
> org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1139)
> > > at
> > org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> > > at
> > > org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:320)
> > > at
> > >
> >
> org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:383)
> > > at
> > >
> >
> org.codehaus.janino.ClassBodyEvaluator.compileToClass(ClassBodyEvaluator.java:315)
> > > at
> > >
> org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:233)
> > > at
> > org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:192)
> > > at
> org.codehaus.commons.compiler.Cookable.cook(Cookable.java:47)
> > > at
> > >
> >
> org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:340)
> > > at
> > >
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.getBindable(EnumerableInterpretable.java:140)
> > > at
> > >
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:105)
> > > ... 90 more
> > >
> >
> >
> >
> > --
> > Best regards,
> >
> > Shaofeng Shi
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
--
With Warm regards
Yiming Liu (刘一鸣)
回复: kylin查询栈溢出异常
Posted by 不疯不成魔 <si...@qq.com>.
oh,thanks!I am looking forward to the next version!
------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi";<sh...@apache.org>;
发送时间: 2016年8月3日(星期三) 上午9:17
收件人: "dev"<de...@kylin.apache.org>;
主题: Re: kylin查询栈溢出异常
This is a bug in Apache Calcite:
https://issues.apache.org/jira/browse/CALCITE-1097
It has been fixed in Calcite 1.7, while Kylin 1.5.3 uses 1.6;
When Kylin upgrade Calcite version, this problem will be solved.
在 2016年8月3日 上午8:58,不疯不成魔 <si...@qq.com>写道:
> hi,the version is 1.5.3
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "ShaoFeng Shi";<sh...@apache.org>;
> 发送时间: 2016年8月3日(星期三) 上午8:55
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: Re: kylin查询栈溢出异常
>
>
>
> Hi, which version of Kylin are you running?
>
> 在 2016年8月2日 下午5:34,不疯不成魔 <si...@qq.com>写道:
>
> > 上封邮件遗漏了测试过程,具体如下:
> > 在"Insight"中进行sql语句查询的时候,发现如果聚合指标超过84个以后,就会报"Operand stack overflow at
> > offset 1052"这类错误,我测试的query语句如下:
> > select t2.org_level2_no,t2.org_level2_name,
> >
> >
> sum(t1.p1),sum(t1.p2),sum(t1.p3),sum(t1.p4),sum(t1.p5),sum(t1.p6),sum(t1.p7),sum(t1.p8),sum(t1.p9),sum(t1.p10),
> >
> >
> sum(t1.p11),sum(t1.p12),sum(t1.p13),sum(t1.p14),sum(t1.p15),sum(t1.p16),sum(t1.p17),sum(t1.p18),sum(t1.p19),sum(t1.p20),
> >
> >
> sum(t1.p21),sum(t1.p22),sum(t1.p23),sum(t1.p24),sum(t1.p25),sum(t1.p26),sum(t1.p27),sum(t1.p28),sum(t1.p29),sum(t1.p30),
> >
> >
> sum(t1.p31),sum(t1.p32),sum(t1.p33),sum(t1.p34),sum(t1.p35),sum(t1.p36),sum(t1.p37),sum(t1.p38),sum(t1.p39),sum(t1.p40),
> >
> >
> sum(t1.p41),sum(t1.p42),sum(t1.p43),sum(t1.p44),sum(t1.p45),sum(t1.p46),sum(t1.p47),sum(t1.p48),sum(t1.p49),sum(t1.p50),
> >
> >
> sum(t1.p51),sum(t1.p52),sum(t1.p53),sum(t1.p54),sum(t1.p55),sum(t1.p56),sum(t1.p57),sum(t1.p58),sum(t1.p59),sum(t1.p60),
> >
> >
> sum(t1.p61),sum(t1.p62),sum(t1.p63),sum(t1.p64),sum(t1.p65),sum(t1.p66),sum(t1.p67),sum(t1.p68),sum(t1.p69),sum(t1.p70),
> >
> >
> sum(t1.p71),sum(t1.p72),sum(t1.p73),sum(t1.p74),sum(t1.p75),sum(t1.p76),sum(t1.p77),sum(t1.p78),sum(t1.p79),sum(t1.p80),
> >
> >
> sum(t1.p81),sum(t1.p82),sum(t1.p83),sum(t1.p84),sum(t1.p85),sum(t1.p86),sum(t1.p87),sum(t1.p88),sum(t1.p89),sum(t1.p90),
> > sum(t1.p91),sum(t1.p92),sum(t1.p93),sum(t1.p94),sum(t1.p95),sum(t1.p96)
> > from td_power_view t1
> > join di_org_no t2 on t1.org_no = t2.org_level5_no
> > where t1.record_time='20150404'
> > group by t2.org_level2_no,t2.org_level2_name
> > order by t2.org_level2_no;
> >
> >
> >
> >
> >
> > ------------------ 原始邮件 ------------------
> > 发件人: "不疯不成魔";<si...@qq.com>;
> > 发送时间: 2016年8月2日(星期二) 下午3:50
> > 收件人: "dev"<de...@kylin.apache.org>;
> >
> > 主题: kylin查询栈溢出异常
> >
> >
> >
> > 您好!
> > 万分感谢您能在百忙之中抽出空查阅我的邮件,谢谢!
> > 在kylin的使用过程中,project、model、cube已经建立成功,但是在之后的使用中发现如下问题(具体日志请查阅附件一):
> >
> > public Class getElementType() {
> > return java.lang.Object[].class;
> > }
> > at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
> > at
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
> > at
> org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
> > at
> org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
> > at
> >
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
> > at
> >
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
> > at
> >
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
> > at
> >
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
> > ... 80 more
> > Caused by: org.codehaus.janino.JaninoRuntimeException: Baz$3.apply():
> > Operand stack overflow at offset 1052
> > at
> > org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:490)
> > at
> > org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:299)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2309)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:656)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:620)
> > at
> > org.codehaus.janino.UnitCompiler.access$200(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$2.visitAnonymousClassDeclaration(UnitCompiler.java:343)
> > at
> > org.codehaus.janino.Java$AnonymousClassDeclaration.accept(Java.java:894)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4194)
> > at
> > org.codehaus.janino.UnitCompiler.access$7300(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitNewAnonymousClassInstance(UnitCompiler.java:3260)
> > at
> > org.codehaus.janino.Java$NewAnonymousClassInstance.accept(Java.java:4131)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3952)
> > at
> > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > at
> org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> > at
> > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > at
> org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> > at
> > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > at
> org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1901)
> > at
> > org.codehaus.janino.UnitCompiler.access$2100(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$4.visitReturnStatement(UnitCompiler.java:944)
> > at
> org.codehaus.janino.Java$ReturnStatement.accept(Java.java:2544)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:956)
> > at
> > org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:997)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2283)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:391)
> > at
> > org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:345)
> > at
> >
> org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1139)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> > at
> > org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:320)
> > at
> >
> org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:383)
> > at
> >
> org.codehaus.janino.ClassBodyEvaluator.compileToClass(ClassBodyEvaluator.java:315)
> > at
> > org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:233)
> > at
> org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:192)
> > at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:47)
> > at
> >
> org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:340)
> > at
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.getBindable(EnumerableInterpretable.java:140)
> > at
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:105)
> > ... 90 more
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
--
Best regards,
Shaofeng Shi
Re: kylin查询栈溢出异常
Posted by ShaoFeng Shi <sh...@apache.org>.
This is a bug in Apache Calcite:
https://issues.apache.org/jira/browse/CALCITE-1097
It has been fixed in Calcite 1.7, while Kylin 1.5.3 uses 1.6;
When Kylin upgrade Calcite version, this problem will be solved.
在 2016年8月3日 上午8:58,不疯不成魔 <si...@qq.com>写道:
> hi,the version is 1.5.3
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "ShaoFeng Shi";<sh...@apache.org>;
> 发送时间: 2016年8月3日(星期三) 上午8:55
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: Re: kylin查询栈溢出异常
>
>
>
> Hi, which version of Kylin are you running?
>
> 在 2016年8月2日 下午5:34,不疯不成魔 <si...@qq.com>写道:
>
> > 上封邮件遗漏了测试过程,具体如下:
> > 在"Insight"中进行sql语句查询的时候,发现如果聚合指标超过84个以后,就会报"Operand stack overflow at
> > offset 1052"这类错误,我测试的query语句如下:
> > select t2.org_level2_no,t2.org_level2_name,
> >
> >
> sum(t1.p1),sum(t1.p2),sum(t1.p3),sum(t1.p4),sum(t1.p5),sum(t1.p6),sum(t1.p7),sum(t1.p8),sum(t1.p9),sum(t1.p10),
> >
> >
> sum(t1.p11),sum(t1.p12),sum(t1.p13),sum(t1.p14),sum(t1.p15),sum(t1.p16),sum(t1.p17),sum(t1.p18),sum(t1.p19),sum(t1.p20),
> >
> >
> sum(t1.p21),sum(t1.p22),sum(t1.p23),sum(t1.p24),sum(t1.p25),sum(t1.p26),sum(t1.p27),sum(t1.p28),sum(t1.p29),sum(t1.p30),
> >
> >
> sum(t1.p31),sum(t1.p32),sum(t1.p33),sum(t1.p34),sum(t1.p35),sum(t1.p36),sum(t1.p37),sum(t1.p38),sum(t1.p39),sum(t1.p40),
> >
> >
> sum(t1.p41),sum(t1.p42),sum(t1.p43),sum(t1.p44),sum(t1.p45),sum(t1.p46),sum(t1.p47),sum(t1.p48),sum(t1.p49),sum(t1.p50),
> >
> >
> sum(t1.p51),sum(t1.p52),sum(t1.p53),sum(t1.p54),sum(t1.p55),sum(t1.p56),sum(t1.p57),sum(t1.p58),sum(t1.p59),sum(t1.p60),
> >
> >
> sum(t1.p61),sum(t1.p62),sum(t1.p63),sum(t1.p64),sum(t1.p65),sum(t1.p66),sum(t1.p67),sum(t1.p68),sum(t1.p69),sum(t1.p70),
> >
> >
> sum(t1.p71),sum(t1.p72),sum(t1.p73),sum(t1.p74),sum(t1.p75),sum(t1.p76),sum(t1.p77),sum(t1.p78),sum(t1.p79),sum(t1.p80),
> >
> >
> sum(t1.p81),sum(t1.p82),sum(t1.p83),sum(t1.p84),sum(t1.p85),sum(t1.p86),sum(t1.p87),sum(t1.p88),sum(t1.p89),sum(t1.p90),
> > sum(t1.p91),sum(t1.p92),sum(t1.p93),sum(t1.p94),sum(t1.p95),sum(t1.p96)
> > from td_power_view t1
> > join di_org_no t2 on t1.org_no = t2.org_level5_no
> > where t1.record_time='20150404'
> > group by t2.org_level2_no,t2.org_level2_name
> > order by t2.org_level2_no;
> >
> >
> >
> >
> >
> > ------------------ 原始邮件 ------------------
> > 发件人: "不疯不成魔";<si...@qq.com>;
> > 发送时间: 2016年8月2日(星期二) 下午3:50
> > 收件人: "dev"<de...@kylin.apache.org>;
> >
> > 主题: kylin查询栈溢出异常
> >
> >
> >
> > 您好!
> > 万分感谢您能在百忙之中抽出空查阅我的邮件,谢谢!
> > 在kylin的使用过程中,project、model、cube已经建立成功,但是在之后的使用中发现如下问题(具体日志请查阅附件一):
> >
> > public Class getElementType() {
> > return java.lang.Object[].class;
> > }
> > at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
> > at
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
> > at
> org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
> > at
> org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
> > at
> >
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
> > at
> >
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
> > at
> >
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
> > at
> >
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
> > at
> >
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
> > ... 80 more
> > Caused by: org.codehaus.janino.JaninoRuntimeException: Baz$3.apply():
> > Operand stack overflow at offset 1052
> > at
> > org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:490)
> > at
> > org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:299)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2309)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:656)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:620)
> > at
> > org.codehaus.janino.UnitCompiler.access$200(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$2.visitAnonymousClassDeclaration(UnitCompiler.java:343)
> > at
> > org.codehaus.janino.Java$AnonymousClassDeclaration.accept(Java.java:894)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4194)
> > at
> > org.codehaus.janino.UnitCompiler.access$7300(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitNewAnonymousClassInstance(UnitCompiler.java:3260)
> > at
> > org.codehaus.janino.Java$NewAnonymousClassInstance.accept(Java.java:4131)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3952)
> > at
> > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > at
> org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> > at
> > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > at
> org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> > at
> > org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> > at
> org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> > at
> > org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> > at
> > org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> > at
> > org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1901)
> > at
> > org.codehaus.janino.UnitCompiler.access$2100(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$4.visitReturnStatement(UnitCompiler.java:944)
> > at
> org.codehaus.janino.Java$ReturnStatement.accept(Java.java:2544)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:956)
> > at
> > org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:997)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2283)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> > at
> >
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> > at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:391)
> > at
> > org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:183)
> > at
> >
> org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:345)
> > at
> >
> org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1139)
> > at
> org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> > at
> > org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:320)
> > at
> >
> org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:383)
> > at
> >
> org.codehaus.janino.ClassBodyEvaluator.compileToClass(ClassBodyEvaluator.java:315)
> > at
> > org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:233)
> > at
> org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:192)
> > at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:47)
> > at
> >
> org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:340)
> > at
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.getBindable(EnumerableInterpretable.java:140)
> > at
> >
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:105)
> > ... 90 more
> >
>
>
>
> --
> Best regards,
>
> Shaofeng Shi
>
--
Best regards,
Shaofeng Shi
回复: kylin查询栈溢出异常
Posted by 不疯不成魔 <si...@qq.com>.
hi,the version is 1.5.3
------------------ 原始邮件 ------------------
发件人: "ShaoFeng Shi";<sh...@apache.org>;
发送时间: 2016年8月3日(星期三) 上午8:55
收件人: "dev"<de...@kylin.apache.org>;
主题: Re: kylin查询栈溢出异常
Hi, which version of Kylin are you running?
在 2016年8月2日 下午5:34,不疯不成魔 <si...@qq.com>写道:
> 上封邮件遗漏了测试过程,具体如下:
> 在"Insight"中进行sql语句查询的时候,发现如果聚合指标超过84个以后,就会报"Operand stack overflow at
> offset 1052"这类错误,我测试的query语句如下:
> select t2.org_level2_no,t2.org_level2_name,
>
> sum(t1.p1),sum(t1.p2),sum(t1.p3),sum(t1.p4),sum(t1.p5),sum(t1.p6),sum(t1.p7),sum(t1.p8),sum(t1.p9),sum(t1.p10),
>
> sum(t1.p11),sum(t1.p12),sum(t1.p13),sum(t1.p14),sum(t1.p15),sum(t1.p16),sum(t1.p17),sum(t1.p18),sum(t1.p19),sum(t1.p20),
>
> sum(t1.p21),sum(t1.p22),sum(t1.p23),sum(t1.p24),sum(t1.p25),sum(t1.p26),sum(t1.p27),sum(t1.p28),sum(t1.p29),sum(t1.p30),
>
> sum(t1.p31),sum(t1.p32),sum(t1.p33),sum(t1.p34),sum(t1.p35),sum(t1.p36),sum(t1.p37),sum(t1.p38),sum(t1.p39),sum(t1.p40),
>
> sum(t1.p41),sum(t1.p42),sum(t1.p43),sum(t1.p44),sum(t1.p45),sum(t1.p46),sum(t1.p47),sum(t1.p48),sum(t1.p49),sum(t1.p50),
>
> sum(t1.p51),sum(t1.p52),sum(t1.p53),sum(t1.p54),sum(t1.p55),sum(t1.p56),sum(t1.p57),sum(t1.p58),sum(t1.p59),sum(t1.p60),
>
> sum(t1.p61),sum(t1.p62),sum(t1.p63),sum(t1.p64),sum(t1.p65),sum(t1.p66),sum(t1.p67),sum(t1.p68),sum(t1.p69),sum(t1.p70),
>
> sum(t1.p71),sum(t1.p72),sum(t1.p73),sum(t1.p74),sum(t1.p75),sum(t1.p76),sum(t1.p77),sum(t1.p78),sum(t1.p79),sum(t1.p80),
>
> sum(t1.p81),sum(t1.p82),sum(t1.p83),sum(t1.p84),sum(t1.p85),sum(t1.p86),sum(t1.p87),sum(t1.p88),sum(t1.p89),sum(t1.p90),
> sum(t1.p91),sum(t1.p92),sum(t1.p93),sum(t1.p94),sum(t1.p95),sum(t1.p96)
> from td_power_view t1
> join di_org_no t2 on t1.org_no = t2.org_level5_no
> where t1.record_time='20150404'
> group by t2.org_level2_no,t2.org_level2_name
> order by t2.org_level2_no;
>
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "不疯不成魔";<si...@qq.com>;
> 发送时间: 2016年8月2日(星期二) 下午3:50
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: kylin查询栈溢出异常
>
>
>
> 您好!
> 万分感谢您能在百忙之中抽出空查阅我的邮件,谢谢!
> 在kylin的使用过程中,project、model、cube已经建立成功,但是在之后的使用中发现如下问题(具体日志请查阅附件一):
>
> public Class getElementType() {
> return java.lang.Object[].class;
> }
> at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
> at
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
> at
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
> at
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
> ... 80 more
> Caused by: org.codehaus.janino.JaninoRuntimeException: Baz$3.apply():
> Operand stack overflow at offset 1052
> at
> org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:490)
> at
> org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:299)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2309)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:656)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:620)
> at
> org.codehaus.janino.UnitCompiler.access$200(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$2.visitAnonymousClassDeclaration(UnitCompiler.java:343)
> at
> org.codehaus.janino.Java$AnonymousClassDeclaration.accept(Java.java:894)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4194)
> at
> org.codehaus.janino.UnitCompiler.access$7300(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitNewAnonymousClassInstance(UnitCompiler.java:3260)
> at
> org.codehaus.janino.Java$NewAnonymousClassInstance.accept(Java.java:4131)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3952)
> at
> org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> at
> org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> at
> org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1901)
> at
> org.codehaus.janino.UnitCompiler.access$2100(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$4.visitReturnStatement(UnitCompiler.java:944)
> at org.codehaus.janino.Java$ReturnStatement.accept(Java.java:2544)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:956)
> at
> org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:997)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2283)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:391)
> at
> org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:345)
> at
> org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1139)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> at
> org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:320)
> at
> org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:383)
> at
> org.codehaus.janino.ClassBodyEvaluator.compileToClass(ClassBodyEvaluator.java:315)
> at
> org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:233)
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:192)
> at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:47)
> at
> org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:340)
> at
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.getBindable(EnumerableInterpretable.java:140)
> at
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:105)
> ... 90 more
>
--
Best regards,
Shaofeng Shi
Re: kylin查询栈溢出异常
Posted by ShaoFeng Shi <sh...@apache.org>.
Hi, which version of Kylin are you running?
在 2016年8月2日 下午5:34,不疯不成魔 <si...@qq.com>写道:
> 上封邮件遗漏了测试过程,具体如下:
> 在"Insight"中进行sql语句查询的时候,发现如果聚合指标超过84个以后,就会报"Operand stack overflow at
> offset 1052"这类错误,我测试的query语句如下:
> select t2.org_level2_no,t2.org_level2_name,
>
> sum(t1.p1),sum(t1.p2),sum(t1.p3),sum(t1.p4),sum(t1.p5),sum(t1.p6),sum(t1.p7),sum(t1.p8),sum(t1.p9),sum(t1.p10),
>
> sum(t1.p11),sum(t1.p12),sum(t1.p13),sum(t1.p14),sum(t1.p15),sum(t1.p16),sum(t1.p17),sum(t1.p18),sum(t1.p19),sum(t1.p20),
>
> sum(t1.p21),sum(t1.p22),sum(t1.p23),sum(t1.p24),sum(t1.p25),sum(t1.p26),sum(t1.p27),sum(t1.p28),sum(t1.p29),sum(t1.p30),
>
> sum(t1.p31),sum(t1.p32),sum(t1.p33),sum(t1.p34),sum(t1.p35),sum(t1.p36),sum(t1.p37),sum(t1.p38),sum(t1.p39),sum(t1.p40),
>
> sum(t1.p41),sum(t1.p42),sum(t1.p43),sum(t1.p44),sum(t1.p45),sum(t1.p46),sum(t1.p47),sum(t1.p48),sum(t1.p49),sum(t1.p50),
>
> sum(t1.p51),sum(t1.p52),sum(t1.p53),sum(t1.p54),sum(t1.p55),sum(t1.p56),sum(t1.p57),sum(t1.p58),sum(t1.p59),sum(t1.p60),
>
> sum(t1.p61),sum(t1.p62),sum(t1.p63),sum(t1.p64),sum(t1.p65),sum(t1.p66),sum(t1.p67),sum(t1.p68),sum(t1.p69),sum(t1.p70),
>
> sum(t1.p71),sum(t1.p72),sum(t1.p73),sum(t1.p74),sum(t1.p75),sum(t1.p76),sum(t1.p77),sum(t1.p78),sum(t1.p79),sum(t1.p80),
>
> sum(t1.p81),sum(t1.p82),sum(t1.p83),sum(t1.p84),sum(t1.p85),sum(t1.p86),sum(t1.p87),sum(t1.p88),sum(t1.p89),sum(t1.p90),
> sum(t1.p91),sum(t1.p92),sum(t1.p93),sum(t1.p94),sum(t1.p95),sum(t1.p96)
> from td_power_view t1
> join di_org_no t2 on t1.org_no = t2.org_level5_no
> where t1.record_time='20150404'
> group by t2.org_level2_no,t2.org_level2_name
> order by t2.org_level2_no;
>
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "不疯不成魔";<si...@qq.com>;
> 发送时间: 2016年8月2日(星期二) 下午3:50
> 收件人: "dev"<de...@kylin.apache.org>;
>
> 主题: kylin查询栈溢出异常
>
>
>
> 您好!
> 万分感谢您能在百忙之中抽出空查阅我的邮件,谢谢!
> 在kylin的使用过程中,project、model、cube已经建立成功,但是在之后的使用中发现如下问题(具体日志请查阅附件一):
>
> public Class getElementType() {
> return java.lang.Object[].class;
> }
> at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
> at
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
> at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
> at
> org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
> at
> org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
> at
> org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
> at
> org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
> at
> org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
> ... 80 more
> Caused by: org.codehaus.janino.JaninoRuntimeException: Baz$3.apply():
> Operand stack overflow at offset 1052
> at
> org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:490)
> at
> org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:299)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2309)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:656)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:620)
> at
> org.codehaus.janino.UnitCompiler.access$200(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$2.visitAnonymousClassDeclaration(UnitCompiler.java:343)
> at
> org.codehaus.janino.Java$AnonymousClassDeclaration.accept(Java.java:894)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4194)
> at
> org.codehaus.janino.UnitCompiler.access$7300(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitNewAnonymousClassInstance(UnitCompiler.java:3260)
> at
> org.codehaus.janino.Java$NewAnonymousClassInstance.accept(Java.java:4131)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3952)
> at
> org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> at
> org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
> at
> org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
> at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
> at
> org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
> at
> org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
> at
> org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1901)
> at
> org.codehaus.janino.UnitCompiler.access$2100(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$4.visitReturnStatement(UnitCompiler.java:944)
> at org.codehaus.janino.Java$ReturnStatement.accept(Java.java:2544)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:956)
> at
> org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:997)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2283)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
> at
> org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
> at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:391)
> at
> org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:183)
> at
> org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:345)
> at
> org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1139)
> at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
> at
> org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:320)
> at
> org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:383)
> at
> org.codehaus.janino.ClassBodyEvaluator.compileToClass(ClassBodyEvaluator.java:315)
> at
> org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:233)
> at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:192)
> at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:47)
> at
> org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:340)
> at
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.getBindable(EnumerableInterpretable.java:140)
> at
> org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:105)
> ... 90 more
>
--
Best regards,
Shaofeng Shi
回复:kylin查询栈溢出异常
Posted by 不疯不成魔 <si...@qq.com>.
上封邮件遗漏了测试过程,具体如下:
在"Insight"中进行sql语句查询的时候,发现如果聚合指标超过84个以后,就会报"Operand stack overflow at offset 1052"这类错误,我测试的query语句如下:
select t2.org_level2_no,t2.org_level2_name,
sum(t1.p1),sum(t1.p2),sum(t1.p3),sum(t1.p4),sum(t1.p5),sum(t1.p6),sum(t1.p7),sum(t1.p8),sum(t1.p9),sum(t1.p10),
sum(t1.p11),sum(t1.p12),sum(t1.p13),sum(t1.p14),sum(t1.p15),sum(t1.p16),sum(t1.p17),sum(t1.p18),sum(t1.p19),sum(t1.p20),
sum(t1.p21),sum(t1.p22),sum(t1.p23),sum(t1.p24),sum(t1.p25),sum(t1.p26),sum(t1.p27),sum(t1.p28),sum(t1.p29),sum(t1.p30),
sum(t1.p31),sum(t1.p32),sum(t1.p33),sum(t1.p34),sum(t1.p35),sum(t1.p36),sum(t1.p37),sum(t1.p38),sum(t1.p39),sum(t1.p40),
sum(t1.p41),sum(t1.p42),sum(t1.p43),sum(t1.p44),sum(t1.p45),sum(t1.p46),sum(t1.p47),sum(t1.p48),sum(t1.p49),sum(t1.p50),
sum(t1.p51),sum(t1.p52),sum(t1.p53),sum(t1.p54),sum(t1.p55),sum(t1.p56),sum(t1.p57),sum(t1.p58),sum(t1.p59),sum(t1.p60),
sum(t1.p61),sum(t1.p62),sum(t1.p63),sum(t1.p64),sum(t1.p65),sum(t1.p66),sum(t1.p67),sum(t1.p68),sum(t1.p69),sum(t1.p70),
sum(t1.p71),sum(t1.p72),sum(t1.p73),sum(t1.p74),sum(t1.p75),sum(t1.p76),sum(t1.p77),sum(t1.p78),sum(t1.p79),sum(t1.p80),
sum(t1.p81),sum(t1.p82),sum(t1.p83),sum(t1.p84),sum(t1.p85),sum(t1.p86),sum(t1.p87),sum(t1.p88),sum(t1.p89),sum(t1.p90),
sum(t1.p91),sum(t1.p92),sum(t1.p93),sum(t1.p94),sum(t1.p95),sum(t1.p96)
from td_power_view t1
join di_org_no t2 on t1.org_no = t2.org_level5_no
where t1.record_time='20150404'
group by t2.org_level2_no,t2.org_level2_name
order by t2.org_level2_no;
------------------ 原始邮件 ------------------
发件人: "不疯不成魔";<si...@qq.com>;
发送时间: 2016年8月2日(星期二) 下午3:50
收件人: "dev"<de...@kylin.apache.org>;
主题: kylin查询栈溢出异常
您好!
万分感谢您能在百忙之中抽出空查阅我的邮件,谢谢!
在kylin的使用过程中,project、model、cube已经建立成功,但是在之后的使用中发现如下问题(具体日志请查阅附件一):
public Class getElementType() {
return java.lang.Object[].class;
}
at org.apache.calcite.avatica.Helper.wrap(Helper.java:37)
at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:108)
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1171)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:297)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:196)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:721)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:588)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:558)
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:214)
at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:573)
at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
... 80 more
Caused by: org.codehaus.janino.JaninoRuntimeException: Baz$3.apply(): Operand stack overflow at offset 1052
at org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:490)
at org.codehaus.janino.CodeContext.flowAnalysis(CodeContext.java:299)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2309)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:656)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:620)
at org.codehaus.janino.UnitCompiler.access$200(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$2.visitAnonymousClassDeclaration(UnitCompiler.java:343)
at org.codehaus.janino.Java$AnonymousClassDeclaration.accept(Java.java:894)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:4194)
at org.codehaus.janino.UnitCompiler.access$7300(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitNewAnonymousClassInstance(UnitCompiler.java:3260)
at org.codehaus.janino.Java$NewAnonymousClassInstance.accept(Java.java:4131)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3952)
at org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
at org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compileGet2(UnitCompiler.java:3904)
at org.codehaus.janino.UnitCompiler.access$6900(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$10.visitMethodInvocation(UnitCompiler.java:3251)
at org.codehaus.janino.Java$MethodInvocation.accept(Java.java:3974)
at org.codehaus.janino.UnitCompiler.compileGet(UnitCompiler.java:3278)
at org.codehaus.janino.UnitCompiler.compileGetValue(UnitCompiler.java:4345)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:1901)
at org.codehaus.janino.UnitCompiler.access$2100(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$4.visitReturnStatement(UnitCompiler.java:944)
at org.codehaus.janino.Java$ReturnStatement.accept(Java.java:2544)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:956)
at org.codehaus.janino.UnitCompiler.compileStatements(UnitCompiler.java:997)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:2283)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:820)
at org.codehaus.janino.UnitCompiler.compileDeclaredMethods(UnitCompiler.java:792)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:505)
at org.codehaus.janino.UnitCompiler.compile2(UnitCompiler.java:391)
at org.codehaus.janino.UnitCompiler.access$400(UnitCompiler.java:183)
at org.codehaus.janino.UnitCompiler$2.visitPackageMemberClassDeclaration(UnitCompiler.java:345)
at org.codehaus.janino.Java$PackageMemberClassDeclaration.accept(Java.java:1139)
at org.codehaus.janino.UnitCompiler.compile(UnitCompiler.java:352)
at org.codehaus.janino.UnitCompiler.compileUnit(UnitCompiler.java:320)
at org.codehaus.janino.SimpleCompiler.compileToClassLoader(SimpleCompiler.java:383)
at org.codehaus.janino.ClassBodyEvaluator.compileToClass(ClassBodyEvaluator.java:315)
at org.codehaus.janino.ClassBodyEvaluator.cook(ClassBodyEvaluator.java:233)
at org.codehaus.janino.SimpleCompiler.cook(SimpleCompiler.java:192)
at org.codehaus.commons.compiler.Cookable.cook(Cookable.java:47)
at org.codehaus.janino.ClassBodyEvaluator.createInstance(ClassBodyEvaluator.java:340)
at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.getBindable(EnumerableInterpretable.java:140)
at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:105)
... 90 more