[ 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)