[GitHub] minh5 opened a new issue #5312: Time Column is in UNIX timestamp format rather than native date

Thu, 28 Jun 2018 10:08:11 -0700 

minh5 opened a new issue #5312: Time Column is in UNIX timestamp format rather 
than native date
URL: https://github.com/apache/incubator-superset/issues/5312
 
 
   I am trying to group by my date column, `day`, and when I see the resulting 
table, I noticed the columns are converted to UNIX timestamps.
   
   <img width="1421" alt="screen shot 2018-06-28 at 12 36 12 pm" 
src="https://user-images.githubusercontent.com/7282400/42049248-69769dae-7ad3-11e8-8711-47c137a74b48.png";>
   
   However, when I run the exact same query in the SQL lab I get the results I 
was anticipating
   
   <img width="1427" alt="screen shot 2018-06-28 at 12 58 42 pm" 
src="https://user-images.githubusercontent.com/7282400/42049323-9fd4a9cc-7ad3-11e8-9496-9273a754691a.png";>
   
   **- [x] I have checked the superset logs for python stacktraces and included 
it here as text if any**
   ```
   2018-06-28 13:02:27,534:DEBUG:root:[stats_logger] (incr) explore_json
   2018-06-28 13:02:27,534:INFO:werkzeug:127.0.0.1 - - [28/Jun/2018 13:02:27] 
"GET /static/assets/images/loading.gif HTTP/1.1" 200 -
   2018-06-28 13:02:27,604:INFO:root:Cache key: 936ec23d1cc9b7709db6495a5808366e
   2018-06-28 13:02:27,608:INFO:root:Database.get_sqla_engine(). Masked URL: 
redshift+psycopg2://user:[email protected]:5439/testdb
   2018-06-28 13:02:27,619:INFO:root:SELECT day AS day, SUM(itemsales) AS 
"SUM(itemsales)"
   FROM view.daily_store_sales_adj
   WHERE day >= '2017-11-28 00:00:00' AND day <= '2018-06-28 13:02:27' GROUP BY 
day ORDER BY "SUM(itemsales)" DESC
    LIMIT 10000
   2018-06-28 13:02:27,625:INFO:root:Database.get_sqla_engine(). Masked URL: 
redshift+psycopg2://user:[email protected]:5439/testdb
   2018-06-28 13:02:28,524:DEBUG:root:[stats_logger] (incr) loaded_from_source
   2018-06-28 13:02:28,538:INFO:werkzeug:127.0.0.1 - - [28/Jun/2018 13:02:28] 
"POST /superset/explore_json/ HTTP/1.1" 200 -
   ```
   **- [x] I have reproduced the issue with at least the latest released 
version of superset**
   **-** [x] I have checked the issue tracker for the same issue and I haven't 
found one similar**
   
   
   ### Superset version
   superset==0.25.6
   
   ### Expected results
   I expected when doing a group by of my dataset that the output would be 
formatted the same as the date in my database rather than converted to UNIX 
timestamps
   
   ### Actual results
   My dates are converted to UNIX timestamps
   
   ### Steps to reproduce
   Create a table that is grouped by time.
   
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
[email protected]


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to