[
https://issues.apache.org/jira/browse/DRILL-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384763#comment-14384763
]
Rahul Challapalli commented on DRILL-2412:
------------------------------------------
This is no longer a bug. Looks like it got fixed
> CTAS has issues when the underlying query casts a column to time datatype
> -------------------------------------------------------------------------
>
> Key: DRILL-2412
> URL: https://issues.apache.org/jira/browse/DRILL-2412
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Parquet
> Reporter: Rahul Challapalli
> Assignee: Deneche A. Hakim
> Fix For: 0.9.0
>
> Attachments: error.log, time.txt
>
>
> git.commit.id.abbrev=e92db23
> {code}
> create table time_parquet as select cast(columns[0] as time) time_col from
> `time.tbl`;
> +------------+---------------------------+
> | Fragment | Number of records written |
> +------------+---------------------------+
> | 0_0 | 21 |
> +------------+---------------------------+
> 1 row selected (0.201 seconds)
> {code}
> Now running a count(*) on the newly created table does not have any issues
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirViews> select count(*) from time_parquet;
> +------------+
> | EXPR$0 |
> +------------+
> | 21 |
> +------------+
> 1 row selected (0.081 seconds)
> {code}
> However the below 2 queries fail
> {code}
> 0: jdbc:drill:schema=dfs.drillTestDirViews> select * from time_parquet;
> Query failed: RemoteRpcException: Failure while running fragment.,
> org.apache.drill.exec.vector.NullableTimeVector cannot be cast to
> org.apache.drill.exec.vector.NullableIntVector [
> cdceaf64-b858-4063-8364-d119703cf6f0 on qa-node191.qa.lab:31010 ]
> [ cdceaf64-b858-4063-8364-d119703cf6f0 on qa-node191.qa.lab:31010 ]
> 0: jdbc:drill:schema=dfs.drillTestDirViews> select time_col from time_parquet;
> Query failed: RemoteRpcException: Failure while running fragment.,
> org.apache.drill.exec.vector.NullableTimeVector cannot be cast to
> org.apache.drill.exec.vector.NullableIntVector [
> 8c4254bb-7869-468d-bc6c-7151b833593f on qa-node191.qa.lab:31010 ]
> [ 8c4254bb-7869-468d-bc6c-7151b833593f on qa-node191.qa.lab:31010 ]
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
