[jira] [Created] (DRILL-8423) Parquet TIME_MICROS columns with values > Integer.MAX_VALUE are not displayed correctly

["Peter Franzen (Jira)" <ji...@apache.org>]

Peter Franzen created DRILL-8423:
------------------------------------

             Summary: Parquet TIME_MICROS columns with values > Integer.MAX_VALUE are not displayed correctly
                 Key: DRILL-8423
                 URL: https://issues.apache.org/jira/browse/DRILL-8423
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Parquet
    Affects Versions: 1.20.3
            Reporter: Peter Franzen


Assume a parquet file in a directory "Test" with a column _timeCol_ having the type {{{}org.apache.parquet.schema.OriginalType.TIME_MICROS{}}}.

Assume there are two records with the values 2147483647 and 2147483648, respectively, in that column (i.e. the times 00:35:47.483647 and 00:35:47.483648).

Executing the query
{code:java}
SELECT timeCol FROM dfs.Test;{code}
produces the result
{code:java}
timeCol
-------
00:35:47.483
23:24:12.517{code}
i.e. the microsecond value of Integer.MAX_VALUE + 1 has wrapped around when read from the parquet file (it is displayed as the same number of milliseconds before midnight as the time represented by Integer.MAX_VALUE is after midnight)

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)