[BUG] Partial result returned when shard search task cancelled

[dai-chen]

What is the bug?

DSL response returns how many shard search task cancelled/failed. However, SQL plugin seems not check this and just return the partial result to user.

How can one reproduce the bug?

Need shard search failed to reproduce this issue.

What is the expected behavior?

1.If this is expected for most cases
2.If not
a. Throw exception if any failed shard if this is expected behavior in any case
b. Or provide a query parameter for query that require full result

What is your host/environment?

• Version: OpenSearch 2.7
• Plugins