I want to change some column name while loading the data through logstash
Have a look at this: https://www.elastic.co/guide/en/logstash/current/plugins-filters-mutate.html
The SELECT part of a SQL query allows you to assign any names to the columns in the result set.