Hi,

I am trying to bulk index from MS-SQL data to ES (5.6.3). The SQL query in SSMS gives 16284 as total count but after getting indexed, Kibana gets the total count as 15768.However the stats in API gets shows both count in two differnt places. Please see below and let me what is the issue and how do I get the data count correctly in Kibana?

Also read some template mapping before indexing, still didnt help.

[https://discuss.elastic.co/t/bulk-index-cannot-change-type-for-index-with-more-than-one-shard/68560](https://discuss.elastic.co/t/bulk-index-cannot-change-type-for-index-with-more-than-one-shard/68560)

{
   "_shards":    {
      "total": 10,
      "successful": 5,
      "failed": 0
   },
   "_all":    {
      "primaries":       {
         "docs":          {
            "count":`15768`,
            "deleted": 0
         },
         "store":          {
            "size_in_bytes": 69894322,
            "throttle_time_in_millis": 0
         },
         "indexing":          {
            "index_total": `16284`,
            "index_time_in_millis": 28164,
            "index_current": 0,
            "index_failed": 0,
            "delete_total": 0,
            "delete_time_in_millis": 0,
            "delete_current": 0,
            "noop_update_total": 0,
            "is_throttled": false,
            "throttle_time_in_millis": 0
         },

---
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB