Hi KnimeTeam,
I have a String format time in a column as follow.
2015-05-01 00:28:39.487
I would like to load this column into hive table as TIMESTAMP type.
For this, I have given this String format date and time to "String to Date/Time" Node and configured the date format as "yyyy-MM-dd' 'HH:mm:ss.S".
After execute the String to Date/Time node, got the following as output in the column.
01.May.2015 00:28:39.487
Then, I have given this to hive loader and I am getting the null value in the column output.
In the hive loader and hive table, I have given the data type as TIMESTAMP for the timedetail column.
But, I have given only date(2015-05-01). And tried the above the same with YYYY-MM-DD configuration, it is working fine.
I have successfully loaded into hive table and the output is 01.May.2015.
Could you suggest me, Is there anything I am missing when I include date with time?
Best Regards,
velu