[ https://issues.apache.org/jira/browse/HIVE-23036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
László Bodor updated HIVE-23036: -------------------------------- Fix Version/s: 4.0.0 > ORC PPD eval with sub-millisecond timestamps > -------------------------------------------- > > Key: HIVE-23036 > URL: https://issues.apache.org/jira/browse/HIVE-23036 > Project: Hive > Issue Type: Sub-task > Reporter: Panagiotis Garefalakis > Assignee: Panagiotis Garefalakis > Priority: Major > Labels: pull-request-available > Fix For: 4.0.0 > > Time Spent: 1h 50m > Remaining Estimate: 0h > > See [ORC-611|https://issues.apache.org/jira/browse/ORC-611] for more details > ORC stores timestamps with: > - nanosecond precision for the data itself > - milliseconds precision for min-max statistics > As both min and max are rounded to the same value, timestamps with ns > precision will not pass the PPD evaluator. > {code:java} > create table tsstat (ts timestamp) stored as orc; > insert into tsstat values ("1970-01-01 00:00:00.0005"); > select * from tsstat where ts = "1970-01-01 00:00:00.0005"; > -- returned 0 rows{code} > ORC PPD evaluation currently happens as part of OrcInputFormat > [https://github.com/apache/hive/blob/7e39a2c13711f9377c9ce1edb4224880421b1ea5/ql/src/java/org/apache/hadoop/hive/ql/io/orc/OrcInputFormat.java#L2314] -- This message was sent by Atlassian Jira (v8.3.4#803005)