ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.

ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
Cause: In the partition creation / aggmap creation a situation developed such that when aggregating over a particular dimension of the aggmap a partition boundary was crossed such that the sparsity of the target partition included dimensions that were not in the sparsity of the source partition. Since the process of aggregation always densifies rather than sparsifying this is an extremely suboptimal design and it is not supported by the aggregate system.
Action: Set up your partitioning such that for any partition boundary the source and target partitions of the aggregation will always move towards denser partitions. For any child (c) and any parent (p) where (c) and (p) are in different partitions it must be the case that the parent partition contains no dimension in the composite that the child partition does not contain in its composite.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-36260：（XSAGHIERPART00）在分区工作空间对象上从分区％J汇总到分区％J 会导致稀疏性增加。,
.原因：在分区创建/ aggmap创建中，发生了一种情况，使得当聚合在aggmap的特定维度上时，跨越分区边界，使得目标分区的稀疏性包括不在源分区的稀疏性中的维度。由于聚合过程总是密集化而不是稀疏化，这是非常不理想的设计，并且聚合系统不支持。,
.操作：设置分区，以便对于任何分区边界，聚合的源分区和目标分区将始终向更密集的分区移动。对于任何子（c）和任何父（p），其中（c）和（p）在不同的分区中，必须是父分区在复合中不包含子分区在其复合中不包含的维度。,
.

aiaiDBA

13718043309

010-86462881

ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.

1 个回答

相似问题