getting syntax error with the sql generated by Spotfire

Below query was generated by Spotfire automatically when prompts are added on the column "date_type".

SELECT DISTINCT d1."date_type" AS "DATETYPE" FROM "Impala"."tatasky_prod"."deletion_wise_aggregation_data" d1 WHERE (d1."date_type" IS NOT NULL) ORDER BY "DATETYPE"

Getting below JDBC error while refreshing the report.

Failed to execute query: [Simba][ImpalaJDBCDriver](500051) ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:
ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Syntax error in line 1:

SELECT DISTINCT d1."date_type" AS "DATETYPE" FR...
^
Encountered: STRING LITERAL
Expected: IDENTIFIER

CAUSED BY: Exception: Syntax error
), Query:
SELECT DISTINCT d1."date_type" AS "DATETYPE" FROM "Impala"."tatasky_prod"."deletion_wise_aggregation_data" d1 WHERE (d1."date_type" IS NOT NULL) ORDER BY "DATETYPE". (HRESULT: 80131509)