Re: 回复: Error while executing SQL "select count(*) as nums,courseid from optionaction group by courseid LIMIT 50000": null

[ShaoFeng Shi]

Cool! thanks for the update.

2017-05-02 16:19 GMT+08:00 35925...@qq.com <35925...@qq.com>:

> 问题已经找到
>     原因是我的hive中的javax.jdo.option.ConnectionURL 的连接默认字符集为latin1
>     mysql中character_set_database 的值为latin1
>    而其他值，例如character_set_client、character_set_connection、
> character_set_results、character_set_server均为utf8
>
>   将所有的字符集均修改为latin1，重新build cube，再查询，就没有原来的错误了，可以查到结果
>
>
>
> 35925...@qq.com
>
> 发件人： 35925138
> 发送时间： 2017-05-02 10:39
> 收件人： dev
> 主题： 回复：答复: 回复：答复: Error while executing SQL "select count(*) as
> nums,courseid from optionaction group by courseid LIMIT 50000": null
> 一下是执行一条sql的全部日志，请帮忙分析，只要执行任意一条用到cube索引的sql,均会报错。普通的数据查询，例如select * from
> table ，没有问题。
>
> 2017-05-02 10:30:32,303 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> service.QueryService:336 : Using project: optionaction
> 2017-05-02 10:30:32,303 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> service.QueryService:337 : The original query:  select count(*),fdz from
> useraction group by fdz
> 2017-05-02 10:30:32,304 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> service.QueryService:440 : The corrected query: select count(*),fdz from
> useraction group by fdz
> LIMIT 10
> 2017-05-02 10:30:32,312 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> sql.parser:546 : Reduced COUNT(*)
> 2017-05-02 10:30:32,313 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> sql.parser:546 : Reduced FDZ
> 2017-05-02 10:30:32,313 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> sql.parser:546 : Reduced FDZ
> 2017-05-02 10:30:32,314 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> sql.parser:546 : Reduced SELECT COUNT(*), `FDZ`
> FROM `USERACTION`
> GROUP BY `FDZ`
> 2017-05-02 10:30:32,318 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> calcite.sql2rel:552 : Plan after converting SqlNode to RelNode
> LogicalSort(fetch=[10])
>   LogicalProject(EXPR$0=[$1], FDZ=[$0])
>     LogicalAggregate(group=[{0}], EXPR$0=[COUNT()])
>       LogicalProject(FDZ=[$1])
>         OLAPTableScan(table=[[DEFAULT, USERACTION]], fields=[[0, 1, 2]])
>
> 2017-05-02 10:30:32,322 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using rel#175:LogicalSort.NONE.[](
> input=HepRelVertex#174,fetch=10)
> 2017-05-02 10:30:32,322 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#173:LogicalProject.NONE.[](input=HepRelVertex#172,EXPR$0=$1,FDZ=$0)
> 2017-05-02 10:30:32,323 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#171:LogicalAggregate.NONE.[](input=HepRelVertex#170,
> group={0},EXPR$0=COUNT())
> 2017-05-02 10:30:32,323 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#169:LogicalProject.NONE.[](input=HepRelVertex#168,FDZ=$1)
> 2017-05-02 10:30:32,323 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#154:OLAPTableScan.OLAP.[](table=[DEFAULT, USERACTION],fields=[0, 1,
> 2])
> 2017-05-02 10:30:32,325 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 1/1; PHASE = PRE_PROCESS_MDR;
> COST = {inf}
> 2017-05-02 10:30:32,325 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 2/1; PHASE = PRE_PROCESS; COST =
> {inf}
> 2017-05-02 10:30:32,325 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 3/1; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,326 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableSortRule] rels
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,326 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#804: Apply rule [EnumerableSortRule] to
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,326 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#804 generated 0 successors.
> 2017-05-02 10:30:32,326 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 4/2; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,326 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPSortRule] rels
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,327 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#795: Apply rule [OLAPSortRule] to
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,327 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#795 generated 0 successors.
> 2017-05-02 10:30:32,327 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 5/3; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,327 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPLimitRule] rels
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,328 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#812: Apply rule [OLAPLimitRule] to
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,328 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#185 via OLAPLimitRule
> 2017-05-02 10:30:32,329 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#812 generated 1 successors:
> [rel#185:OLAPLimitRel.OLAP.[](input=rel#184:Subset#3.OLAP.[],fetch=10)]
> 2017-05-02 10:30:32,329 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 6/4; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,329 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#186:Subset#4.OLAP.[]]
> 2017-05-02 10:30:32,329 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#854: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#186:Subset#4.OLAP.[]]
> 2017-05-02 10:30:32,330 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#188 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,330 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#854 generated 1 successors: [rel#188:
> OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#186:Subset#4.OLAP.[])]
> 2017-05-02 10:30:32,330 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 7/5; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,331 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#185:OLAPLimitRel.OLAP.[](input=rel#184:Subset#3.OLAP.[]
> ,fetch=10)]
> 2017-05-02 10:30:32,331 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#846: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#185:OLAPLimitRel.OLAP.[](input=rel#184:Subset#3.OLAP.[],fetch=10)]
> 2017-05-02 10:30:32,331 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#189 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,331 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#846 generated 1 successors:
> [OLAPToEnumerableConverter#189]
> 2017-05-02 10:30:32,332 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 8/6; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,332 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [SortRemoveRule] rels
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,332 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#808: Apply rule [SortRemoveRule] to
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,332 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#808 generated 0 successors.
> 2017-05-02 10:30:32,332 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 9/7; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,333 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [SortProjectTransposeRule] rels
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10),
> rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.[
> ],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,333 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#806: Apply rule [SortProjectTransposeRule] to
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10),
> rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.[
> ],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,333 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#192 via SortProjectTransposeRule
> 2017-05-02 10:30:32,334 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#806 generated 1 successors:
> [LogicalProject#192]
> 2017-05-02 10:30:32,335 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 10/8; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,335 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableProjectRule] rels
> [rel#194:LogicalProject.NONE.[](input=rel#193:Subset#5.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,335 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#902: Apply rule [EnumerableProjectRule] to
> [rel#194:LogicalProject.NONE.[](input=rel#193:Subset#5.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,335 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#196 via EnumerableProjectRule
> 2017-05-02 10:30:32,336 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#902 generated 1 successors:
> [rel#196:EnumerableProject.ENUMERABLE.[](input=rel#195:
> Subset#5.ENUMERABLE.[],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,336 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 11/9; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,337 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPProjectRule] rels
> [rel#194:LogicalProject.NONE.[](input=rel#193:Subset#5.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,337 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#911: Apply rule [OLAPProjectRule] to
> [rel#194:LogicalProject.NONE.[](input=rel#193:Subset#5.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,337 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#198 via OLAPProjectRule
> 2017-05-02 10:30:32,338 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#911 generated 1 successors:
> [rel#198:OLAPProjectRel.OLAP.[](input=rel#197:Subset#5.OLAP.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,338 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 12/10; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,338 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#198:OLAPProjectRel.OLAP.[](input=rel#197:Subset#5.OLAP.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,339 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#940: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#198:OLAPProjectRel.OLAP.[](input=rel#197:Subset#5.OLAP.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,339 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#199 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,339 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#940 generated 1 successors:
> [OLAPToEnumerableConverter#199]
> 2017-05-02 10:30:32,339 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 13/11; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,340 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPSortRule] rels
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,340 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#863: Apply rule [OLAPSortRule] to
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,340 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#863 generated 0 successors.
> 2017-05-02 10:30:32,340 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 14/12; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,340 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPProjectRule] rels
> [rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,341 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#786: Apply rule [OLAPProjectRule] to
> [rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,341 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#202 via OLAPProjectRule
> 2017-05-02 10:30:32,342 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#786 generated 1 successors:
> [rel#202:OLAPProjectRel.OLAP.[](input=rel#201:Subset#2.OLAP.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,342 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 15/13; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,342 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPLimitRule] rels
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,342 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#879: Apply rule [OLAPLimitRule] to
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,343 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#203 via OLAPLimitRule
> 2017-05-02 10:30:32,343 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#879 generated 1 successors:
> [rel#203:OLAPLimitRel.OLAP.[](input=rel#201:Subset#2.OLAP.[],fetch=10)]
> 2017-05-02 10:30:32,343 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 16/14; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,344 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPAggregateRule] rels
> [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,344 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#754: Apply rule [OLAPAggregateRule] to
> [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,344 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#205 via OLAPAggregateRule
> 2017-05-02 10:30:32,345 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#754 generated 1 successors:
> [rel#205:OLAPAggregateRel.OLAP.[](input=rel#204:Subset#
> 1.OLAP.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,345 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 17/15; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,346 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [AggregateProjectReduceRule] rels
> [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT()), rel#160:LogicalProject.NONE.[]
> (input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,346 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#738: Apply rule [AggregateProjectReduceRule]
> to [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT()), rel#160:LogicalProject.NONE.[]
> (input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,346 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#738 generated 0 successors.
> 2017-05-02 10:30:32,346 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 18/16; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,346 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [SortRemoveRule] rels
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,347 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#875: Apply rule [SortRemoveRule] to
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,347 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#875 generated 0 successors.
> 2017-05-02 10:30:32,347 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 19/17; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,347 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [ReduceExpressionsRule(Project)]
> rels [rel#194:LogicalProject.NONE.[](input=rel#193:Subset#5.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,348 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#908: Apply rule [ReduceExpressionsRule(Project)]
> to [rel#194:LogicalProject.NONE.[](input=rel#193:Subset#5.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,348 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#908 generated 0 successors.
> 2017-05-02 10:30:32,348 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 20/18; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,348 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [ReduceExpressionsRule(Project)]
> rels [rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,348 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#783: Apply rule [ReduceExpressionsRule(Project)]
> to [rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,349 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#783 generated 0 successors.
> 2017-05-02 10:30:32,349 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 21/19; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,349 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [PruneSortLimit0] rels
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,349 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#870: Apply rule [PruneSortLimit0] to
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,349 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#870 generated 0 successors.
> 2017-05-02 10:30:32,350 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 22/20; PHASE = OPTIMIZE; COST =
> {inf}
> 2017-05-02 10:30:32,350 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPProjectRule] rels
> [rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,350 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#727: Apply rule [OLAPProjectRule] to
> [rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,350 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#206 via OLAPProjectRule
> 2017-05-02 10:30:32,352 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#727 generated 1 successors:
> [rel#206:OLAPProjectRel.OLAP.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,352 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 23/21; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,352 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [ReduceExpressionsRule(Project)]
> rels [rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.
> [],FDZ=$1)]
> 2017-05-02 10:30:32,353 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#724: Apply rule [ReduceExpressionsRule(Project)]
> to [rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,353 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#724 generated 0 successors.
> 2017-05-02 10:30:32,353 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 24/22; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,353 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableProjectRule] rels
> [rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,354 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#718: Apply rule [EnumerableProjectRule] to
> [rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,354 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#208 via EnumerableProjectRule
> 2017-05-02 10:30:32,355 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#718 generated 1 successors:
> [rel#208:EnumerableProject.ENUMERABLE.[](input=rel#207:
> Subset#0.ENUMERABLE.[],FDZ=$1)]
> 2017-05-02 10:30:32,355 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 25/23; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,355 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [AggregateRemoveRule] rels
> [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT()), rel#160:LogicalProject.NONE.[]
> (input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,355 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#750: Apply rule [AggregateRemoveRule] to
> [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT()), rel#160:LogicalProject.NONE.[]
> (input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,356 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#750 generated 0 successors.
> 2017-05-02 10:30:32,356 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 26/24; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,356 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [AggregatePullUpConstantsRule]
> rels [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT()), rel#160:LogicalProject.NONE.[]
> (input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,356 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#746: Apply rule
> [AggregatePullUpConstantsRule] to [rel#162:LogicalAggregate.
> NONE.[](input=rel#161:Subset#1.NONE.[],group={0},EXPR$0=COUNT()),
> rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,356 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#746 generated 0 successors.
> 2017-05-02 10:30:32,357 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 27/25; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,357 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableAggregateRule] rels
> [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,357 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#756: Apply rule [EnumerableAggregateRule] to
> [rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#
> 1.NONE.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,357 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#210 via EnumerableAggregateRule
> 2017-05-02 10:30:32,358 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#756 generated 1 successors:
> [rel#210:EnumerableAggregate.ENUMERABLE.[](input=rel#209:
> Subset#1.ENUMERABLE.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,359 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 28/26; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,359 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [PruneSortLimit0] rels
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,359 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#802: Apply rule [PruneSortLimit0] to
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,359 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#802 generated 0 successors.
> 2017-05-02 10:30:32,359 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 29/27; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,360 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableLimitRule] rels
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,360 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#814: Apply rule [EnumerableLimitRule] to
> [rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,360 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#213 via EnumerableLimitRule
> 2017-05-02 10:30:32,361 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#814 generated 1 successors:
> [rel#213:EnumerableLimit.ENUMERABLE.[](input=rel#212:
> Subset#3.ENUMERABLE.[],fetch=10)]
> 2017-05-02 10:30:32,361 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 30/28; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,362 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableSortRule] rels
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,362 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#872: Apply rule [EnumerableSortRule] to
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,362 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:217 : call#872 generated 0 successors.
> 2017-05-02 10:30:32,362 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 31/29; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,363 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableProjectRule] rels
> [rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,363 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#777: Apply rule [EnumerableProjectRule] to
> [rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,363 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#214 via EnumerableProjectRule
> 2017-05-02 10:30:32,364 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#777 generated 1 successors:
> [rel#214:EnumerableProject.ENUMERABLE.[](input=rel#211:
> Subset#2.ENUMERABLE.[],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,364 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 32/30; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,365 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [EnumerableLimitRule] rels
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,365 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#881: Apply rule [EnumerableLimitRule] to
> [rel#191:LogicalSort.NONE.[](input=rel#163:Subset#2.NONE.[],fetch=10)]
> 2017-05-02 10:30:32,365 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#215 via EnumerableLimitRule
> 2017-05-02 10:30:32,366 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#881 generated 1 successors:
> [rel#215:EnumerableLimit.ENUMERABLE.[](input=rel#211:
> Subset#2.ENUMERABLE.[],fetch=10)]
> 2017-05-02 10:30:32,366 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 33/31; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,367 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#206:OLAPProjectRel.OLAP.[](input=rel#159:Subset#0.OLAP.
> [],FDZ=$1)]
> 2017-05-02 10:30:32,367 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#994: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#206:OLAPProjectRel.OLAP.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)]
> 2017-05-02 10:30:32,367 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#216 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,368 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#994 generated 1 successors:
> [OLAPToEnumerableConverter#216]
> 2017-05-02 10:30:32,368 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 34/32; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,368 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#205:OLAPAggregateRel.OLAP.[](input=rel#204:Subset#
> 1.OLAP.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,369 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#979: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#205:OLAPAggregateRel.OLAP.[](input=rel#204:Subset#
> 1.OLAP.[],group={0},EXPR$0=COUNT())]
> 2017-05-02 10:30:32,369 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#218 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,369 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#979 generated 1 successors:
> [OLAPToEnumerableConverter#218]
> 2017-05-02 10:30:32,370 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 35/33; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,370 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#203:OLAPLimitRel.OLAP.[](input=rel#201:Subset#2.OLAP.[]
> ,fetch=10)]
> 2017-05-02 10:30:32,370 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#965: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#203:OLAPLimitRel.OLAP.[](input=rel#201:Subset#2.OLAP.[],fetch=10)]
> 2017-05-02 10:30:32,370 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#220 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,371 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#965 generated 1 successors:
> [OLAPToEnumerableConverter#220]
> 2017-05-02 10:30:32,371 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 36/34; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,371 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#159:Subset#0.OLAP.[]]
> 2017-05-02 10:30:32,372 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#703: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#159:Subset#0.OLAP.[]]
> 2017-05-02 10:30:32,372 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#222 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,373 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#703 generated 1 successors: [rel#222:
> OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#159:Subset#0.OLAP.[])]
> 2017-05-02 10:30:32,373 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 37/35; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,373 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#154:OLAPTableScan.OLAP.[](table=[DEFAULT,
> USERACTION],fields=[0, 1, 2])]
> 2017-05-02 10:30:32,373 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#684: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#154:OLAPTableScan.OLAP.[](table=[DEFAULT, USERACTION],fields=[0,
> 1, 2])]
> 2017-05-02 10:30:32,373 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#223 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,374 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#684 generated 1 successors:
> [OLAPToEnumerableConverter#223]
> 2017-05-02 10:30:32,374 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 38/36; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,374 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:503 : Pop match: rule [OLAPToEnumerableConverterRule]
> rels [rel#202:OLAPProjectRel.OLAP.[](input=rel#201:Subset#2.OLAP.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,375 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:194 : call#956: Apply rule [OLAPToEnumerableConverterRule]
> to [rel#202:OLAPProjectRel.OLAP.[](input=rel#201:Subset#2.OLAP.
> [],EXPR$0=$1,FDZ=$0)]
> 2017-05-02 10:30:32,375 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:92 : Transform to: rel#225 via
> OLAPToEnumerableConverterRule
> 2017-05-02 10:30:32,376 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:219 : call#956 generated 1 successors:
> [OLAPToEnumerableConverter#225]
> 2017-05-02 10:30:32,376 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 39/37; PHASE = OPTIMIZE; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,376 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:829 : PLANNER = org.apache.calcite.plan.
> volcano.VolcanoPlanner@5421a86f; TICK = 40/1; PHASE = CLEANUP; COST =
> {1.0E100 rows, 12.55 cpu, 0.0 io}
> 2017-05-02 10:30:32,377 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:856 : Cheapest plan:
> OLAPToEnumerableConverter: rowcount = 10.0, cumulative cost = {1.0E100
> rows, 12.55 cpu, 0.0 io}, id = 231
>   OLAPLimitRel(fetch=[10]): rowcount = 10.0, cumulative cost = {12.0625
> rows, 12.55 cpu, 0.0 io}, id = 230
>     OLAPProjectRel(EXPR$0=[$1], FDZ=[$0]): rowcount = 10.0, cumulative
> cost = {11.5625 rows, 12.05 cpu, 0.0 io}, id = 229
>       OLAPAggregateRel(group=[{0}], EXPR$0=[COUNT()]): rowcount = 10.0,
> cumulative cost = {10.5625 rows, 10.05 cpu, 0.0 io}, id = 228
>         OLAPProjectRel(FDZ=[$1]): rowcount = 100.0, cumulative cost =
> {10.0 rows, 10.05 cpu, 0.0 io}, id = 227
>           OLAPTableScan(table=[[DEFAULT, USERACTION]], fields=[[0, 1,
> 2]]): rowcount = 100.0, cumulative cost = {5.0 rows, 5.050000000000001 cpu,
> 0.0 io}, id = 154
>
> 2017-05-02 10:30:32,377 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:859 : Provenance:
> OLAPToEnumerableConverter#231
>   direct
>     rel#188:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#186:
> Subset#4.OLAP.[])
>       call#854 rule [OLAPToEnumerableConverterRule]
>         rel#186:Subset#4.OLAP.[]
>           subset rel#186:Subset#4.OLAP.[]
>             rel#185:OLAPLimitRel.OLAP.[](input=rel#184:Subset#3.OLAP.[]
> ,fetch=10)
>               call#812 rule [OLAPLimitRule]
>                 rel#166:LogicalSort.NONE.[](input=rel#165:Subset#3.NONE.[]
> ,fetch=10)
>                   no parent
> OLAPLimitRel#230
>   direct
>     rel#185 (see above)
> OLAPProjectRel#229
>   direct
>     rel#202:OLAPProjectRel.OLAP.[](input=rel#201:Subset#2.OLAP.[
> ],EXPR$0=$1,FDZ=$0)
>       call#786 rule [OLAPProjectRule]
>         rel#164:LogicalProject.NONE.[](input=rel#163:Subset#2.NONE.[
> ],EXPR$0=$1,FDZ=$0)
>           no parent
> OLAPAggregateRel#228
>   direct
>     rel#205:OLAPAggregateRel.OLAP.[](input=rel#204:Subset#1.
> OLAP.[],group={0},EXPR$0=COUNT())
>       call#754 rule [OLAPAggregateRule]
>         rel#162:LogicalAggregate.NONE.[](input=rel#161:Subset#1.
> NONE.[],group={0},EXPR$0=COUNT())
>           no parent
> OLAPProjectRel#227
>   direct
>     rel#206:OLAPProjectRel.OLAP.[](input=rel#159:Subset#0.OLAP.[],FDZ=$1)
>       call#727 rule [OLAPProjectRule]
>         rel#160:LogicalProject.NONE.[](input=rel#159:Subset#0.OLAP.[
> ],FDZ=$1)
>           no parent
> rel#154:OLAPTableScan.OLAP.[](table=[DEFAULT, USERACTION],fields=[0, 1,
> 2])
>   no parent
>
> 2017-05-02 10:30:32,378 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using rel#241:
> OLAPToEnumerableConverter.ENUMERABLE.[](input=HepRelVertex#240)
> 2017-05-02 10:30:32,378 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using rel#239:OLAPLimitRel.OLAP.[](
> input=HepRelVertex#238,fetch=10)
> 2017-05-02 10:30:32,378 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#237:OLAPProjectRel.OLAP.[](input=HepRelVertex#236,EXPR$0=$1,FDZ=$0)
> 2017-05-02 10:30:32,378 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#235:OLAPAggregateRel.OLAP.[](input=HepRelVertex#234,
> group={0},EXPR$0=COUNT())
> 2017-05-02 10:30:32,379 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#233:OLAPProjectRel.OLAP.[](input=HepRelVertex#232,FDZ=$1)
> 2017-05-02 10:30:32,379 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> plan.RelOptPlanner:361 : For final plan, using
> rel#154:OLAPTableScan.OLAP.[](table=[DEFAULT, USERACTION],fields=[0, 1,
> 2])
> 2017-05-02 10:30:32,379 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> prepare.Prepare:154 : Plan after physical tweaks:
> OLAPToEnumerableConverter: rowcount = 10.0, cumulative cost = {1.0E100
> rows, 12.55 cpu, 0.0 io}, id = 241
>   OLAPLimitRel(fetch=[10]): rowcount = 10.0, cumulative cost = {12.0625
> rows, 12.55 cpu, 0.0 io}, id = 239
>     OLAPProjectRel(EXPR$0=[$1], FDZ=[$0]): rowcount = 10.0, cumulative
> cost = {11.5625 rows, 12.05 cpu, 0.0 io}, id = 237
>       OLAPAggregateRel(group=[{0}], EXPR$0=[COUNT()]): rowcount = 10.0,
> cumulative cost = {10.5625 rows, 10.05 cpu, 0.0 io}, id = 235
>         OLAPProjectRel(FDZ=[$1]): rowcount = 100.0, cumulative cost =
> {10.0 rows, 10.05 cpu, 0.0 io}, id = 233
>           OLAPTableScan(table=[[DEFAULT, USERACTION]], fields=[[0, 1,
> 2]]): rowcount = 100.0, cumulative cost = {5.0 rows, 5.050000000000001 cpu,
> 0.0 io}, id = 154
>
> 2017-05-02 10:30:32,380 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> routing.QueryRouter:48 : The project manager's reference is
> org.apache.kylin.metadata.project.ProjectManager@7d996623
> 2017-05-02 10:30:32,380 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> routing.QueryRouter:60 : Find candidates by table DEFAULT.USERACTION and
> project=OPTIONACTION : CUBE[name=ttt1]
> 2017-05-02 10:30:32,380 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveBlackoutRealizationsRule, realizations before:
> [ttt1(CUBE)], realizations after: [ttt1(CUBE)]
> 2017-05-02 10:30:32,381 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveUncapableRealizationsRule, realizations before:
> [ttt1(CUBE)], realizations after: [ttt1(CUBE)]
> 2017-05-02 10:30:32,381 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> rules.RealizationSortRule:40 : CUBE[name=ttt1] priority 1 cost 71.
> 2017-05-02 10:30:32,381 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RealizationSortRule, realizations before: [ttt1(CUBE)],
> realizations after: [ttt1(CUBE)]
> 2017-05-02 10:30:32,381 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> routing.QueryRouter:72 : The realizations remaining: [ttt1(CUBE)] And the
> final chosen one is the first one
> 2017-05-02 10:30:32,423 DEBUG [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> enumerator.OLAPEnumerator:100 : query storage...
> 2017-05-02 10:30:32,424 ERROR [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> service.QueryService:372 : Exception when execute sql
> java.sql.SQLException: Error while executing SQL "select count(*),fdz from
> useraction group by fdz
> LIMIT 10": null
> at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:147)
> at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> AvaticaStatement.java:208)
> at org.apache.kylin.rest.service.QueryService.execute(
> QueryService.java:538)
> at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(
> QueryService.java:452)
> at org.apache.kylin.rest.service.QueryService.query(QueryService.java:151)
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:354)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:483)
> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(
> InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(
> FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.access.ExceptionTranslationFilter.
> doFilter(ExceptionTranslationFilter.java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.session.SessionManagementFilter.
> doFilter(SessionManagementFilter.java:103)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.
> doFilter(RequestCacheAwareFilter.java:45)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.context.SecurityContextPersistenceFilt
> er.doFilter(SecurityContextPersistenceFilter.java:87)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.FilterChainProxy.doFilterInternal(
> FilterChainProxy.java:192)
> at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
> at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(
> DelegatingFilterProxy.java:343)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
> at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
> at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
> at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
> at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
> at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:854)
> at java.util.Collections.min(Collections.java:635)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:217)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:141)
> at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
> at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.java:68)
> at org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.search(
> GTCubeStorageQueryBase.java:104)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> queryStorage(OLAPEnumerator.java:114)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> moveNext(OLAPEnumerator.java:65)
> at Baz$1$1.moveNext(Unknown Source)
> at org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(
> EnumerableDefaults.java:823)
> at org.apache.calcite.linq4j.EnumerableDefaults.groupBy(
> EnumerableDefaults.java:758)
> at org.apache.calcite.linq4j.DefaultEnumerable.groupBy(
> DefaultEnumerable.java:302)
> at Baz.bind(Unknown Source)
> at org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(
> CalcitePrepare.java:327)
> at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(
> CalciteConnectionImpl.java:282)
> at org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(
> CalciteMetaImpl.java:553)
> at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(
> CalciteMetaImpl.java:544)
> at org.apache.calcite.avatica.AvaticaResultSet.execute(
> AvaticaResultSet.java:187)
> at org.apache.calcite.jdbc.CalciteResultSet.execute(
> CalciteResultSet.java:65)
> at org.apache.calcite.jdbc.CalciteResultSet.execute(
> CalciteResultSet.java:44)
> at org.apache.calcite.avatica.AvaticaConnection$1.execute(
> AvaticaConnection.java:605)
> at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(
> CalciteMetaImpl.java:599)
> at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(
> AvaticaConnection.java:613)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:139)
> ... 77 more
> 2017-05-02 10:30:32,425 INFO  [Query c9bf885b-3e1c-4e6f-81ad-d0a98c176a71-75]
> service.QueryService:284 :
> ==========================[QUERY]===============================
> Query Id: c9bf885b-3e1c-4e6f-81ad-d0a98c176a71
> SQL: select count(*),fdz from useraction group by fdz
> LIMIT 10
> User: ADMIN
> Success: false
> Duration: 0.0
> Project: optionaction
> Realization Names: [ttt1]
> Cuboid Ids: []
> Total scan count: 0
> Result row count: 0
> Accept Partial: false
> Is Partial Result: false
> Hit Exception Cache: false
> Storage cache used: false
> Message: Error while executing SQL "select count(*),fdz from useraction
> group by fdz LIMIT 10": null
> ==========================[QUERY]===============================
>
> 2017-05-02 10:30:32,425 ERROR [http-bio-7070-exec-1]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while
> executing SQL "select count(*),fdz from useraction group by fdz LIMIT 10":
> null
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:389)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:483)
> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(
> InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(
> FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.access.ExceptionTranslationFilter.
> doFilter(ExceptionTranslationFilter.java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.session.SessionManagementFilter.
> doFilter(SessionManagementFilter.java:103)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.
> doFilter(RequestCacheAwareFilter.java:45)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.context.SecurityContextPersistenceFilt
> er.doFilter(SecurityContextPersistenceFilter.java:87)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.FilterChainProxy.doFilterInternal(
> FilterChainProxy.java:192)
> at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
> at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(
> DelegatingFilterProxy.java:343)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
> at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
> at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
> at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
> at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
> at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:745)
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "35925138";<35925...@qq.com>;
> 发送时间: 2017年4月28日(星期五) 下午3:31
> 收件人: "dev"<dev@kylin.apache.org>;
> 主题: 回复：答复: 回复：答复: Error while executing SQL "select count(*) as
> nums,courseid from optionaction group by courseid LIMIT 50000": null
>
> 你好，我又发现了一部分日志，请帮忙分析
>
> 2017-04-28 15:22:09,556 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:856 : Cheapest plan:
> OLAPToEnumerableConverter: rowcount = 10.0, cumulative cost = {1.0E100
> rows, 12.55 cpu, 0.0 io}, id = 77
>   OLAPLimitRel(fetch=[50000]): rowcount = 10.0, cumulative cost = {12.0625
> rows, 12.55 cpu, 0.0 io}, id = 76
>     OLAPProjectRel(EXPR$0=[$1], FDZ=[$0]): rowcount = 10.0, cumulative
> cost = {11.5625 rows, 12.05 cpu, 0.0 io}, id = 75
>       OLAPAggregateRel(group=[{0}], EXPR$0=[COUNT()]): rowcount = 10.0,
> cumulative cost = {10.5625 rows, 10.05 cpu, 0.0 io}, id = 74
>         OLAPProjectRel(FDZ=[$3]): rowcount = 100.0, cumulative cost =
> {10.0 rows, 10.05 cpu, 0.0 io}, id = 73
>           OLAPTableScan(table=[[DEFAULT, OPTIONACTION]], fields=[[0, 1, 2,
> 3, 4, 5, 6, 7]]): rowcount = 100.0, cumulative cost = {5.0 rows,
> 5.050000000000001 cpu, 0.0 io}, id = 0
>
> 2017-04-28 15:22:09,557 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:859 : Provenance:
> OLAPToEnumerableConverter#77
>   direct
>     rel#34:OLAPToEnumerableConverter.ENUMERABLE.[](input=rel#32:
> Subset#4.OLAP.[])
>       call#171 rule [OLAPToEnumerableConverterRule]
>         rel#32:Subset#4.OLAP.[]
>           subset rel#32:Subset#4.OLAP.[]
>             rel#31:OLAPLimitRel.OLAP.[](input=rel#30:Subset#3.OLAP.[],
> fetch=50000)
>               call#129 rule [OLAPLimitRule]
>                 rel#12:LogicalSort.NONE.[](input=rel#11:Subset#3.NONE.[],
> fetch=50000)
>                   no parent
> OLAPLimitRel#76
>   direct
>     rel#31 (see above)
> OLAPProjectRel#75
>   direct
>     rel#48:OLAPProjectRel.OLAP.[](input=rel#47:Subset#2.OLAP.[],
> EXPR$0=$1,FDZ=$0)
>       call#103 rule [OLAPProjectRule]
>         rel#10:LogicalProject.NONE.[](input=rel#9:Subset#2.NONE.[],
> EXPR$0=$1,FDZ=$0)
>           no parent
> OLAPAggregateRel#74
>   direct
>     rel#51:OLAPAggregateRel.OLAP.[](input=rel#50:Subset#1.OLAP.[
> ],group={0},EXPR$0=COUNT())
>       call#71 rule [OLAPAggregateRule]
>         rel#8:LogicalAggregate.NONE.[](input=rel#7:Subset#1.NONE.[],
> group={0},EXPR$0=COUNT())
>           no parent
> OLAPProjectRel#73
>   direct
>     rel#52:OLAPProjectRel.OLAP.[](input=rel#5:Subset#0.OLAP.[],FDZ=$3)
>       call#44 rule [OLAPProjectRule]
>         rel#6:LogicalProject.NONE.[](input=rel#5:Subset#0.OLAP.[],FDZ=$3)
>           no parent
> rel#0:OLAPTableScan.OLAP.[](table=[DEFAULT, OPTIONACTION],fields=[0, 1,
> 2, 3, 4, 5, 6, 7])
>   no parent
>
> 2017-04-28 15:22:09,558 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:361 : For final plan, using rel#87:
> OLAPToEnumerableConverter.ENUMERABLE.[](input=HepRelVertex#86)
> 2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:361 : For final plan, using rel#85:OLAPLimitRel.OLAP.[](
> input=HepRelVertex#84,fetch=50000)
> 2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:361 : For final plan, using
> rel#83:OLAPProjectRel.OLAP.[](input=HepRelVertex#82,EXPR$0=$1,FDZ=$0)
> 2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:361 : For final plan, using
> rel#81:OLAPAggregateRel.OLAP.[](input=HepRelVertex#80,group=
> {0},EXPR$0=COUNT())
> 2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:361 : For final plan, using
> rel#79:OLAPProjectRel.OLAP.[](input=HepRelVertex#78,FDZ=$3)
> 2017-04-28 15:22:09,559 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> plan.RelOptPlanner:361 : For final plan, using 
> rel#0:OLAPTableScan.OLAP.[](table=[DEFAULT,
> OPTIONACTION],fields=[0, 1, 2, 3, 4, 5, 6, 7])
> 2017-04-28 15:22:09,561 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> prepare.Prepare:154 : Plan after physical tweaks:
> OLAPToEnumerableConverter: rowcount = 10.0, cumulative cost = {1.0E100
> rows, 12.55 cpu, 0.0 io}, id = 87
>   OLAPLimitRel(fetch=[50000]): rowcount = 10.0, cumulative cost = {12.0625
> rows, 12.55 cpu, 0.0 io}, id = 85
>     OLAPProjectRel(EXPR$0=[$1], FDZ=[$0]): rowcount = 10.0, cumulative
> cost = {11.5625 rows, 12.05 cpu, 0.0 io}, id = 83
>       OLAPAggregateRel(group=[{0}], EXPR$0=[COUNT()]): rowcount = 10.0,
> cumulative cost = {10.5625 rows, 10.05 cpu, 0.0 io}, id = 81
>         OLAPProjectRel(FDZ=[$3]): rowcount = 100.0, cumulative cost =
> {10.0 rows, 10.05 cpu, 0.0 io}, id = 79
>           OLAPTableScan(table=[[DEFAULT, OPTIONACTION]], fields=[[0, 1, 2,
> 3, 4, 5, 6, 7]]): rowcount = 100.0, cumulative cost = {5.0 rows,
> 5.050000000000001 cpu, 0.0 io}, id = 0
>
> 2017-04-28 15:22:09,575 INFO  [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> routing.QueryRouter:48 : The project manager's reference is
> org.apache.kylin.metadata.project.ProjectManager@192989fd
> 2017-04-28 15:22:09,585 INFO  [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> routing.QueryRouter:60 : Find candidates by table DEFAULT.OPTIONACTION and
> project=OPTIONACTION : CUBE[name=aaabbb]
> 2017-04-28 15:22:09,589 INFO  [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveBlackoutRealizationsRule, realizations before:
> [aaabbb(CUBE)], realizations after: [aaabbb(CUBE)]
> 2017-04-28 15:22:09,594 INFO  [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RemoveUncapableRealizationsRule, realizations before:
> [aaabbb(CUBE)], realizations after: [aaabbb(CUBE)]
> 2017-04-28 15:22:09,594 INFO  [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> rules.RealizationSortRule:40 : CUBE[name=aaabbb] priority 1 cost 93.
> 2017-04-28 15:22:09,595 INFO  [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> routing.QueryRouter:51 : Applying rule: class org.apache.kylin.query.
> routing.rules.RealizationSortRule, realizations before: [aaabbb(CUBE)],
> realizations after: [aaabbb(CUBE)]
> 2017-04-28 15:22:09,595 INFO  [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> routing.QueryRouter:72 : The realizations remaining: [aaabbb(CUBE)] And the
> final chosen one is the first one
> 2017-04-28 15:22:09,767 DEBUG [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> enumerator.OLAPEnumerator:100 : query storage...
> 2017-04-28 15:22:09,778 ERROR [Query 505b4b6f-467d-45fd-9c92-c301678875af-76]
> service.QueryService:372 : Exception when execute sql
> java.sql.SQLException: Error while executing SQL "select count(*),fdz from
> optionaction group by fdz
> LIMIT 50000": null
> at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
> at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:147)
> at org.apache.calcite.avatica.AvaticaStatement.executeQuery(
> AvaticaStatement.java:208)
> at org.apache.kylin.rest.service.QueryService.execute(
> QueryService.java:538)
> at org.apache.kylin.rest.service.QueryService.queryWithSqlMassage(
> QueryService.java:452)
> at org.apache.kylin.rest.service.QueryService.query(QueryService.java:151)
> at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:354)
> at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:483)
> at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(
> InvocableHandlerMethod.java:221)
> at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
> at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
> at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
> at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
> at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
> at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
> at org.springframework.web.servlet.FrameworkServlet.processRequest(
> FrameworkServlet.java:951)
> at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
> at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:303)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
> at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.access.ExceptionTranslationFilter.
> doFilter(ExceptionTranslationFilter.java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.session.SessionManagementFilter.
> doFilter(SessionManagementFilter.java:103)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.
> doFilter(RequestCacheAwareFilter.java:45)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.context.SecurityContextPersistenceFilt
> er.doFilter(SecurityContextPersistenceFilter.java:87)
> at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
> at org.springframework.security.web.FilterChainProxy.doFilterInternal(
> FilterChainProxy.java:192)
> at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
> at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(
> DelegatingFilterProxy.java:343)
> at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:209)
> at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:244)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(
> ApplicationFilterChain.java:241)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
> at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
> at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
> at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
> at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
> at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
> at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
> at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
> at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
> at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
> at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
> at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
> at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
> at java.lang.Thread.run(Thread.java:745)
> Caused by: java.util.NoSuchElementException
> at java.util.ArrayList$Itr.next(ArrayList.java:854)
> at java.util.Collections.min(Collections.java:635)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:217)
> at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(
> Cuboid.java:141)
> at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
> at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.java:68)
> at org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.search(
> GTCubeStorageQueryBase.java:104)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> queryStorage(OLAPEnumerator.java:114)
> at org.apache.kylin.query.enumerator.OLAPEnumerator.
> moveNext(OLAPEnumerator.java:65)
> at Baz$1$1.moveNext(Unknown Source)
> at org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(
> EnumerableDefaults.java:823)
> at org.apache.calcite.linq4j.EnumerableDefaults.groupBy(
> EnumerableDefaults.java:758)
> at org.apache.calcite.linq4j.DefaultEnumerable.groupBy(
> DefaultEnumerable.java:302)
> at Baz.bind(Unknown Source)
> at org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(
> CalcitePrepare.java:327)
> at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(
> CalciteConnectionImpl.java:282)
> at org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(
> CalciteMetaImpl.java:553)
> at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(
> CalciteMetaImpl.java:544)
> at org.apache.calcite.avatica.AvaticaResultSet.execute(
> AvaticaResultSet.java:187)
> at org.apache.calcite.jdbc.CalciteResultSet.execute(
> CalciteResultSet.java:65)
> at org.apache.calcite.jdbc.CalciteResultSet.execute(
> CalciteResultSet.java:44)
> at org.apache.calcite.avatica.AvaticaConnection$1.execute(
> AvaticaConnection.java:605)
> at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(
> CalciteMetaImpl.java:599)
> at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(
> AvaticaConnection.java:613)
> at org.apache.calcite.avatica.AvaticaStatement.executeInternal(
> AvaticaStatement.java:139)
> ... 77 more
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "35925138";<35925...@qq.com>;
> 发送时间: 2017年4月28日(星期五) 中午1:16
> 收件人: "dev"<dev@kylin.apache.org>;
> 主题: 回复：答复: 回复：答复: Error while executing SQL "select count(*) as
> nums,courseid from optionaction group by courseid LIMIT 50000": null
>
> 我去执行诊断，但是日志报如下错误，无法下载
> 2017-04-28 13:11:23,614 ERROR [http-bio-7070-exec-10]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Failed to create
> download for diagnosis. java.net.SocketException: Broken pipe
>         at org.apache.kylin.rest.controller.DiagnosisController.
> setDownloadResponse(DiagnosisController.java:117)
>         at org.apache.kylin.rest.controller.DiagnosisController.
> dumpProjectDiagnosisInfo(DiagnosisController.java:88)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:483)
>         at org.springframework.web.method.support.InvocableHandlerMethod.
> doInvoke(InvocableHandlerMethod.java:221)
>         at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
>         at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
>         at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
>         at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
>         at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
>         at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
>         at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
>         at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
>         at org.springframework.web.servlet.FrameworkServlet.
> doGet(FrameworkServlet.java:842)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
>         at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
>      at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:87)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:192)
>         at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
>         at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:343)
>         at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:209)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:244)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
>         at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
>         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
>         at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
>         at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
>         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
>         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
>         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: org.apache.catalina.connector.ClientAbortException:
> java.net.SocketException: Broken pipe
>         at org.apache.catalina.connector.OutputBuffer.realWriteBytes(
> OutputBuffer.java:407)
>         at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(
> ByteChunk.java:480)
>         at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:310)
>         at org.apache.catalina.connector.OutputBuffer.writeByte(
> OutputBuffer.java:451)
>         at org.apache.catalina.connector.CoyoteOutputStream.write(
> CoyoteOutputStream.java:77)
>         at org.springframework.security.web.context.
> SaveContextOnUpdateOrErrorResponseWrapper$SaveContextServletOutputStream
> .write(SaveContextOnUpdateOrErrorResponseWrapper.java:203)
>         at java.io.OutputStream.write(OutputStream.java:116)
>         at org.apache.commons.io.IOUtils.copyLarge(IOUtils.java:2147)
>         at org.apache.commons.io.IOUtils.copy(IOUtils.java:2102)
>         at org.apache.commons.io.IOUtils.copyLarge(IOUtils.java:2123)
>         at org.apache.kylin.rest.controller.DiagnosisController.
> setDownloadResponse(DiagnosisController.java:114)
>         ... 72 more
>        Caused by: java.net.SocketException: Broken pipe
>         at java.net.SocketOutputStream.socketWrite0(Native Method)
>         at java.net.SocketOutputStream.socketWrite(
> SocketOutputStream.java:109)
>         at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
>         at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(
> InternalOutputBuffer.java:215)
>         at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(
> ByteChunk.java:480)
>         at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:366)
>         at org.apache.coyote.http11.InternalOutputBuffer$
> OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:240)
>         at org.apache.coyote.http11.filters.IdentityOutputFilter.
> doWrite(IdentityOutputFilter.java:84)
>         at org.apache.coyote.http11.AbstractOutputBuffer.doWrite(
> AbstractOutputBuffer.java:192)
>         at org.apache.coyote.Response.doWrite(Response.java:499)
>         at org.apache.catalina.connector.OutputBuffer.realWriteBytes(
> OutputBuffer.java:402)
>         ... 82 more
>         2017-04-28 13:11:23,616 ERROR [http-bio-7070-exec-10] annotation.
> ExceptionHandlerExceptionResolver:324 : Failed to invoke
> @ExceptionHandler method: org.apache.kylin.rest.response.ErrorResponse
> org.apache.kylin.rest.controller.BasicController.
> handleError(javax.servlet.http.HttpServletRequest,java.lang.Exception)
> org.apache.catalina.connector.ClientAbortException:
> java.net.SocketException: Broken pipe
>         at org.apache.catalina.connector.OutputBuffer.realWriteBytes(
> OutputBuffer.java:407)
>         at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(
> ByteChunk.java:480)
>         at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:310)
>         at org.apache.catalina.connector.OutputBuffer.writeByte(
> OutputBuffer.java:451)
>         at org.apache.catalina.connector.CoyoteOutputStream.write(
> CoyoteOutputStream.java:77)
>         at org.springframework.security.web.context.
> SaveContextOnUpdateOrErrorResponseWrapper$SaveContextServletOutputStream
> .write(SaveContextOnUpdateOrErrorResponseWrapper.java:203)
>         at java.io.OutputStream.write(OutputStream.java:116)
>         at com.fasterxml.jackson.core.json.UTF8JsonGenerator._
> flushBuffer(UTF8JsonGenerator.java:2003)
>         at com.fasterxml.jackson.core.json.UTF8JsonGenerator.flush(
> UTF8JsonGenerator.java:1019)
>         at com.fasterxml.jackson.databind.ObjectMapper.
> writeValue(ObjectMapper.java:2385)
>         at org.springframework.http.converter.json.
> MappingJackson2HttpMessageConverter.writeInternal(
> MappingJackson2HttpMessageConverter.java:204)
>         at org.springframework.http.converter.
> AbstractHttpMessageConverter.write(AbstractHttpMessageConverter.java:180)
>         at org.springframework.web.servlet.mvc.method.annotation.
> AbstractMessageConverterMethodProcessor.writeWithMessageConverters(
> AbstractMessageConverterMethodProcessor.java:168)
>         at org.springframework.web.servlet.mvc.method.annotation.
> AbstractMessageConverterMethodProcessor.writeWithMessageConverters(
> AbstractMessageConverterMethodProcessor.java:113)
>         at org.springframework.web.servlet.mvc.method.annotation.
> RequestResponseBodyMethodProcessor.handleReturnValue(
> RequestResponseBodyMethodProcessor.java:188)
>         at org.springframework.web.method.support.
> HandlerMethodReturnValueHandlerComposite.handleReturnValue(
> HandlerMethodReturnValueHandlerComposite.java:69)
>         at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:122)
>         at org.springframework.web.servlet.mvc.method.annotation.
> ExceptionHandlerExceptionResolver.doResolveHandlerMethodException(
> ExceptionHandlerExceptionResolver.java:320)
>         at org.springframework.web.servlet.handler.
> AbstractHandlerMethodExceptionResolver.doResolveException(
> AbstractHandlerMethodExceptionResolver.java:60)
>         at org.springframework.web.servlet.handler.
> AbstractHandlerExceptionResolver.resolveException(
> AbstractHandlerExceptionResolver.java:136)
>         at org.springframework.web.servlet.DispatcherServlet.
> processHandlerException(DispatcherServlet.java:1156)
>         at org.springframework.web.servlet.DispatcherServlet.
> processDispatchResult(DispatcherServlet.java:994)
>         at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:945)
>         at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
>         at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
>         at org.springframework.web.servlet.FrameworkServlet.
> doGet(FrameworkServlet.java:842)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
>         at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
>        at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:87)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:192)
>         at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
>         at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:343)
>         at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:209)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:244)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
>         at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
>         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
>         at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
>         at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
>         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
>         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
>         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.net.SocketException: Broken pipe
>         at java.net.SocketOutputStream.socketWrite0(Native Method)
>         at java.net.SocketOutputStream.socketWrite(
> SocketOutputStream.java:109)
>         at java.net.SocketOutputStream.write(SocketOutputStream.java:153)
>         at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(
> InternalOutputBuffer.java:215)
>         at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(
> ByteChunk.java:480)
>         at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:366)
>         at org.apache.coyote.http11.InternalOutputBuffer$
> OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:240)
>         at org.apache.coyote.http11.filters.IdentityOutputFilter.
> doWrite(IdentityOutputFilter.java:84)
>         at org.apache.coyote.http11.AbstractOutputBuffer.doWrite(
> AbstractOutputBuffer.java:192)
>         at org.apache.coyote.Response.doWrite(Response.java:499)
>         at org.apache.catalina.connector.OutputBuffer.realWriteBytes(
> OutputBuffer.java:402)
>         ... 82 more
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "roger shi";<rogershijich...@hotmail.com>;
> 发送时间: 2017年4月28日(星期五) 中午11:25
> 收件人: "dev"<dev@kylin.apache.org>;
> 主题: 答复: 回复：答复: Error while executing SQL "select count(*) as nums,courseid
> from optionaction group by courseid LIMIT 50000": null
>
> Cannot figure out the root cause according to the info provided. Would you
> please follow the following guide to generate diagnosis package?
>
>
> http://kylin.apache.org/blog/2016/06/10/diagnosis-tool/
>
> Apache Kylin | Diagnosis Tool Introduction<http://kylin.
> apache.org/blog/2016/06/10/diagnosis-tool/>
> kylin.apache.org
> Diagnosis Tool Introduction. Jun 10, 2016 • Dong Li. Introduction. Since
> Apache Kylin 1.5.2, there’s a diagnosis tool on Web UI, which aims to help
> Kylin admins ...
>
>
>
>
> ________________________________
> 发件人: 35925138 <35925...@qq.com>
> 发送时间: 2017年4月28日 10:12:17
> 收件人: dev
> 主题: 回复：答复: Error while executing SQL "select count(*) as nums,courseid
> from optionaction group by courseid LIMIT 50000": null
>
> 你好：
> 暴出的错误如下：
> 2017-04-28 10:08:47,001 ERROR [http-bio-7070-exec-6]
> controller.BasicController:44 :
> org.apache.kylin.rest.exception.InternalErrorException: Error while
> executing SQL "select count(*) as nums,fdz from optionaction group by fdz
> LIMIT 50000": null
>         at org.apache.kylin.rest.service.QueryService.doQueryWithCache(
> QueryService.java:389)
>         at org.apache.kylin.rest.controller.QueryController.
> query(QueryController.java:69)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:483)
>         at org.springframework.web.method.support.InvocableHandlerMethod.
> doInvoke(InvocableHandlerMethod.java:221)
>         at org.springframework.web.method.support.InvocableHandlerMethod.
> invokeForRequest(InvocableHandlerMethod.java:136)
>         at org.springframework.web.servlet.mvc.method.annotation.
> ServletInvocableHandlerMethod.invokeAndHandle(
> ServletInvocableHandlerMethod.java:104)
>         at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.invokeHandleMethod(
> RequestMappingHandlerAdapter.java:743)
>         at org.springframework.web.servlet.mvc.method.annotation.
> RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.
> java:672)
>         at org.springframework.web.servlet.mvc.method.
> AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:82)
>         at org.springframework.web.servlet.DispatcherServlet.
> doDispatch(DispatcherServlet.java:933)
>         at org.springframework.web.servlet.DispatcherServlet.
> doService(DispatcherServlet.java:867)
>         at org.springframework.web.servlet.FrameworkServlet.
> processRequest(FrameworkServlet.java:951)
>         at org.springframework.web.servlet.FrameworkServlet.
> doPost(FrameworkServlet.java:853)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
>         at org.springframework.web.servlet.FrameworkServlet.
> service(FrameworkServlet.java:827)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
>
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:303)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.apache.tomcat.websocket.server.WsFilter.doFilter(
> WsFilter.java:52)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:330)
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)
>         at org.springframework.security.web.access.intercept.
> FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.access.
> ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.session.
> SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.
> AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.
> java:113)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.servletapi.
> SecurityContextHolderAwareRequestFilter.doFilter(
> SecurityContextHolderAwareRequestFilter.java:54)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.savedrequest.
> RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.www.
> BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:201)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.ui.
> DefaultLoginPageGeneratingFilter.doFilter(DefaultLoginPageGeneratingFilt
> er.java:91)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.
> AbstractAuthenticationProcessingFilter.doFilter(
> AbstractAuthenticationProcessingFilter.java:183)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.authentication.logout.
> LogoutFilter.doFilter(LogoutFilter.java:105)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.context.
> SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilt
> er.java:87)
>         at org.springframework.security.web.FilterChainProxy$
> VirtualFilterChain.doFilter(FilterChainProxy.java:342)
>         at org.springframework.security.web.FilterChainProxy.
> doFilterInternal(FilterChainProxy.java:192)
>         at org.springframework.security.web.FilterChainProxy.doFilter(
> FilterChainProxy.java:160)
>         at org.springframework.web.filter.DelegatingFilterProxy.
> invokeDelegate(DelegatingFilterProxy.java:343)
>         at org.springframework.web.filter.DelegatingFilterProxy.doFilter(
> DelegatingFilterProxy.java:260)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:209)
>         at com.thetransactioncompany.cors.CORSFilter.doFilter(
> CORSFilter.java:244)
>         at org.apache.catalina.core.ApplicationFilterChain.
> internalDoFilter(ApplicationFilterChain.java:241)
>         at org.apache.catalina.core.ApplicationFilterChain.doFilter(
> ApplicationFilterChain.java:208)
>         at org.apache.catalina.core.StandardWrapperValve.invoke(
> StandardWrapperValve.java:220)
>         at org.apache.catalina.core.StandardContextValve.invoke(
> StandardContextValve.java:122)
>         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(
> AuthenticatorBase.java:505)
>         at org.apache.catalina.core.StandardHostValve.invoke(
> StandardHostValve.java:169)
>         at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:103)
>         at org.apache.catalina.valves.AccessLogValve.invoke(
> AccessLogValve.java:956)
>         at org.apache.catalina.core.StandardEngineValve.invoke(
> StandardEngineValve.java:116)
>         at org.apache.catalina.connector.CoyoteAdapter.service(
> CoyoteAdapter.java:436)
>         at org.apache.coyote.http11.AbstractHttp11Processor.process(
> AbstractHttp11Processor.java:1078)
>         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.
> process(AbstractProtocol.java:625)
>         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.
> run(JIoEndpoint.java:316)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
>         at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(
> TaskThread.java:61)
>         at java.lang.Thread.run(Thread.java:745)
>
>
>
>
>
>
> cube   的json如下：
> {   "uuid": "9bc80d90-4bf2-4ae5-b3ee-dd8a563fcefd",   "last_modified":
> 1493263501742,   "version": "1.6.0",   "name": "aaabbb",   "model_name":
> "optionaction",   "description": "",   "null_string": null,   "dimensions":
> [     {       "name": "ACTION_TIME",       "table":
> "DEFAULT.OPTIONACTION",       "column": "ACTION_TIME",       "derived":
> null     },     {       "name": "AGENTID",       "table":
> "DEFAULT.OPTIONACTION",       "column": "AGENTID",       "derived": null
>  },     {       "name": "COURSEID",       "table": "DEFAULT.OPTIONACTION",
>      "column": "COURSEID",       "derived": null     },     {       "name":
> "COURSEVERSION",       "table": "DEFAULT.OPTIONACTION",       "column":
> "COURSEVERSION",       "derived": null     },     {       "name": "IP",
>    "table": "DEFAULT.OPTIONACTION",       "column": "IP",       "derived":
> null     },     {       "name": "DAY_TIME",       "table":
> "DEFAULT.OPTIONACTION",       "column": "DAY_TIME",       "derived": null
>    },     {       "name": "HOUR_TIME",       "table":
> "DEFAULT.OPTIONACTION",       "column": "HOUR_TIME",       "derived": null
>    },     {       "name": "MONTH_TIME",       "table":
> "DEFAULT.OPTIONACTION",       "column": "MONTH_TIME",       "derived":
> null     },     {       "name": "YEAR_TIME",       "table":
> "DEFAULT.OPTIONACTION",       "column": "YEAR_TIME",       "derived": null
>    },     {       "name": "RESTYPE",       "table":
> "DEFAULT.OPTIONACTION",       "column": "RESTYPE",       "derived": null
>  },     {       "name": "RESID",       "table": "DEFAULT.OPTIONACTION",
>    "column": "RESID",       "derived": null     },     {       "name":
> "USERID",       "table": "DEFAULT.OPTIONACTION",       "column": "USERID",
>      "derived": null     },     {       "name": "SEX",       "table":
> "DEFAULT.OPTIONACTION",       "column": "SEX",       "derived": null
>  },     {       "name": "AGE",       "table": "DEFAULT.OPTIONACTION",
>  "column": "AGE",       "derived": null     },     {       "name":
> "RX_PICI",       "table": "DEFAULT.OPTIONACTION",       "column":
> "RX_PICI",       "derived": null     },     {       "name": "STUDYKIND",
>    "table": "DEFAULT.OPTIONACTION",       "column": "STUDYKIND",
>  "derived": null     },     {       "name": "SUBJECT",       "table":
> "DEFAULT.OPTIONACTION",       "column": "SUBJECT",       "derived": null
>  },     {       "name": "FDZ",       "table": "DEFAULT.OPTIONACTION",
>  "column": "FDZ",       "derived": null     },     {       "name":
> "PROVINCENAME",       "table": "DEFAULT.OPTIONACTION",       "column":
> "PROVINCENAME",       "derived": null     },     {       "name":
> "CITYNAME",       "table": "DEFAULT.OPTIONACTION",       "column":
> "CITYNAME",       "derived": null     }   ],   "measures": [     {
>  "name": "_COUNT_",       "function": {         "expression": "COUNT",
>    "parameter": {           "type": "constant",           "value": "1",
>        "next_parameter": null         },         "returntype": "bigint"
>    },       "dependent_measure_ref": null     }   ],   "dictionaries": [],
>  "rowkey": {     "rowkey_columns": [       {         "column":
> "ACTION_TIME",         "encoding": "time",         "isShardBy": false
>  },       {         "column": "AGENTID",         "encoding": "dict",
>  "isShardBy": false       },       {         "column": "COURSEID",
>  "encoding": "dict",         "isShardBy": false       },       {
>  "column": "COURSEVERSION",         "encoding": "dict",
>  "isShardBy": false       },       {         "column": "IP",
>  "encoding": "dict",         "isShardBy": false       },       {
>  "column": "DAY_TIME",         "encoding": "dict",         "isShardBy":
> false       },       {         "column": "HOUR_TIME",         "encoding":
> "dict",         "isShardBy": false       },       {         "column":
> "MONTH_TIME",         "encoding": "dict",         "isShardBy": false
>  },       {         "column": "YEAR_TIME",         "encoding": "dict",
>    "isShardBy": false       },       {         "column": "RESTYPE",
>  "encoding": "dict",         "isShardBy": false       },       {
>  "column": "RESID",         "encoding": "dict",         "isShardBy": false
>      },       {         "column": "USERID",         "encoding": "dict",
>      "isShardBy": false       },       {         "column": "SEX",
>  "encoding": "dict",         "isShardBy": false       },       {
>  "column": "AGE",         "encoding": "dict",         "isShardBy": false
>    },       {         "column": "RX_PICI",         "encoding": "dict",
>    "isShardBy": false       },       {         "column": "STUDYKIND",
>    "encoding": "dict",         "isShardBy": false       },       {
>  "column": "SUBJECT",         "encoding": "dict",         "isShardBy":
> false       },       {         "column": "FDZ",         "encoding":
> "dict",         "isShardBy": false       },       {         "column":
> "PROVINCENAME",         "encoding": "dict",         "isShardBy": false
>  },       {         "column": "CITYNAME",         "encoding": "dict",
>    "isShardBy": false       }     ]   },   "hbase_mapping": {
>  "column_family": [       {         "name": "F1",         "columns": [
>      {             "qualifier": "M",             "measure_refs": [
>      "_COUNT_"             ]           }         ]       }     ]   },
>  "aggregation_groups": [     {       "includes": [         "ACTION_TIME",
>        "AGENTID",         "COURSEID",         "COURSEVERSION",
>  "YEAR_TIME",         "RESTYPE",         "RESID",         "USERID",
>  "FDZ"       ],       "select_rule": {         "hierarchy_dims": [],
>  "mandatory_dims": [           "ACTION_TIME",           "AGENTID",
>  "COURSEID",           "COURSEVERSION",           "YEAR_TIME",
>  "RESID",           "USERID",           "FDZ",           "RESTYPE"
>  ],         "joint_dims": []       }     }   ],   "signature":
> "OAQ2Qt6vo4CWuAstfTJ4qg==",   "notify_list": [],   "status_need_notify": [
>    "ERROR",     "SUCCEED"   ],   "partition_date_start": 1491436800000,
>  "partition_date_end": 3153600000000,   "auto_merge_time_ranges": [
>  604800000,     2419200000   ],   "retention_range": 0,   "engine_type":
> 2,   "storage_type": 2,   "override_kylin_properties": {} }
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "roger shi";<rogershijich...@hotmail.com>;
> 发送时间: 2017年4月27日(星期四) 中午1:46
> 收件人: "dev"<dev@kylin.apache.org>;
>
> 主题: 答复: Error while executing SQL "select count(*) as nums,courseid from
> optionaction group by courseid LIMIT 50000": null
>
>
>
> More information is required to answer your question. Would you mind to
> attach kylin log and related metadata json?
>
> ________________________________
> 发件人: 35925138 <35925...@qq.com>
> 发送时间: 2017年4月27日 11:32:44
> 收件人: dev
> 主题: Error while executing SQL "select count(*) as nums,courseid from
> optionaction group by courseid LIMIT 50000": null
>
> 你好：       我在构建好cube以后，进行聚合查询，不论使用什么sql，都是返回null
>        请问可能是什么原因，查询使用不到任何cube，
>        我的kylin版本是1.6.0
>
>


-- 
Best regards,

Shaofeng Shi 史少锋