unexpected_rows only has a sample of 200 rows.

[anjujoy564-ai]

Is your feature request related to a problem? Please describe.
I am using unexpected_list in validation result to find out invalid records in ExpectCompoundColumnsToBeUnique expectation. But I am only getting 200 invalid rows rest invalid rows are eliminated from result.

Describe the solution you'd like
Remove this limitation on unexpected_list, or introduce some other key which can hold all invalid records.

[NhanHoThanh]

I think this issuse has been documented in the docs:

I would still like to see it addressed, though the design may be intentional. In the meantime, a practical workaround is to use unexpected_index_query to retrieve all unexpected records.

[anjujoy564-ai]

unexpected_index_query looks like below for ExpectCompoundColumnsToBeUnique expectation:
df.filter(F.expr(Column<'!(<=(count(1) OVER (PARTITION BY struct(col1, col2) unspecifiedframe$()), 1)))

Which language is this? Also I am getting 'unterminated string literal' error while using this query in sparkdataframe.