drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Steven Phillips (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2412) CTAS has issues when the underlying query casts a column to time datatype
Date Thu, 26 Mar 2015 02:56:52 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Steven Phillips updated DRILL-2412:
-----------------------------------
    Assignee: Deneche A. Hakim  (was: Steven Phillips)

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

Mime
View raw message