Thank you so much. Your demonstration helped me a lot.
I have some questions tho. The first is if I just used your last method, ES will recognize "location" as the type of string. So do I need to set the mapping for this data to specify the type of "location" should be geo_point in the console of kibana in advance? I am kinda confused cuz I thought ES will automatically do the recognizion.
For getting the value of the field, you mentioned using %{[lat]}. I am wondering if it works for the case that I want to parse something from the specific field which is in the original input data.
Or could you take a look at Geo point mapping
Thanks again!!!