[
https://issues.apache.org/jira/browse/DRILL-3575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Khurram Faraaz updated DRILL-3575:
----------------------------------
Summary: Trailing zero missing in result from post-decimal-point part of
TIMESTAMP value (was: Leading zero missing in result from post-decimal-point
part of TIMESTAMP value)
> Trailing zero missing in result from post-decimal-point part of TIMESTAMP
> value
> -------------------------------------------------------------------------------
>
> Key: DRILL-3575
> URL: https://issues.apache.org/jira/browse/DRILL-3575
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 1.2.0
> Environment: 4 node cluster on CentOS
> Reporter: Khurram Faraaz
> Assignee: Mehant Baid
> Priority: Minor
>
> Leading zero missing from post-decimal-point part of timestamp value in the
> results returned by Drill.
> Data snippet from CSV file that has the TIMESTAMP values, for which we do not
> print/return leading zeroes in the result (from post-decimal-point part of
> timestamp)
> {code}
> -104,4728,ND,GXXXXXXXXXXXXXXXXXXXXXXXXXHXXXXXXXXXXXXXXXXXXXXXXXXI,2014-06-02
> 00:28:02.420,1991-05-13,true,1293541.37,20:52:8.56
> -104,4728,ND,GXXXXXXXXXXXXXXXXXXXXXXXXXHXXXXXXXXXXXXXXXXXXXXXXXXI,2014-06-02
> 00:28:02.420,1991-05-13,true,1293541.37,20:52:8.56
> -121,3888,SD,HXXXXXXXXXXXXXXXXXXXXXXXXXIXXXXXXXXXXXXXXXXXXXXXXXXJ,2014-06-02
> 00:28:02.420,1965-02-21,false,98362.924,19:46:10.42
> -409,376,MN,DXXXXXXXXXXXXXXXXXXXXXXXXXEXXXXXXXXXXXXXXXXXXXXXXXXF,2014-06-02
> 00:28:02.420,2003-09-03,false,466679.327,15:21:34.39
> {code}
> Results returned by Drill, notice that zero after 42 is missing from the
> results, it is present in the input (which is coming from parquet file that
> was created using CSV input)
> column c5 is of type TIMESTAMP
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select c5 from union_01;
> +--------------------------+
> | c5 |
> +--------------------------+
> | 2014-06-02 00:28:02.418 |
> | 2014-06-02 00:28:02.418 |
> ...
> | 2014-06-02 00:28:02.42 |
> | 2014-06-02 00:28:02.42 |
> | 2014-06-02 00:28:02.42 |
> | 2014-06-02 00:28:02.42 |
> | 2014-06-02 00:28:02.421 |
> ...
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
