GX validation Result returns broken query "unexpected_index_query"

GX Core Support
1

Using GX 1.2.3 version

we have set result_format as “COMPLETE” and unexpected_index_query to true, we want to use unexpected_index_query to get the error records from dataframe. It seems that it is returning broken query and escaping double quotes.

Example : return unexpected index query by GX : df.filter(F.expr(NOT(city IS NOT NULL)))

and when i execute this query it is giving error syntax error. Invalid syntax

Expected behavior
Executing Query should result into getting error records from dataframe

2

Hi @Jyoti_Thakkar, could you share the query you’re receiving? We’re aware that regex and string values aren’t being quoted automatically and may need manual adjustments to ensure they’re properly quoted (we’re trying to see how we can prioritize adjusting this) However, aside from strings and regex, the rest of the query should be accurate.

3

df.filter(F.expr(NOT(city IS NOT NULL)))