You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Billy Liu (JIRA)" <ji...@apache.org> on 2018/03/20 01:51:00 UTC
[jira] [Commented] (KYLIN-3297) sql在解析>大值 and <小值的时候,kylin出现内存溢出。
[ https://issues.apache.org/jira/browse/KYLIN-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16405687#comment-16405687 ]
Billy Liu commented on KYLIN-3297:
----------------------------------
Hi [~xer001], thank you for reporting issue. Could you reproduce this issue against the sample cube? It will help other developers identify the root cause more efficiently.
> sql在解析>大值 and <小值的时候,kylin出现内存溢出。
> ---------------------------------
>
> Key: KYLIN-3297
> URL: https://issues.apache.org/jira/browse/KYLIN-3297
> Project: Kylin
> Issue Type: Bug
> Components: RDBMS Source
> Affects Versions: v2.2.0
> Environment: oracle linux 6.8
> cup 8C
> memory 48G
> apache kylin v2.2.0
> Reporter: 陈家宇
> Priority: Major
>
> select f.plant_code,f.report_business_area,f.orderby,sum(f.a)a,
> case when sum(f.a)=0 then 0 else sum(f.qty)/sum(f.a) end zt from (
> select h.business_area_desc,h.plant_code,
> case when p.report_business_area like '%切大片%' then '切大片'
> else p.report_business_area end report_business_area,
> case when p.report_business_area like '%切大片%' then '00'
> else p.orderby end orderby,
> sum(p.quantity) qty,sum(a)a from pkn_kpi p
> inner join hcm_area h on p.plant_id=h.plant_id
> where 1=1
> and h.business_area_desc='上海'
> and h.plant_code='S1'
> and p.calendar_day>='2018-03-19'
> and p.calendar_day<='2018-03-18'
> and trim(p.report_business_area) is not null
> group by h.business_area_desc,h.plant_code,p.report_business_area,p.orderby
> ) f
> group by f.plant_code,f.report_business_area,f.orderby
> order by orderby
> 以上的calendar_day条件,顺序输入反了,变成calendar_day>大值 and calendar_day<小值,出现了kylin内存溢出,并且崩溃。正常这种情况是没有数据输出才对。
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)