OLAP queries typically aggregate many rows of the fact table into a relatively small number of summary results.
OLAP 查询通常将事实表的许多行聚合成一个相对少量的汇总结果。
In V8, the predicate was not pushed down to CF, and nearly one million rows had to be moved to the federated server to evaluate the predicate and perform the aggregate.
在V 8中,谓词没有被下推到CF,为了计算谓词和执行聚合,需要将大约1百万个行移动到联邦服务器。
To display the number of job applications containing a skill, change the aggregate function of the ID columns by selecting the ID columns of the crosstab (select the headers, not the rows below).
要显示包含某项技能的职位申请的数量,选择cross选项卡的id列(不是选择标题,而是选择标题下方的列),修改id列的聚合函数。
应用推荐