Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Timestamp columns now displayed as epoch time #3027

Closed
kelchm opened this issue Jun 23, 2017 · 8 comments · Fixed by #3036
Closed

Timestamp columns now displayed as epoch time #3027

kelchm opened this issue Jun 23, 2017 · 8 comments · Fixed by #3036

Comments

@kelchm
Copy link

kelchm commented Jun 23, 2017

Superset version

v0.18.5

Expected results

Previously, timestamps were displayed in ISO8601 format. Example: 2017-06-20T02:18:26.717000

Actual results

After updating to v0.18.5, timestamp columns are now displayed in epoch time in milliseconds.

Steps to reproduce

I'm using a MSSQL table with a timestamp2 column. Simple create a table view slice that includes this column as one of the "NOT GROUPED BY" columns.

@xrmx
Copy link
Contributor

xrmx commented Jun 23, 2017

Updating from which version?

@jxb45
Copy link

jxb45 commented Jun 23, 2017

same issue. Upgraded from v0.18.4

@ratb3rt
Copy link

ratb3rt commented Jul 10, 2017

I also see this issue when using a DATETIME column in the "Group by" list on 0.18.5

mistercrunch added a commit to mistercrunch/superset that referenced this issue Jul 26, 2017
Bug was present only when using the NOT GROUPED BY option

fixes apache#3027
mistercrunch added a commit that referenced this issue Jul 26, 2017
Bug was present only when using the NOT GROUPED BY option

fixes #3027
lxzhangchao added a commit to lxzhangchao/superset that referenced this issue Aug 2, 2017
Fixing the damn build (apache#3179)

* Fixing the build

* Going deeper

[bugfix] only filterable columns should show up in FilterBox list (apache#3105)

* [bugfix] only filterable columns should show up in FilterBox list

* Touchups

Datasource cannot be empty (apache#3035)

add title description to model view (apache#3045)

* add title description to model view

* add missing import

Add 'show/hide totals' option to pivot table vis (apache#3101)

[bugfix] numeric value for date fields in table viz (apache#3036)

Bug was present only when using the NOT GROUPED BY option

fixes apache#3027

fix hive.fetch_logs (apache#2968)

add Zalando to the list of organizations (apache#3171)

docs: fixup installation examples code indentation (apache#3169)

[bugfix] fix bar order (apache#3180)

[bugfix] visualize flow error: 'Metric x is not valid' (apache#3181)

The metric name in the frontend doesn't match the one generated on the
backend. It turns out the explore view will default to the first
metric so specifying one isn't needed.

Fix the segment interval for pulling metadata (apache#3174)

The end of the interval would be on the truncated today date, which
means that you will exclude today. If your realtime ingestion job
runs shorter than a day, the metadata cannot be pulled from the
druid cluster.

Bump cryptography to 1.9 (apache#3065)

As 1.7.2 doesn't compile here with openssl 1.1.0f

Escaping the user's SQL in the explore view (apache#3186)

* Escaping the user's SQL in the explore view

When executing SQL from SQL Lab, we use a lower level API to the
database which doesn't require escaping the SQL. When going through
the explore view, the stack chain leading to the same method may need
escaping depending on how the DBAPI driver is written, and that is the
case for Presto (and perhaps other drivers).

* Using regex to avoid doubling doubles

[sqllab] improve Hive support (apache#3187)

* [sqllab] improve Hive support

* Fix "Transport not open" bug
* Getting progress bar to show
* Bump pyhive to 0.4.0
* Getting [Track Job] button to show

* Fix testzz

Add BigQuery engine specifications (apache#3193)

As contributed by @mxmzdlv on issue apache#945

[bugfix] fix merge conflict that broke Hive support (apache#3196)

Adding 'apache' to docs (apache#3194)

[druid] Allow custom druid postaggregators (apache#3146)

* [druid] Allow custom druid postaggregators

Also, fix the postaggregation for approxHistogram quantiles so it adds
the dependent field and that can show up in the graphs/tables.

In general, postAggregators add significant power, we should probably
support including custom postAggregators. Plywood has standard
postAggregators here, and a customAggregator escape hatch that allows
you to define custom postAggregators.

This commit adds a similar capability for Superset and a additional
field/fields/fieldName breakdown of the typical naming for dependent
aggregations, which should make it significantly easier to develop
approxHistogram and custom postAggregation-required dashboards.

* [druid] Minor style cleanup in tests file.

* [druid] Apply code review suggestions

* break out CustomPostAggregator into separate class. This just cleans
  up the creation of the postaggregator a little bit.
* minor style issues.
* move the function around so the git diff is more readable

add combine config for metrics in pivot table (apache#3086)

* add combine config for metrics in pivot table

* change method to stack/unstack

* update backendSync

Autofocus search input in VizTypeControl modal onEnter (apache#2929)

Speed up JS build time (apache#3203)

Also bumping a few related libs

JS Translation

JS translations

js translation

fix issue 3204 (apache#3205)

[bugfix] capture Hive job_id pre-url transformation (apache#3213)

js translation

fix issue 3204 (apache#3205)

[bugfix] capture Hive job_id pre-url transformation (apache#3213)

[docs] update url in CONTRIBUTING.md (apache#3212)

[sqllab/cosmetics] add margin-top for labels in query history (apache#3222)

[explore] nvd3 sort values in rich tooltip (apache#3197)

[sqllab] fix UI shows 'The query returned no results' momentarily (apache#3214)

this is visible when running async queries between the fetching and
success state as the rows are getting cached in the component

[explore] DatasourceControl to pick datasource in modal (apache#3210)

* [explore] DatasourceControl to pick datasource in modal

Makes it easier to change datasource, also makes it such that the list
of all datasources doesn't need to be loaded upfront.

* Adding more metadata
@johnphamvan
Copy link

@mistercrunch @RichRadics I was also able to reproduce this in 0.18.5 and 0.19.0 (from pip) by using a DATETIME in the GROUP BY and without "NOT GROUPED BY". Can you please reconsider reopening this issue?

mistercrunch pushed a commit that referenced this issue Sep 20, 2017
* Chinese page

* Using react-intl-universal to improve multi language in react page

* Using react-intl-universal to improve multi language in react page

* react_intl_universal

* change

* change

* change

* change

* change

* change

* change

* merge

* multiple page in js

* merge

* merge

* merge

* merge

* Js Translations

* JS Translation

* JS Translations

* Js translation

* JS translations

* JS translations

* Js translaion

* JS en Translation

* JS Translation

* upgrade document

Fixing the damn build (#3179)

* Fixing the build

* Going deeper

[bugfix] only filterable columns should show up in FilterBox list (#3105)

* [bugfix] only filterable columns should show up in FilterBox list

* Touchups

Datasource cannot be empty (#3035)

add title description to model view (#3045)

* add title description to model view

* add missing import

Add 'show/hide totals' option to pivot table vis (#3101)

[bugfix] numeric value for date fields in table viz (#3036)

Bug was present only when using the NOT GROUPED BY option

fixes #3027

fix hive.fetch_logs (#2968)

add Zalando to the list of organizations (#3171)

docs: fixup installation examples code indentation (#3169)

[bugfix] fix bar order (#3180)

[bugfix] visualize flow error: 'Metric x is not valid' (#3181)

The metric name in the frontend doesn't match the one generated on the
backend. It turns out the explore view will default to the first
metric so specifying one isn't needed.

Fix the segment interval for pulling metadata (#3174)

The end of the interval would be on the truncated today date, which
means that you will exclude today. If your realtime ingestion job
runs shorter than a day, the metadata cannot be pulled from the
druid cluster.

Bump cryptography to 1.9 (#3065)

As 1.7.2 doesn't compile here with openssl 1.1.0f

Escaping the user's SQL in the explore view (#3186)

* Escaping the user's SQL in the explore view

When executing SQL from SQL Lab, we use a lower level API to the
database which doesn't require escaping the SQL. When going through
the explore view, the stack chain leading to the same method may need
escaping depending on how the DBAPI driver is written, and that is the
case for Presto (and perhaps other drivers).

* Using regex to avoid doubling doubles

[sqllab] improve Hive support (#3187)

* [sqllab] improve Hive support

* Fix "Transport not open" bug
* Getting progress bar to show
* Bump pyhive to 0.4.0
* Getting [Track Job] button to show

* Fix testzz

Add BigQuery engine specifications (#3193)

As contributed by @mxmzdlv on issue #945

[bugfix] fix merge conflict that broke Hive support (#3196)

Adding 'apache' to docs (#3194)

[druid] Allow custom druid postaggregators (#3146)

* [druid] Allow custom druid postaggregators

Also, fix the postaggregation for approxHistogram quantiles so it adds
the dependent field and that can show up in the graphs/tables.

In general, postAggregators add significant power, we should probably
support including custom postAggregators. Plywood has standard
postAggregators here, and a customAggregator escape hatch that allows
you to define custom postAggregators.

This commit adds a similar capability for Superset and a additional
field/fields/fieldName breakdown of the typical naming for dependent
aggregations, which should make it significantly easier to develop
approxHistogram and custom postAggregation-required dashboards.

* [druid] Minor style cleanup in tests file.

* [druid] Apply code review suggestions

* break out CustomPostAggregator into separate class. This just cleans
  up the creation of the postaggregator a little bit.
* minor style issues.
* move the function around so the git diff is more readable

add combine config for metrics in pivot table (#3086)

* add combine config for metrics in pivot table

* change method to stack/unstack

* update backendSync

Autofocus search input in VizTypeControl modal onEnter (#2929)

Speed up JS build time (#3203)

Also bumping a few related libs

JS Translation

JS translations

js translation

fix issue 3204 (#3205)

[bugfix] capture Hive job_id pre-url transformation (#3213)

js translation

fix issue 3204 (#3205)

[bugfix] capture Hive job_id pre-url transformation (#3213)

[docs] update url in CONTRIBUTING.md (#3212)

[sqllab/cosmetics] add margin-top for labels in query history (#3222)

[explore] nvd3 sort values in rich tooltip (#3197)

[sqllab] fix UI shows 'The query returned no results' momentarily (#3214)

this is visible when running async queries between the fetching and
success state as the rows are getting cached in the component

[explore] DatasourceControl to pick datasource in modal (#3210)

* [explore] DatasourceControl to pick datasource in modal

Makes it easier to change datasource, also makes it such that the list
of all datasources doesn't need to be loaded upfront.

* Adding more metadata

* Js translation

* js tran

* js trans

* js trans

* js tran

* js trans

* js trans

* js tran

* js translation

* js trans

* js translation

* try load language pack async

* Backend translations things

* create language pack inside common data

* performance improvement for js i18n.

- js bundle should not contain localized content
- we populate translation content from server-side, in boostrap.common.language_pack
- in client-side, use promise to wrap around translation content. text will be translated after translation content arrived/parsed.
- fix linting

* fix Timer unit test

* 1. add global hook for all tests, to make translation pack avaialble before each test starts.
2. fix unit test for Timer component
3. remove noused method get_locale, and modules
4. fix page reload after user change page language

* parse and build i18n dictionary as a module

* fix sync-backend task, which should run without DOM
timifasubaa pushed a commit to timifasubaa/incubator-superset that referenced this issue Oct 3, 2017
* Chinese page

* Using react-intl-universal to improve multi language in react page

* Using react-intl-universal to improve multi language in react page

* react_intl_universal

* change

* change

* change

* change

* change

* change

* change

* merge

* multiple page in js

* merge

* merge

* merge

* merge

* Js Translations

* JS Translation

* JS Translations

* Js translation

* JS translations

* JS translations

* Js translaion

* JS en Translation

* JS Translation

* upgrade document

Fixing the damn build (apache#3179)

* Fixing the build

* Going deeper

[bugfix] only filterable columns should show up in FilterBox list (apache#3105)

* [bugfix] only filterable columns should show up in FilterBox list

* Touchups

Datasource cannot be empty (apache#3035)

add title description to model view (apache#3045)

* add title description to model view

* add missing import

Add 'show/hide totals' option to pivot table vis (apache#3101)

[bugfix] numeric value for date fields in table viz (apache#3036)

Bug was present only when using the NOT GROUPED BY option

fixes apache#3027

fix hive.fetch_logs (apache#2968)

add Zalando to the list of organizations (apache#3171)

docs: fixup installation examples code indentation (apache#3169)

[bugfix] fix bar order (apache#3180)

[bugfix] visualize flow error: 'Metric x is not valid' (apache#3181)

The metric name in the frontend doesn't match the one generated on the
backend. It turns out the explore view will default to the first
metric so specifying one isn't needed.

Fix the segment interval for pulling metadata (apache#3174)

The end of the interval would be on the truncated today date, which
means that you will exclude today. If your realtime ingestion job
runs shorter than a day, the metadata cannot be pulled from the
druid cluster.

Bump cryptography to 1.9 (apache#3065)

As 1.7.2 doesn't compile here with openssl 1.1.0f

Escaping the user's SQL in the explore view (apache#3186)

* Escaping the user's SQL in the explore view

When executing SQL from SQL Lab, we use a lower level API to the
database which doesn't require escaping the SQL. When going through
the explore view, the stack chain leading to the same method may need
escaping depending on how the DBAPI driver is written, and that is the
case for Presto (and perhaps other drivers).

* Using regex to avoid doubling doubles

[sqllab] improve Hive support (apache#3187)

* [sqllab] improve Hive support

* Fix "Transport not open" bug
* Getting progress bar to show
* Bump pyhive to 0.4.0
* Getting [Track Job] button to show

* Fix testzz

Add BigQuery engine specifications (apache#3193)

As contributed by @mxmzdlv on issue apache#945

[bugfix] fix merge conflict that broke Hive support (apache#3196)

Adding 'apache' to docs (apache#3194)

[druid] Allow custom druid postaggregators (apache#3146)

* [druid] Allow custom druid postaggregators

Also, fix the postaggregation for approxHistogram quantiles so it adds
the dependent field and that can show up in the graphs/tables.

In general, postAggregators add significant power, we should probably
support including custom postAggregators. Plywood has standard
postAggregators here, and a customAggregator escape hatch that allows
you to define custom postAggregators.

This commit adds a similar capability for Superset and a additional
field/fields/fieldName breakdown of the typical naming for dependent
aggregations, which should make it significantly easier to develop
approxHistogram and custom postAggregation-required dashboards.

* [druid] Minor style cleanup in tests file.

* [druid] Apply code review suggestions

* break out CustomPostAggregator into separate class. This just cleans
  up the creation of the postaggregator a little bit.
* minor style issues.
* move the function around so the git diff is more readable

add combine config for metrics in pivot table (apache#3086)

* add combine config for metrics in pivot table

* change method to stack/unstack

* update backendSync

Autofocus search input in VizTypeControl modal onEnter (apache#2929)

Speed up JS build time (apache#3203)

Also bumping a few related libs

JS Translation

JS translations

js translation

fix issue 3204 (apache#3205)

[bugfix] capture Hive job_id pre-url transformation (apache#3213)

js translation

fix issue 3204 (apache#3205)

[bugfix] capture Hive job_id pre-url transformation (apache#3213)

[docs] update url in CONTRIBUTING.md (apache#3212)

[sqllab/cosmetics] add margin-top for labels in query history (apache#3222)

[explore] nvd3 sort values in rich tooltip (apache#3197)

[sqllab] fix UI shows 'The query returned no results' momentarily (apache#3214)

this is visible when running async queries between the fetching and
success state as the rows are getting cached in the component

[explore] DatasourceControl to pick datasource in modal (apache#3210)

* [explore] DatasourceControl to pick datasource in modal

Makes it easier to change datasource, also makes it such that the list
of all datasources doesn't need to be loaded upfront.

* Adding more metadata

* Js translation

* js tran

* js trans

* js trans

* js tran

* js trans

* js trans

* js tran

* js translation

* js trans

* js translation

* try load language pack async

* Backend translations things

* create language pack inside common data

* performance improvement for js i18n.

- js bundle should not contain localized content
- we populate translation content from server-side, in boostrap.common.language_pack
- in client-side, use promise to wrap around translation content. text will be translated after translation content arrived/parsed.
- fix linting

* fix Timer unit test

* 1. add global hook for all tests, to make translation pack avaialble before each test starts.
2. fix unit test for Timer component
3. remove noused method get_locale, and modules
4. fix page reload after user change page language

* parse and build i18n dictionary as a module

* fix sync-backend task, which should run without DOM
michellethomas pushed a commit to michellethomas/panoramix that referenced this issue May 24, 2018
* Chinese page

* Using react-intl-universal to improve multi language in react page

* Using react-intl-universal to improve multi language in react page

* react_intl_universal

* change

* change

* change

* change

* change

* change

* change

* merge

* multiple page in js

* merge

* merge

* merge

* merge

* Js Translations

* JS Translation

* JS Translations

* Js translation

* JS translations

* JS translations

* Js translaion

* JS en Translation

* JS Translation

* upgrade document

Fixing the damn build (apache#3179)

* Fixing the build

* Going deeper

[bugfix] only filterable columns should show up in FilterBox list (apache#3105)

* [bugfix] only filterable columns should show up in FilterBox list

* Touchups

Datasource cannot be empty (apache#3035)

add title description to model view (apache#3045)

* add title description to model view

* add missing import

Add 'show/hide totals' option to pivot table vis (apache#3101)

[bugfix] numeric value for date fields in table viz (apache#3036)

Bug was present only when using the NOT GROUPED BY option

fixes apache#3027

fix hive.fetch_logs (apache#2968)

add Zalando to the list of organizations (apache#3171)

docs: fixup installation examples code indentation (apache#3169)

[bugfix] fix bar order (apache#3180)

[bugfix] visualize flow error: 'Metric x is not valid' (apache#3181)

The metric name in the frontend doesn't match the one generated on the
backend. It turns out the explore view will default to the first
metric so specifying one isn't needed.

Fix the segment interval for pulling metadata (apache#3174)

The end of the interval would be on the truncated today date, which
means that you will exclude today. If your realtime ingestion job
runs shorter than a day, the metadata cannot be pulled from the
druid cluster.

Bump cryptography to 1.9 (apache#3065)

As 1.7.2 doesn't compile here with openssl 1.1.0f

Escaping the user's SQL in the explore view (apache#3186)

* Escaping the user's SQL in the explore view

When executing SQL from SQL Lab, we use a lower level API to the
database which doesn't require escaping the SQL. When going through
the explore view, the stack chain leading to the same method may need
escaping depending on how the DBAPI driver is written, and that is the
case for Presto (and perhaps other drivers).

* Using regex to avoid doubling doubles

[sqllab] improve Hive support (apache#3187)

* [sqllab] improve Hive support

* Fix "Transport not open" bug
* Getting progress bar to show
* Bump pyhive to 0.4.0
* Getting [Track Job] button to show

* Fix testzz

Add BigQuery engine specifications (apache#3193)

As contributed by @mxmzdlv on issue apache#945

[bugfix] fix merge conflict that broke Hive support (apache#3196)

Adding 'apache' to docs (apache#3194)

[druid] Allow custom druid postaggregators (apache#3146)

* [druid] Allow custom druid postaggregators

Also, fix the postaggregation for approxHistogram quantiles so it adds
the dependent field and that can show up in the graphs/tables.

In general, postAggregators add significant power, we should probably
support including custom postAggregators. Plywood has standard
postAggregators here, and a customAggregator escape hatch that allows
you to define custom postAggregators.

This commit adds a similar capability for Superset and a additional
field/fields/fieldName breakdown of the typical naming for dependent
aggregations, which should make it significantly easier to develop
approxHistogram and custom postAggregation-required dashboards.

* [druid] Minor style cleanup in tests file.

* [druid] Apply code review suggestions

* break out CustomPostAggregator into separate class. This just cleans
  up the creation of the postaggregator a little bit.
* minor style issues.
* move the function around so the git diff is more readable

add combine config for metrics in pivot table (apache#3086)

* add combine config for metrics in pivot table

* change method to stack/unstack

* update backendSync

Autofocus search input in VizTypeControl modal onEnter (apache#2929)

Speed up JS build time (apache#3203)

Also bumping a few related libs

JS Translation

JS translations

js translation

fix issue 3204 (apache#3205)

[bugfix] capture Hive job_id pre-url transformation (apache#3213)

js translation

fix issue 3204 (apache#3205)

[bugfix] capture Hive job_id pre-url transformation (apache#3213)

[docs] update url in CONTRIBUTING.md (apache#3212)

[sqllab/cosmetics] add margin-top for labels in query history (apache#3222)

[explore] nvd3 sort values in rich tooltip (apache#3197)

[sqllab] fix UI shows 'The query returned no results' momentarily (apache#3214)

this is visible when running async queries between the fetching and
success state as the rows are getting cached in the component

[explore] DatasourceControl to pick datasource in modal (apache#3210)

* [explore] DatasourceControl to pick datasource in modal

Makes it easier to change datasource, also makes it such that the list
of all datasources doesn't need to be loaded upfront.

* Adding more metadata

* Js translation

* js tran

* js trans

* js trans

* js tran

* js trans

* js trans

* js tran

* js translation

* js trans

* js translation

* try load language pack async

* Backend translations things

* create language pack inside common data

* performance improvement for js i18n.

- js bundle should not contain localized content
- we populate translation content from server-side, in boostrap.common.language_pack
- in client-side, use promise to wrap around translation content. text will be translated after translation content arrived/parsed.
- fix linting

* fix Timer unit test

* 1. add global hook for all tests, to make translation pack avaialble before each test starts.
2. fix unit test for Timer component
3. remove noused method get_locale, and modules
4. fix page reload after user change page language

* parse and build i18n dictionary as a module

* fix sync-backend task, which should run without DOM
@rohanagg
Copy link

Is the issue is resolved ?

@suneet-pit
Copy link

Is the issue resolved?

@FedericoCalonge
Copy link

Is the issue resolved?

@villebro
Copy link
Member

villebro commented Mar 4, 2021

TO my knowledge yes - feel free to open a new ticket if this is not the case, either latest stable release (1.0.1) or master branch.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

9 participants