drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2297) INTERVAL YEAR columns are missing the converted type when stored in parquet files
Date Tue, 10 Nov 2015 18:34:10 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Krystal updated DRILL-2297:
---------------------------
    Labels: interval  (was: )

> 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)

Mime
View raw message