Dear Community, I want to propose the addition of the Interval types to the Iceberg spec. A value of an Interval type represents a duration of time, and can be calculated by the difference between two dates or times. Intervals are supported across a variety of different engines (e.g. Parquet, Spark, Arrow, Oracle, Snowflake) and are widely used in time-series analysis for calculations and comparisons of time spans and date arithmetic.
For more information, see this high-level proposal <https://docs.google.com/document/d/12ghQxWxyAhSQeZyy0IWiwJ02gTqFOgfYm8x851HZFLk/edit?usp=sharing> providing a recommendation to build Interval types in Iceberg following the ANSI SQL standard specification. Per ANSI SQL standard, this proposal recommends the creation of two types of Intervals: Year-Month and Day-Time Intervals. The linked document also details the implementations of Interval types in various engines and is intended to spur discussion in the Iceberg community. Thanks, Naren Krishna
