[jira] [Created] (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>]

Rahul Challapalli created DRILL-2412:
----------------------------------------

             Summary: 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


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)