drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Khurram Faraaz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3575) Leading zero missing in result from post-decimal-point part of TIMESTAMP value
Date Wed, 29 Jul 2015 02:17:04 GMT
Khurram Faraaz created DRILL-3575:
-------------------------------------

             Summary: Leading 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: Hanifi Gunes
            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)

Mime
View raw message