hello ,
currently to define any field as geo_point i using following command in kibana dev tool -
PUT t5
{
"mappings": {
"dataa": {
"properties": {
"G": {
"type": "geo_point"
}
}
}
}
}
But i need to define this for every index .
Now i am creating index for everyday .
my sample .csv
A,B,C,D,E,F,G
A1,2017/09/16 00:00:00,3U0604,2017/09/16 19:30:00,2017/09/16 19:30:00,1,"26,54"
A2,2017/09/16 00:00:00,3U0604,2017/09/16 00:00:00,2017/09/16 19:30:00,2,"27,54"
and my config file -
input {
file {
path => "E:\Local_Elasticsearch\logstashv5\everydaylog/*.csv"
start_position => "beginning"
}
}
filter {
csv {
separator => ","
columns => ["A","B","C","D","E","F","G"]
}
mutate {convert =>["F" , "integer"]}
date {
match => [ "B", "ISO8601", "YYYY-MM-dd HH:mm:ss" ]
target => "B"
locale => "en"
}
date {
match => [ "D", "ISO8601", "YYYY-MM-dd HH:mm:ss" ]
target => "D"
locale => "en"
}
date {
match => [ "E", "ISO8601", "YYYY-MM-dd HH:mm:ss" ]
target => "E"
locale => "en"
}
}
output {
elasticsearch {
hosts => "localhost"
index => "testindex-%{+YYYYMMdd}"
}
stdout{}
}
in this case how can i define field "G" as geo_point for every day data file automatically .
thanks