timestampSpec for mm/dd/yyyy hh:mm:ss

My data has timestamp like mm/dd/yyyy hh:mm:ss.I am using below spec for indeing but getting error
“timestampSpec” : {
“format” : “mm/dd/yyyy hh:mm:ss”,
“column” : “createddate”
how can we handle this kind of data.

Hi Chaman,

Can you give us the error to help you more ?

Watch out for Joda time. Try something like “MM/dd/yyyy HH:mm:ss”.

Let me know if it helps.


Please see http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html about how to format things