You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2015/04/21 00:14:59 UTC
[jira] [Closed] (DRILL-2412) CTAS has issues when the underlying
query casts a column to time datatype
[ https://issues.apache.org/jira/browse/DRILL-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-2412.
------------------------------------
Verified and added the below testcase :
Functional/Passing/ctas/ctas_t17_DRILL-2412.sql
> 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)