[
https://issues.apache.org/jira/browse/DRILL-3575?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton updated DRILL-3575:
--------------------------------
Description:
Trailing 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:java}
-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:java}
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}
was:
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}
> 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
> Priority: Minor
> Fix For: Future
>
>
> Trailing 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:java}
> -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:java}
> 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
(v8.20.10#820010)
