Insert after typecast fails for Timestamp

[Dhaval Modi]

Hi All,

I am trying to convert typecast timestamp to string and add in table
containing String column.
But it is failing with
=====================================================================
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Error
evaluating '2016-06-08 00:00:00'
        at
org.apache.hadoop.hive.ql.exec.vector.VectorSelectOperator.processOp(VectorSelectOperator.java:126)
=====================================================================

Steps to reproduce:
Create table:
create table dummy (col1 String) stored as avro;

Create table t2
create table t2 (col1 timestamp) stored as orc;


Insert Query:
insert into table rct.dummy select cast("2016-06-08 00:00:00" as String)
from t2 limit 5;


Let me know incase, I am missing something.


Regards,
Dhaval Modi
dhavalmod...@gmail.com