nichunen created KYLIN-1384:
-------------------------------
Summary: 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
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
(v6.3.4#6332)
