Done -> https://github.com/apache/superset/issues/18869
------- Original Message ------- Ville Brofeldt <ville.v.brofe...@gmail.com> schrieb am Mittwoch, 23. Februar 2022 um 11:01: > 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 z0lt...@pm.me.INVALID 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 - z0lt...@pm.me - 0xF0E154C5.asc>
publickey - z0ltrix@pm.me - 0xF0E154C5.asc
Description: application/pgp-keys
signature.asc
Description: OpenPGP digital signature