You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/06/09 22:21:01 UTC
[jira] [Resolved] (DRILL-815) Parquet files created in impala using
data from hive tables resulted in incorrect string representation
[ https://issues.apache.org/jira/browse/DRILL-815?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-815.
----------------------------------
Resolution: Won't Fix
This isn't a Drill bug. Once Impala (or any other Parquet file creator) uses the Parquet ConvertedType annotations, data will show up correctly as varchar in drill. In the meantime, you must cast varbinary data to varchar if you want to see it
> Parquet files created in impala using data from hive tables resulted in incorrect string representation
> -------------------------------------------------------------------------------------------------------
>
> Key: DRILL-815
> URL: https://issues.apache.org/jira/browse/DRILL-815
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Parquet
> Reporter: Norris Lee
> Assignee: Jason Altekruse
>
> The parquet file was created by first loading a csv file into a hive table. A parquet table was then created in impala and data from the hive table was loaded in. The file was extracted from hdfs to local and placed into drill's dfs.
> The keycolumn column in hive is of type string.
> {code}
> 0: jdbc:drill:schema=hivestg> select * from `dfs`.`/opt/drill/integer.parquet`;
> +------------+------------+
> | keycolumn | column1 |
> +------------+------------+
> | [B@7385c043 | 0 |
> | [B@5211a9f5 | 1 |
> | [B@5ad3deb | -1 |
> | [B@30bc1236 | 2 |
> | [B@b4fb039 | 127 |
> | [B@1cba73fc | -128 |
> | [B@1514b420 | 255 |
> | [B@23dabb0 | 128 |
> | [B@1ed2b0f6 | -129 |
> | [B@1a5ff649 | 256 |
> | [B@12224026 | 32767 |
> | [B@6a18817 | -32768 |
> | [B@56eda167 | 65535 |
> | [B@aff9dc7 | -32769 |
> | [B@13cf7975 | 32768 |
> | [B@1a2efa7c | 65536 |
> | [B@23ef052 | 2147483647 |
> | [B@721398a4 | -2147483648 |
> +------------+------------+
> {code}
--
This message was sent by Atlassian JIRA
(v6.2#6252)