You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Khurram Faraaz (JIRA)" <ji...@apache.org> on 2015/07/29 04:17:04 UTC
[jira] [Created] (DRILL-3575) Leading zero missing in result from
post-decimal-point part of TIMESTAMP value
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)