当分区上的计算完成时,将值传回客户机,然后客户机可以执行简单的聚合计算。
When the calculations are completed on the partition, the values are passed back to the client, where the trivial aggregation calculation can be done.
嵌套的第二个SUM和EXTRACT函数组合计算下限,下限基于前面的片中的值的总数,在映射规则中表示为InSlice Index - 1。
The second, embedded combination of sum and EXTRACT function calculates the lower boundary, which is based on the sum of values in preceding slices, represented in the map rule as InSliceIndex - 1.
对集合排序并返回指定数目的最底部的元素,这些元素的累积合计至少为指定的值。
Sorts a set and returns the specified number of bottommost elements whose cumulative total is at least a specified percentage.
应用推荐