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)
