You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2016/02/04 00:01:39 UTC
[jira] [Commented] (CALCITE-1072) CSV adapter incorrectly parses
TIMESTAMP values after noon
[ https://issues.apache.org/jira/browse/CALCITE-1072?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15131327#comment-15131327 ]
Julian Hyde commented on CALCITE-1072:
--------------------------------------
[~ChrisAlbright], I only just noticed your pull request, https://github.com/apache/calcite/pull/190. Sorry I didn't see it - I would have liked the git commit record to give you credit for tracking this down and fixing it. I can't change the git commit record now, but I'll give you credit in the release notes.
> CSV adapter incorrectly parses TIMESTAMP values after noon
> ----------------------------------------------------------
>
> Key: CALCITE-1072
> URL: https://issues.apache.org/jira/browse/CALCITE-1072
> Project: Calcite
> Issue Type: Bug
> Reporter: Chris Albright
> Assignee: Julian Hyde
> Fix For: 1.7.0
>
>
> When querying timestamp data using the CSV adapter, the time is always in A.M.
> for example this input file: EXAMPLE_DATA.csv
> ID:long,START:timestamp,END:timestamp
> 1,"2015-12-31 07:15:56","2015-12-31 13:31:21"
> yields this output in sqlline:
> select * from example_data;
> | ID | START | END |
> | 1 | 2015-12-31 07:15:56 | 2015-12-31 01:31:21 |
> The bug appears to be in org.apache.calcite.adapter.csv.CsvEnumerator on lines 59 and 60. The parse formats use 'hh' instead of 'HH' for the hour part.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)