Mysql datetime format error

I have following format for datetime in mysql.
2016-07-04 19:36:29

I want to use it as timestampSpec column in druid. But during data ingestion I get
Unparseable timestamp found! error.
How can i solve this? Also I want to migrate my Mysql data to druid, What is the best method to perform this?


try setting format as follows -
“format” : “yyyy-MM-dd HH:mm:ss”

For migrating the data from mysql, you can export your data from mysql to CSV/TSV format and then use druid hadoop index task to import the data from these files.

Thanks Nishant. Worked. Please also provide me some good links for querying the data on druid.

you can look at , this also has links for detailed pages for individual queries.

Okay Thanks.