hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dhaval Modi <>
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'

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.

Dhaval Modi

View raw message