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)