Records count from Analytic View getting reduced after Hash partitioning

[former_member182302]

Hi All,

I have a table which is joined to the fact table on Column 'X'. And the Primary key of the table is 'X'.

After I have done the hash partitioning on X, the record count from the query on the Analytic View is reducing.

Couldn't able to paste the code/ write the exact names here as the names have sensitive information.

Any thoughts on this?

Regards,

Krishna Tangudu

[former_member182302]

In continuation with the above question:

1) Analytic View has a join (Inner Join ) between Header and line table on Header Id.

Before Partitioning , we are getting the record counts correctly.

2) After Partitioning, Still we are getting the record counts correctly unless we are selecting a column from the Header Table.

So trying to understand why partitioning should really effect the record count here?

Regards,

Krishna Tangudu

[former_member182302]

Hi Guys,

The issue is currently still open for us in production.

The results for group by query on Analytic view is changing the result when I partition one of the underlying table .

Anybody else faced the similar issue? Any thoughts on this?

PS: We raised a support incident for this issue now.

Regards,

Krishna Tangudu