[ https://issues.apache.org/jira/browse/DRILL-2297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal resolved DRILL-2297. ---------------------------- Resolution: Fixed This problem is fixed in the current drill-1.3 > INTERVAL YEAR columns are missing the converted type when stored in parquet > files > --------------------------------------------------------------------------------- > > Key: DRILL-2297 > URL: https://issues.apache.org/jira/browse/DRILL-2297 > Project: Apache Drill > Issue Type: Bug > Components: Storage - Parquet > Affects Versions: 0.8.0 > Reporter: Deneche A. Hakim > Labels: interval > Fix For: Future > > > When creating a parquet file with the following query: > {noformat} > CREATE TABLE dfs.tmp.`test_intervalyear` AS SELECT interval '1-2' YEAR TO > MONTH AS INTERVALYEAR_col FROM dfs.data.`test.json`; > {noformat} > {{parquet tools}} display the following metadata for the generated parquet > file: > {noformat} > creator: parquet-mr > file schema: root > ---------------------------------------------------------------------- > INTERVALYEAR_col: REQUIRED INT32 R:0 D:0 > row group 1: RC:5 TS:52 > ---------------------------------------------------------------------- > {noformat} > querying the file back displays the following results: > {noformat} > 0: jdbc:drill:zk=local> select * from dfs.tmp.`test_intervalyear`; > +------------------+ > | intervalyear_col | > +------------------+ > | 14 | > | 14 | > | 14 | > | 14 | > | 14 | > +------------------+ > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)