Changed of Date to epoch time in Table view - Superset - 0.25.6

[rohanagg]

Make sure these boxes are checked before submitting your issue - thank you!

• I have checked the superset logs for python stacktraces and included it here as text if any
• I have reproduced the issue with at least the latest released version of superset
• I have checked the issue tracker for the same issue and I haven't found one similar

Superset version

0.25.6

Expected results

Expected result in 0.17.6 is :

Actual results

Actual result which I am getting in 0.25.6 is :

Steps to reproduce

Open the slice and select the table view.
In the group by select any column with date as datatype
select any metric against it.
Output is epoch time against the metric

[rumbin]

@rohanagg I remember that this issue had been reported multiple times by now. However, I haven't looked up whether it has been fixed meanwhile and happened to reappear, or if your report is a duplicate.

Could you do the research, please?

[llozanoc]

I'm having the same problem with the timestamp types and Table views

This problem is reported in the issue #3027 for the "NOT GROUPED BY" colums, but in my case I'm selecting a timestamp value in the group by.

Anyway without grouping by date the problem persists.

However, with a Distribution - Bar Chart , the format of the date is correct

[amzhang]

+1

[csc5k]

+1

[rohanagg]

Issue still exists in Version 26.3.. Table view shows date in epoch format.. While it is solved in case of Pivot view

Table View -

Pivot View -

Are we doing anything to cater such things in future versions. Our company runs on Superset but because of such issues it becomes hectic for business owner to get attached to Superset as a visualisation tool

[rohanagg]

Can someone help here. As it is becoming blocker for day to day activity and we are not able to superset to latest version

[awsiotdemo]

+1

[ngoclong19]

A temporary solution is casting the date to string. We create an additional dimension with this expression TO_CHAR(date, 'yyyy/mm/dd').

[kakoni]

Still present in 0.29. It is caused by this commit
0ec9cd4

Basically datetime date field gets formatted by BaseViz.json_dumps that uses json_int_dttm_ser serializer which turns date into epoch.

@mistercrunch I guess that commit fixed non grouped options, but in turn broke grouped.
What happens if one would only do

    def json_dumps(self, obj, sort_keys=False):
        return json.dumps(
            obj,
            default=utils.json_iso_dttm_ser,
            sort_keys=sort_keys,
            ignore_nan=True
        )

in tableviz ?