When we are using specific date filter on Databricks Database, it is throwing below error:
[Databricks]DatabricksJDBCDriver ERROR processing query/statement. Error Code: 0, SQL state: org.apache.hive.service.cli.HiveSQLException: Error running query: [PARSE_SYNTAX_ERROR] org.apache.spark.sql.catalyst.parser.ParseException:
[PARSE_SYNTAX_ERROR] Syntax error at or near 'with'.(line 2, pos 5691)
Basically it is trying to cast date column like in the code below (view the sql preview):
= CAST(
timestamp with time zone '2024-02-14 00:00:00.000Z' AS timestamp
All other filters are working fine - yesterday, today, last 10 days etc