How to rename elasticsearch columns?

Elastic Stack Logstash
1

Hey community, I just import CSV into ElasticSearch but I would like to know if I had possibility to rename these columns :
image

"Bloqué par le filtrage par réputation" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },
          "Date de début" : {
            "type" : "text",
            "fields" : {
              "keyword" : {
                "type" : "keyword",
                "ignore_above" : 256
              }
            }
          },

Thanks for answers ! :slight_smile:

2

You need to reindex and make sure you are using UTF8 as for character encoding.

3

The problem is that it's the CSV that I'm importing that produces these weird characters ... And I can not change the export encoding of my CSV :frowning:

4

What do you use to import the CSV ?

5

It is a security CSV export from IronPort; a software, and i can't change anything

6

I did not mean exporting to CSV but how did you import the CSV file into elasticsearch?

7

sorry I had misread,

using logstash and filebeat:

  • I put filebeat listening on the directory where I send my CSV.
  • I get input {beats => "5044" } in my logstash pipeline
    :slight_smile:
8

I think you need to configure an input Codec: https://www.elastic.co/guide/en/logstash/6.2/plugins-codecs-line.html

And define the right charset.

I moved the question to #logstash as I feel it's where everything should be solved.

9

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