[jira] [Resolved] (KYLIN-1384) An error when do query with many measures

["nichunen (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-1384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

nichunen resolved KYLIN-1384.
-----------------------------
    Resolution: Fixed

> An error when do query with many measures
> -----------------------------------------
>
>                 Key: KYLIN-1384
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1384
>             Project: Kylin
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: v1.2
>            Reporter: nichunen
>            Assignee: liyang
>            Priority: Major
>         Attachments: error.log
>
>
> I built a cube with 100 measures(v1,v2,..,v100), when I query with 
> "
> select 
> sum(v1)+sum(v2)+sum(v3)+sum(v4)+sum(v5)as P1,
> sum(v6)+sum(v7)+sum(v8)+sum(v9)+sum(v10)as P2,
> sum(v11)+sum(v12)+sum(v13)+sum(v14)+sum(v15)as P3,
> sum(v16)+sum(v17)+sum(v18)+sum(v19)+sum(v20)as P4,
> sum(v21)+sum(v22)+sum(v23)+sum(v24)+sum(v25)as P5,
> sum(v26)+sum(v27)+sum(v28)+sum(v29)+sum(v30)as P6,
> sum(v31)+sum(v32)+sum(v33)+sum(v34)+sum(v35)as P7,
> sum(v36)+sum(v37)+sum(v38)+sum(v39)+sum(v40)as P8,
> sum(v41)+sum(v42)+sum(v43)+sum(v44)+sum(v45)as P9,
> sum(v46)+sum(v47)+sum(v48)+sum(v49)+sum(v50)as P10 from test
> " or
> “
> select 
> sum(v51)+sum(v52)+sum(v53)+sum(v54)+sum(v55)as P11,
> sum(v56)+sum(v57)+sum(v58)+sum(v59)+sum(v60)as P12,
> sum(v61)+sum(v62)+sum(v63)+sum(v64)+sum(v65)as P13,
> sum(v66)+sum(v67)+sum(v68)+sum(v69)+sum(v70)as P14,
> sum(v71)+sum(v72)+sum(v73)+sum(v74)+sum(v75)as P15,
> sum(v76)+sum(v77)+sum(v78)+sum(v79)+sum(v80)as P16,
> sum(v81)+sum(v82)+sum(v83)+sum(v84)+sum(v85)as P17,
> sum(v86)+sum(v87)+sum(v88)+sum(v89)+sum(v90)as P18,
> sum(v91)+sum(v92)+sum(v93)+sum(v94)+sum(v95)as P19,
> sum(v96)+sum(v97)+sum(v98)+sum(v99)+sum(v100)as P20 from test
> “, they worked ok. 
> But when do
> “
> select 
> sum(v1)+sum(v2)+sum(v3)+sum(v4)+sum(v5)as P1,
> sum(v6)+sum(v7)+sum(v8)+sum(v9)+sum(v10)as P2,
> sum(v11)+sum(v12)+sum(v13)+sum(v14)+sum(v15)as P3,
> sum(v16)+sum(v17)+sum(v18)+sum(v19)+sum(v20)as P4,
> sum(v21)+sum(v22)+sum(v23)+sum(v24)+sum(v25)as P5,
> sum(v26)+sum(v27)+sum(v28)+sum(v29)+sum(v30)as P6,
> sum(v31)+sum(v32)+sum(v33)+sum(v34)+sum(v35)as P7,
> sum(v36)+sum(v37)+sum(v38)+sum(v39)+sum(v40)as P8,
> sum(v41)+sum(v42)+sum(v43)+sum(v44)+sum(v45)as P9,
> sum(v46)+sum(v47)+sum(v48)+sum(v49)+sum(v50)as P10,
> sum(v51)+sum(v52)+sum(v53)+sum(v54)+sum(v55)as P11,
> sum(v56)+sum(v57)+sum(v58)+sum(v59)+sum(v60)as P12,
> sum(v61)+sum(v62)+sum(v63)+sum(v64)+sum(v65)as P13,
> sum(v66)+sum(v67)+sum(v68)+sum(v69)+sum(v70)as P14,
> sum(v71)+sum(v72)+sum(v73)+sum(v74)+sum(v75)as P15,
> sum(v76)+sum(v77)+sum(v78)+sum(v79)+sum(v80)as P16,
> sum(v81)+sum(v82)+sum(v83)+sum(v84)+sum(v85)as P17,
> sum(v86)+sum(v87)+sum(v88)+sum(v89)+sum(v90)as P18,
> sum(v91)+sum(v92)+sum(v93)+sum(v94)+sum(v95)as P19,
> sum(v96)+sum(v97)+sum(v98)+sum(v99)+sum(v100)as P20 from test
> “, get an error. 
> Attached is the error log for this query. 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)