NO_RELEVANT_SQL

[ai-dev-heeddata]

The Ask service fails to generate a relevant SQL query for certain user questions, resulting in a "NO_RELEVANT_SQL" error. This occurs even when the service successfully retrieves relevant table schemas or data snippets.

Steps to reproduce the behavior:

Submit the following query to the Ask service: "What is the average salary of male and female employees grouped by department?"

Observe that the service transitions through the "understanding," "searching," and "planning" states.

The service will then return a "failed" status with the error code "NO_RELEVANT_SQL".

[onlyjackfrost]

NO_RELEVANT_SQL might happened because the sql generated by LLM is not working(invalid function/expression).
Could you help paste the generated SQL statement in the wren-engine container log?