kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: kylin查询栈溢出异常
Date Wed, 03 Aug 2016 00:55:10 GMT
Hi, which version of Kylin are you running?

在 2016年8月2日 下午5:34,不疯不成魔 <single1228@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;
>
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "不疯不成魔";<single1228@qq.com>;
> 发送时间: 2016年8月2日(星期二) 下午3:50
> 收件人: "dev"<dev@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

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message