Hi, I am using ELK7 . I have a csv file with 3 columns I have successfully converted the first two columns from string to integer , but failed to convert the 3rd column from string to date. In Kibana the 3rd field is still a string The csv file looks as follow: CALLING_NUMBER,CALLED_NUMBER,IN…

Convert date to string string

Badger May 15, 2019, 12:28pm 3

Your field does not have a space between the date and time it has +, so your pattern has to match that

match => [ "ING_SIGNAL_START_TIME", "YYYY-MM-dd'+'HH:mm:ss.SSS" ]

Grok pattern for date

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.