Re: Insert after typecast fails for Timestamp

Thanks Mich for replying. I got the cause of it. Version: Hive v0.14 Cause: Vectorization was enabled Regards, Dhaval Modi dhavalmod...@gmail.com On 18 April 2016 at 22:13, Mich Talebzadeh wrote: > this should work and should not crash > > > *hive> insert into dummy select cast("2016-06-08 0

Re: Insert after typecast fails for Timestamp

this should work and should not crash *hive> insert into dummy select cast("2016-06-08 00:00:00" as String) from t2 limit 5;*Query ID = hduser_20160418175620_4cebc5e9-10a0-422c-92ff-43f059b4c3a6 Total jobs = 1 Launching Job 1 out of 1 In order to change the average load for a reducer (in bytes):

Insert after typecast fails for Timestamp

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'