Re: java.lang.TypeNotPresentException: Type timestamp not present

2014-06-02 Thread Eugene Koifman
instead of org.apache.hcatalog.pig.HCatStorer() use org.apache.hive.hcatalog.pig.HCatStorer() On Mon, Jun 2, 2014 at 12:54 PM, Rahul Channe wrote: > Try loading the data in a temporary hive table with datatype as String, > then you can populate the data in the final table > > insert into table

Re: java.lang.TypeNotPresentException: Type timestamp not present

2014-06-02 Thread Rahul Channe
Try loading the data in a temporary hive table with datatype as String, then you can populate the data in the final table insert into table timestamp_example select from_unixtime(unix_timestamp(v_time ,'MM/dd/ HH:mm') ) from timestamp_example_temp; On Mon, Jun 2, 2014 at 3:23 PM, Patcharee