Superset Drill Time Range Filter

[Z0ltrix]

Hello superset devs,

we have a problem with our superset -> drill connection with time range filters.

When we filter a dashboard by time range (last week, month, etc.) i get an 

SYSTEM ERROR: ClassCastException: 
org.apache.drill.exec.expr.holders.NullableTimeStampHolder cannot be cast to 
org.apache.drill.exec.expr.holders.TimeStampHolder

from drill.

I dont want to talk here too much about the drill error because this is a topic 
for the drill project, but i think we could solve this also by adding something 
to db_engine_specs/drill.py

Superset sends the following to drill:

WHERE `startTime` >= '2022-02-14 00:00:00.000000'
  AND `startTime` < '2022-02-21 00:00:00.000000'
ORDER BY `startTime` DESC

Superset should send the following filter:
WHERE `startTime` >= TIMESTAMP '2022-02-14 00:00:00.000000'
  AND `startTime` < TIMESTAMP '2022-02-21 00:00:00.000000'
ORDER BY `startTime` DESC

My Question is, which classmethod of BaseEngineSpec must be overwritten and 
maybe you could give me a hint how i could do this.
If im aware what to do, i can create a PR for this.

Regards,
Christian

publickey - z0ltrix@pm.me - 0xF0E154C5.asc
Description: application/pgp-keys

signature.asc
Description: OpenPGP digital signature