apache / apache/parquet-format

Add INTERVAL_YEAR_MONTH and INTERVAL_DAY_TIME types

Open
#313 1 comment 0 reactions 0 assignees View on GitHub
Priority: Major Type: enhancement
Dominant language
Thrift
Stars
2.6k
Forks
508
Avg merge
2d 8h
Merged PRs (30d)
4

Description

For completeness and compatibility with Arrow and SQL types.
Those are related to the existing INTERVAL type.
some references:
- https://msdn.microsoft.com/en-us/library/ms716506(v=vs.85).aspx
- http://www.techrepublic.com/article/sql-basics-datetime-and-interval-data-types/
- https://www.postgresql.org/docs/9.3/static/datatype-datetime.html
- https://docs.oracle.com/html/E26088_01/sql_elements001.htm
- http://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqlr.doc/ids_sqr_123.htm

**Reporter**: [Julien Le Dem](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=julienledem) / @julienledem
**Assignee**: [Julien Le Dem](https://issues.apache.org/jira/secure/ViewProfile.jspa?name=julienledem) / @julienledem
#### Related issues:
- [Add NULL type to Bring Parquet logical types to par with Arrow](https://github.com/apache/parquet-format/issues/268) (blocks)
#### PRs and other links:
- [PR](https://github.com/apache/parquet-format/pull/43)

**Note**: *This issue was originally created as [PARQUET-675](https://issues.apache.org/jira/browse/PARQUET-675). Please see the [migration documentation](https://issues.apache.org/jira/browse/PARQUET-2502) for further details.*

Contributor guide

Open the contributing guide

Research direction

No file or test is named. Start by locating the existing INTERVAL type definition in the parquet-format repository, then review PR 43 and the linked Arrow and SQL references. Done means adding INTERVAL_YEAR_MONTH and INTERVAL_DAY_TIME with compatibility alongside the existing INTERVAL type.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
data-engineering
Issue type
Feature
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Mostly clear
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.