Hi Christian, you should be able to change how dates/datetimes/timestamps are formatted for Drill connections here: https://github.com/apache/superset/blob/700829b74ae7093a3985b44a45376973a48eb1fe/superset/db_engine_specs/drill.py#L57-L67 <https://github.com/apache/superset/blob/700829b74ae7093a3985b44a45376973a48eb1fe/superset/db_engine_specs/drill.py#L57-L67>
However, it appears you’re not hitting either of those formatters, so there might actually be a bug that we need to look into. Please feel free to open up a bug ticket on GitHub so we can continue the discussion there. Ville > On 23. Feb 2022, at 11.49, Z0ltrix <[email protected]> wrote: > > 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 - [email protected] - 0xF0E154C5.asc>
