# Data type conversion issue **URL:** \ **Category:** Elasticsearch\ **Created:** [July 6, 2018, 9:08am UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868 "2018-07-06T09:08:12Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ajit](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@ajit](https://discuss.elastic.co/u/ajit)\ **Post date:** [July 6, 2018, 9:08am UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/1 "2018-07-06T09:08:13Z")
``` Hi, I am getting long to float data type conversion error. I am using ELK 6.3.0 version. In logstash I have a sql jdbc configuration, and I am executing a query. But my few columns contains decimal values. And while pushing data to elasticsearch from logstash I am getting data type can not change exception. I am getting float to long issue. I have used mutate and pass "number" as datatype but its not working. Getting both long to float and float to long both exception. Please provide solution on this. ``` ---
**Author:** ![ajit](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@ajit](https://discuss.elastic.co/u/ajit)\ **Post date:** [July 6, 2018, 9:33am UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/2 "2018-07-06T09:33:21Z")
Please reply as soon as possible. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 6, 2018, 9:52am UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/3 "2018-07-06T09:52:28Z")
Read [this](https://discuss.elastic.co/t/about-the-elasticsearch-category/21) and specifically the "Also be patient" part. It's fine to answer on your own thread after 2 or 3 days (not including weekends) if you don't have an answer. ---
**Author:** ![ajit](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@ajit](https://discuss.elastic.co/u/ajit)\ **Post date:** [July 6, 2018, 11:30am UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/4 "2018-07-06T11:30:52Z")
Hi, I have used mutate also but still I am facing same issue. First time while pushing data to elasticsearch few records not getting pushed. but after index creation missing records also gets pushed in elasticsearch. I had 188 records, First time 180 records had pushed and 8 records has exception. can not convert float to long. But after index creation my all data i.e. 188 gets pushed in ES. Please provide solution on this. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 6, 2018, 11:46am UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/5 "2018-07-06T11:46:21Z")
I don't know. May be you are not defining a mapping and the first document indexed is not always the same. ---
**Author:** ![ajit](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@ajit](https://discuss.elastic.co/u/ajit)\ **Post date:** [July 6, 2018, 12:47pm UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/6 "2018-07-06T12:47:55Z")
Both documents are same. I am pushing data using same query. But first time my 8 records getting missed. After restarting logstash records not getting missed. I have checked in Oracle. My query giving me 188 records. I have used mutate also . But first time my 8 records getting missed. Please guide us on this issue. ---
**Author:** ![A\_B](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_b/32/17104_2.png) [@A\_B](https://discuss.elastic.co/u/A_B)\ **Post date:** [July 6, 2018, 1:03pm UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/7 "2018-07-06T13:03:56Z")
Hi ajit, which version of Elasticsearch do you use? do you use Kibana? If `yes` then check `Management` \> `Index Patterns` and choose your _Index Pattern_. To the right you can choose which field types to display. You should have `conflict` so choose that one. This should be true even on the index where you see all 188 documents. If you don't have any conflicts, it should be all good, maybe some temporary issue. Based on my own experience I would guess that Elasticsearch is less sensitive to indexing `long` as `float` than the other way around. It would relate to this [issue](https://github.com/elastic/elasticsearch/issues/12366). I have setup a [dead letter queue](https://www.elastic.co/guide/en/logstash/6.3/dead-letter-queues.html) in Logstash for situations like this. Documents with issues go into the dead letter queue where Logstash can read them again and try to fix the issues. -AB ---
**Author:** ![A\_B](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/a_b/32/17104_2.png) [@A\_B](https://discuss.elastic.co/u/A_B)\ **Post date:** [July 6, 2018, 1:09pm UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/8 "2018-07-06T13:09:23Z")
> ajit > ... I have used mutate and pass "number" as datatype but its not working. Also, if you read [Mutate filter plugin | Logstash Reference [6.3] | Elastic](https://www.elastic.co/guide/en/logstash/6.3/plugins-filters-mutate.html#plugins-filters-mutate-convert) > Valid conversion targets are: integer, float, integer\_eu, float\_eu, string, and boolean. No `number` ^^ ---
**Author:** ![ajit](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@ajit](https://discuss.elastic.co/u/ajit)\ **Post date:** [July 6, 2018, 1:53pm UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/9 "2018-07-06T13:53:48Z")
Hi, I have used float and double and long also. But first time I am getting issue related to data type conversion i.e. can not convert float to long. I am using elasticsearch, logstash, kibana and version is 6.3.0. Please provide solution or guide us on this issue. I have 188 records in database but first time only 180 records gets pushed to ES. After restarting logstash with same sql query then I am able to push all 188 records. I have used all datatypes. Below is my logs. `[2018-07-06T12:37:24,629][WARN][logstash.outputs.elasticsearch] Could not index event to Elasticsearch. {tatus=>400, :action=>["index", {:_id=>nil, :_index=>"bank_crisil_rated", :_type=>"doc", :_routing=>nil}, #], :response=>{"index"=>{"_index"=>"bank_crisil_rated", "_type"=>"doc", "_id"=>"urdqbmQBoIEiWn9atfMr", "status"=>400, "error"=>{"type"=>"illegal_argument_exception", "reason"=>"mapper [total_income] cannot be changed from type [float] to [long]"}}}}` Below is my configuration. ``` input { jdbc { jdbc_validate_connection => true jdbc_connection_string => "jdbc:oracle:thin:@DEV:8080/CORPS" jdbc_user => "ABC" jdbc_password => "pass#1234" jdbc_driver_library => "/opt/READONLYREST/OSS/logstash-6.3.0/ojdbc7.jar" jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver" statement => "Select Distinct Bm.Crmcompanyid,Cd.Company_Name, Bm.Datatype,Bm.Template, Bm.Isconsolidated, Bm.Periodendson, Bm.Crr_Date, bm.period_code, Column1 TOTAL_INCOME , Column10 TOTAL_OPERATING_EXPENDITURE , Column9 TOTAL_OTHER_INCOME From Banknbfc_Periodmaster_Synm Bm, Banknbfc_Perioddata_Synm Bd, company_details_mv_synm cd Where Bm.Period_Code = Bd.Period_Code And Cd.Company_Code = Bm.Crmcompanyid and bm.template = 'Bank' and cd.company_status = 'Active' " } } filter { mutate { convert => { "TOTAL_INCOME" => "float" "Capital_Adequacy_Ratio" => "float" } } } output { elasticsearch { hosts => "172.11.111.111:9200" index => "bank_rated" user => "c-ajitb" password => "pass#1234" ssl => true ssl_certificate_verification => false truststore => "/opt/READONLYREST/elasticsearch-6.3.0/config/keystore.jks" truststore_password => "readonlyrest" } } ``` I am using kibana also but in management section I have work after successful creation of index but I am getting few records missed first time that is the issue. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 3, 2018, 1:53pm UTC](https://discuss.elastic.co/t/data-type-conversion-issue/138868/10 "2018-08-03T13:53:52Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.