Timestamp format issues at ingestion time

I am having trouble indexing data due to timestamp formats, error is pretty clear:

Caused by: com.metamx.common.parsers.ParseException: Unparseable timestamp found!

Row:

[{"wiki_db":"abwiki","event_entity":"revision","event_type":"create","event_timestamp":"2005-06-25 10:53:23.0","event_comment":null,"event_user_id":0,"event_user_text":"MediaWiki default","event_user_text_latest":null,"event_user_blocks":null,"event_user_blocks_latest":null,"event_user_groups":null,"event_user_groups_latest":null,"event_user_is_created_by_self":0,"event_user_is_created_by_system":0,"event_user_is_created_by_peer":0,"event_user_is_anonymous":1,"event_user_is_bot_by_name":0,"event_user_creation_timestamp":null,"event_user_revision_count":null,"event_user_seconds_to_previous_revision":null,"page_id":null,"page_title":null,"page_title_latest":"Wikipediapage","page_namespace":null,"page_namespace_is_content":0,"page_namespace_latest":8,"page_namespace_is_content_latest":0,"page_is_redirect_latest":0,"page_creation_timestamp":null,"page_revision_count":null,"page_seconds_to_previous_revision":null,"user_id":null,"user_text":null,"user_text_latest":null,"user_blocks":null,"user_blocks_latest":null,"user_groups":null,"user_groups_latest":null,"user_is_created_by_self":0,"user_is_created_by_system":0,"user_is_created_by_peer":0,"user_is_anonymous":0,"user_is_bot_by_name":0,"user_creation_timestamp":null,"revision_id":4023,"revision_parent_id":null,"revision_minor_edit":0,"revision_text_bytes":17,"revision_text_bytes_diff":17,"revision_text_sha1":"8o0n599oktjqftpbvlgiifzklt8g8ud","revision_content_model":"","revision_content_format":"","revision_is_deleted":1,"revision_deleted_timestamp":"2005-06-25 10:53:23.0","revision_is_identity_reverted":0,"revision_first_identity_reverting_revision_id":null,"revision_seconds_to_identity_revert":null,"revision_is_identity_revert":0}]

My format is defined as:

“format” : “YYYY-MM-dd HH:mm:ss.S”, which, as far as I understand, is joda time compliant.

See: https://gerrit.wikimedia.org/r/#/c/366327/1/oozie/mediawiki/history/druid/load_mediawiki_history.json.template

Any ideas?

We run version 0.9.2 which according to docs supports joda formatting: http://druid.io/docs/0.9.2/ingestion/

Total operator error “-” insteads of “.” on format!