[
https://issues.apache.org/jira/browse/DRILL-1965?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14272306#comment-14272306
]
Jason Altekruse commented on DRILL-1965:
----------------------------------------
Code so far generates this query to cast the data to the various datatypes from
the json file in the patch. There seems to be an issue with the cast on the
intervals and they are coming out null.
CREATE TABLE parquet_all_types AS SELECT cast( INT_col as int) INT_col,cast(
BIGINT_col as bigint) BIGINT_col,cast( DECIMAL9_col as decimal)
DECIMAL9_col,cast( DECIMAL18_col as decimal(18,9)) DECIMAL18_col,cast(
DECIMAL28SPARSE_col as decimal(28, 14)) DECIMAL28SPARSE_col,cast(
DECIMAL38SPARSE_col as decimal(38, 19)) DECIMAL38SPARSE_col,cast( DATE_col as
date) DATE_col,cast( TIME_col as time) TIME_col,cast( TIMESTAMP_col as
timestamp) TIMESTAMP_col,cast( FLOAT4_col as float) FLOAT4_col,cast( FLOAT8_col
as double) FLOAT8_col,cast( BIT_col as boolean) BIT_col,cast( VARCHAR_col as
varchar(65000)) VARCHAR_col,cast( VAR16CHAR_col as varchar(65000))
VAR16CHAR_col,cast( VARBINARY_col as varbinary(65000)) VARBINARY_col,cast(
INTERVALYEAR_col as interval year) INTERVALYEAR_col,cast( INTERVALDAY_col as
interval day) INTERVALDAY_col FROM cp.`/parquet/alltypes.json`
> Expand read and write testing for parquet across all supported types
> --------------------------------------------------------------------
>
> Key: DRILL-1965
> URL: https://issues.apache.org/jira/browse/DRILL-1965
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Jason Altekruse
> Assignee: Ramana Inukonda Nagaraj
> Attachments: DRILL-1965-WIP-parquet-file-all-types.patch
>
>
> The additional types we added to the parquet spec to allow use of parquet as
> a general purpose export format for drill query results have not all been
> thoroughly tested, we should make a better set of tests to ensure that the
> read and write path for the types are all working properly.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
