Logstash jdbc plugin issue

Question

I am using logstash jdbc plugin to transfer data from db to elasticsearch. When picking data from db the column names are in lowercase. But I need the column names to be changed to uppercase and the values to be inserted in the already created index with fields having uppercase.

I tried using

filter{
   mutate {
     uppercase => [ "column1" , "column2" , "column3" ]
   }
}

I have already created an index in ES having COLUMN1 , COLUMN2 , COLUMN3. But when I run the logstash file its creating new fields column1, column2,column3 and not indexing any data in fields COLUMN1 ,COLUMN2 ,COLUMN3.

What the `mutate/uppercase` filter does is uppercasing the values of the fields named in the array, not the field names themselves. — Val, Dec 10 '15 at 13:37
It means the data stored under the field is changed to uppercase before inserting to elastic search ?? — sri, Dec 10 '15 at 15:29

JointEffort · Answer 1 · 2016-02-26T07:52:22.530

0

Maybe a bit late, but have you seen the lowercase_column_names parameter at https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html? It defaults to true, meaning that logstash will lowercase the column names from the JDBC result set.

edited Feb 26 '16 at 07:52

answered Feb 24 '16 at 11:59

JointEffort

583
7
21

Logstash jdbc plugin issue

1 Answers1