# Logstash how to mutate string of float array to denseVector

**URL:** https://discuss.elastic.co/t/logstash-how-to-mutate-string-of-float-array-to-densevector/326750
**Category:** Logstash
**Created:** [March 1, 2023, 10:14am UTC](https://discuss.elastic.co/t/logstash-how-to-mutate-string-of-float-array-to-densevector/326750 "2023-03-01T10:14:15Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![wensi](https://avatars.discourse-cdn.com/v4/letter/w/e95f7d/32.png) [@wensi](https://discuss.elastic.co/u/wensi)
#### Post date: [March 1, 2023, 10:14am UTC](https://discuss.elastic.co/t/logstash-how-to-mutate-string-of-float-array-to-densevector/326750/1 "2023-03-01T10:14:15Z")

</div>

I am using Logstash to transfer data from MySQL to ES, one column in MySQL is

```auto
`vec` text NOT NULL

```

vec has value like [0.1, 0.2, 0.3] and is of string type. How to convert string of float array to ES dense\_vector?

I tried with the following filter conf, `vec` value becomes `0.0`.

```auto
filter {
  mutate {
    copy => { "id" => "[@metadata][_id]"}
    remove_field => ["@version"]
  }
  mutate {
    convert => {
      "vec" => "float"
    }
  }
}

{
    "create_time" => 2023-02-21T16:00:00.000Z,
     "@timestamp" => 2023-03-01T10:05:16.734329758Z,
             "id" => 349542,
            "vec" => 0.0
}

```

---

<div class="post-metadata">

### Author: ![wensi](https://avatars.discourse-cdn.com/v4/letter/w/e95f7d/32.png) [@wensi](https://discuss.elastic.co/u/wensi)
#### Post date: [March 1, 2023, 11:03am UTC](https://discuss.elastic.co/t/logstash-how-to-mutate-string-of-float-array-to-densevector/326750/2 "2023-03-01T11:03:50Z")

</div>

I finally solved this by using

```auto
filter {
  mutate {
    copy => { "id" => "[@metadata][_id]"}
    remove_field => ["@version"]
  }
  mutate {
    gsub => ["vec", "[\[\]]", "" ]
    split => { "vec" => "," }
  }
  mutate {
    convert => {
      "vec" => "float"
    }
  }
}

```

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [March 29, 2023, 11:04am UTC](https://discuss.elastic.co/t/logstash-how-to-mutate-string-of-float-array-to-densevector/326750/3 "2023-03-29T11:04:03Z")

</div>

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