hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dhaval Modi <dhavalmod...@gmail.com>
Subject Insert after typecast fails for Timestamp
Date Mon, 18 Apr 2016 15:55:08 GMT
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
dhavalmodi24@gmail.com

Mime
View raw message