Logstash Jdbc-input Field mapping issue

In Lostash JDBC input all fields defaulted to String mapping. Auto field mapping is not available. How achieve the field map exactly match to to mysql table mapping.

You'll have to change the ES index template that's applied for the index you're pushing data to.

I've one question elastic search index mapping not analyzed field having raw type, in this case whether data is stored multiple times one as analyzed and another non analyzed?