[jira] [Updated] (DRILL-2412) CTAS has issues when the underlying query does a cast to time when the data is in HIVE

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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

Rahul Challapalli updated DRILL-2412:
-------------------------------------
    Attachment: time.txt
                error.log

> CTAS has issues when the underlying query does a cast to time when the data is in HIVE
> --------------------------------------------------------------------------------------
>
>                 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: Steven Phillips
>         Attachments: error.log, time.txt
>
>
> git.commit.id.abbrev=e92db23
> Hive DDL :
> {code}
> create external table time_data (time_col string) location '/hivedata/time_data';
> {code}
> From drill I ran the below query :
> {code}
> create table time_data as select cast(time_col as time) from hive.time_data;
> +------------+---------------------------+
> |  Fragment  | Number of records written |
> +------------+---------------------------+
> | 0_0        | 16                        |
> +------------+---------------------------+
> 1 row selected (0.229 seconds)
> {code}
> Now when I try to run queries on top of the new table, drill reports an error
> {code}
> select * from time_data;
> Query failed: RemoteRpcException: Failure while running fragment., org.apache.drill.exec.vector.NullableTimeVector cannot be cast to org.apache.drill.exec.vector.NullableIntVector [ 2585e743-dbe6-48d9-b3f5-e60aaa0df1f9 on qa-node191.qa.lab:31010 ]
> [ 2585e743-dbe6-48d9-b3f5-e60aaa0df1f9 on qa-node191.qa.lab:31010 ]
> {code}
> This does not happen when we directly read the file from drill and use CTAS.
> I attached the data file and the log file



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)