How to enable geo_point or geo_shape in csv data to linestring

Elastic Stack Elasticsearch
1

I am trying to draw a line by extracting the location and timestamp data from the geo_point or geo_shape index where the csv file is uploaded. But it keeps failing, and the aggregations are not applied. So, I am asking if there is a way to extract two items and draw a 'location' line in map(Kibana) according to the 'timestamp'.
my Elasicsearch license is 'basic'
Below is the error code and index format.

{
  "error" : {
    "root_cause" : [
      {
        "type" : "security_exception",
        "reason" : "current license is non-compliant for [SPATIAL_GEO_LINE]",
        "license.expired.feature" : "SPATIAL_GEO_LINE"
      }
    ],
    "type" : "security_exception",
    "reason" : "current license is non-compliant for [SPATIAL_GEO_LINE]",
    "license.expired.feature" : "SPATIAL_GEO_LINE"
  },
  "status" : 403
}

{
        "_index" : "gps_se4",
        "_type" : "_doc",
        "_id" : "m-kkdXoB1Kp5W5HUXw5W",
        "_score" : 1.0,
        "_source" : {
          "FloorCode" : 1,
          "IsSuspicious" : 0,
          "lon" : 126.955349061,
          "CreateDate" : "2020-03-09 09:14:20.943",
          "@timestamp" : "2020-03-09T09:14:20.910+09:00",
          "X" : 684.0573108321,
          "Y" : 1126.8392964661,
          "CalculationDate" : "2020-03-09 09:14:20.910",
          "TagCode" : 40003,
          "location" : "37.5847676941,126.955349061",
          "Id" : 3,
          "lat" : 37.5847676941
        }
      },
      {
        "_index" : "gps_se4",
        "_type" : "_doc",
        "_id" : "nOkkdXoB1Kp5W5HUXw5W",
        "_score" : 1.0,
        "_source" : {
          "FloorCode" : 1,
          "IsSuspicious" : 0,
          "lon" : 126.9558666352,
          "CreateDate" : "2020-03-09 09:14:21.967",
          "@timestamp" : "2020-03-09T09:14:21.940+09:00",
          "X" : 732.7000668183,
          "Y" : 1151.6227001975,
          "CalculationDate" : "2020-03-09 09:14:21.940",
          "TagCode" : 40003,
          "location" : "37.5850000642,126.9558666352",
          "Id" : 4,
          "lat" : 37.5850000642
        }
      },

....

Sorry for my poor English and I appreciate your help.

2

Hey,

so this geo_line aggregation requires a gold license, see Subscriptions | Elastic Stack Products & Support | Elastic.

--Alex

3

Thanks for help!! I solve it using python code.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.