You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Krystal (JIRA)" <ji...@apache.org> on 2015/11/12 17:58:11 UTC
[jira] [Closed] (DRILL-2297) INTERVAL YEAR columns are missing the
converted type when stored in parquet files
[ https://issues.apache.org/jira/browse/DRILL-2297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Krystal closed DRILL-2297.
--------------------------
CREATE TABLE test_intervalyear AS SELECT interval '1-2' YEAR TO MONTH AS INTERVALYEAR_col FROM voter limit 5;
select * from test_intervalyear;
+-------------------+
| INTERVALYEAR_col |
+-------------------+
| P14M |
| P14M |
| P14M |
| P14M |
| P14M |
+-------------------+
> 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)