Superset - NaTType does not support utcoffset

[mod-tran]

Hi team,

I have issue about select data dremio from superset.

Column type in table is date but some have null value. Then my superset got this error

Dremio Error
NaTType does not support utcoffset

This may be triggered by:
Issue 1002 - The database returned an unexpected error.

See less

Pls help me. tks

[mod-tran]

Hi,
When coalesce(SO_DATE,0) it's ok. column result is 1970-01-01T00:00:00. But I don't need it.
I want it to be null.

[stepcheunghk]

Hi @mod-tran , I have also faced this issue. How did you fix it?

[stepcheunghk]

Hi, When coalesce(SO_DATE,0) it's ok. column result is 1970-01-01T00:00:00. But I don't need it. I want it to be null.

As a workaround, if you want to be null, you can try to convert datetime to date.
TO_DATE(SO_DATE)