[jira] [Created] (DRILL-2297) INTERVAL YEAR columns are missing the converted type when stored in parquet files

["Deneche A. Hakim (JIRA)" <ji...@apache.org>]

Deneche A. Hakim created DRILL-2297:
---------------------------------------

             Summary: 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
            Assignee: Steven Phillips
             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)