Sangmin Yoon created ZEPPELIN-1523:
--------------------------------------

             Summary: Date strings are shown incorrectly in graph.
                 Key: ZEPPELIN-1523
                 URL: https://issues.apache.org/jira/browse/ZEPPELIN-1523
             Project: Zeppelin
          Issue Type: Bug
          Components: front-end
    Affects Versions: 0.7.0
            Reporter: Sangmin Yoon


{code}
%jdbc
select '2016-09-01' as date, 10 as count
{code}

If you input above, and see the graph, the date is shown as 'Thu Sep 01 2016  
00:00:00  GTM+09:00'.
(And if you export table as csv, dates become getTime() values)

This problem was created by https://issues.apache.org/jira/browse/ZEPPELIN-1372.
Every date string is converted to a moment instance, so date is displayed as 
above.

I think automatic date detection is unnecessary unlike number detection.

I think mixed date format (like 11/30/2015 and 2014-05-06) is not common,
and if the date format is same, dates can be sorted without converting to 
moment instances.

For verbose date strings (e.g. 19/Sep/16), it may be better to add option like 
https://issues.apache.org/jira/browse/ZEPPELIN-1371 than automatic detection.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to