I have a table chart that, under certain conditions, returns zero results. When that happens, I get a message in the chart that read "Unexpected error". If I click the "see more" link in the error, I get a dialog that reads "list index out of range". If I look at the Network tab in the developer console, I can see that one of the posts returns a 500 with the following response:

{
    "errors": [
        {
            "message": "list index out of range",
            "error_type": "GENERIC_BACKEND_ERROR",
            "level": "error",
            "extra": {
                "issue_codes": [
                    {
                        "code": 1011,
                        "message": "Issue 1011 - Superset encountered an unexpected error."
                    }
                ]
            }
        }
    ]
}

Instead of the error, I expected the chart to display "No results were returned for this query". I have several other charts in the dashboard and they display properly with no error.

I have a table chart that, under certain conditions, returns zero results. When that happens, I get a message in the chart that read "Unexpected error". If I click the "see more" link in the error, I get a dialog that reads "list index out of range". If I look at the Network tab in the developer console, I can see that one of the posts returns a 500 with the following response:

{
    "errors": [
        {
            "message": "list index out of range",
            "error_type": "GENERIC_BACKEND_ERROR",
            "level": "error",
            "extra": {
                "issue_codes": [
                    {
                        "code": 1011,
                        "message": "Issue 1011 - Superset encountered an unexpected error."
                    }
                ]
            }
        }
    ]
}

Instead of the error, I expected the chart to display "No results were returned for this query". I have several other charts in the dashboard and they display properly with no error.

• apache-superset

1 Answer 1

As a workaround, you can add the following to get around the zero results issue:

UNION
select NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL