# Imported Data in to Elastic Search with Epoch Nano Not Showing anything in Kibana

**URL:** https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372
**Category:** Kibana
**Created:** [April 24, 2017, 7:59am UTC](https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372 "2017-04-24T07:59:50Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Matthew\_Bullock](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matthew_bullock/32/47550_2.png) [@Matthew\_Bullock](https://discuss.elastic.co/u/Matthew_Bullock)
#### Post date: [April 24, 2017, 7:59am UTC](https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372/1 "2017-04-24T07:59:50Z")

</div>

I have imported data in to Elastic Search via the bulk API. I have kept my date fields as EPOCH NANO within the data but have selected EPOCH MILLI as the date format. My understanding is JAVA TIME will just drop the last digits and convert it to EPOCH MILLI.

I imported by the bulk API and can see successes in the data

`{"index":{"_index":"els","_type":"logs","_id":"3541c65dffdc4408","_version":1,"result":"created","_shards":{"total":2,"successful":1,"failed":0},"created":true,"status":201}},{"index":{"_index":"els","_type":"logs","_id":"3541c65dffe04408","_version":1,"result":"created","_shards":{"total":2,"successful":1,"failed":0},"created":true,"status":201}},{"index":{"_index":"els","_type":"logs","_id":"3541c66688954408","_version":1,"result":"created","_shards":{"total":2,"successful":1,"failed":0},"created":true,"status":201}},{"index":{"_index":"els","_type":"logs","_id":"3541c67089434408","_version":1,"result":"created","_shards":{"total":2,"successful":1,"failed":0},"created":true,"status":201}`

I see data within the correct index (docs.count shows data)

I can curl Elasticsearch for the data and it returns successfully

`curl -XGET "http://localhost:9200/els/logs/3541c67089434408"`

```
{
  "_index": "els",
  "_type": "logs",
  "_id": "3541c67089434408",
  "_version": 1,
  "found": true,
  "_source": {
    "cacheRequest": {
      "headers": null,
      "keepaliveStatus": "noKeepalives"....................

```

However when I load up Kibana there is no data / no results found. Do I have to update my Kibana Mapping? Or does Kibana not support the Java Time?

---

<div class="post-metadata">

### Author: ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)
#### Post date: [April 24, 2017, 8:33am UTC](https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372/2 "2017-04-24T08:33:53Z")

</div>

Did you select the right field as the time one when setting up your index patterns?

---

<div class="post-metadata">

### Author: ![Matthew\_Bullock](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matthew_bullock/32/47550_2.png) [@Matthew\_Bullock](https://discuss.elastic.co/u/Matthew_Bullock)
#### Post date: [April 24, 2017, 9:29am UTC](https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372/3 "2017-04-24T09:29:18Z")

</div>

so my index mapping is (well top part):

```
{
  "settings": {
    "index.mapping.ignore_malformed": true
  },
  "mappings": {
    "logs": {
      "properties": {
        "timestamp": {
          "type": "date",
          "format": "epoch_millis"
        },
        "geoip.location": {
          "type": "geo_point"
      }
        }
      }
    }
  }'

```

I have also told Kibana to look @ timestamp This worked fine when I 'sed' EPOCH Nano to Milli in my script then bulk imported but was testing new Java Time function to remove this stage

---

<div class="post-metadata">

### Author: ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [April 24, 2017, 10:57pm UTC](https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372/4 "2017-04-24T22:57:27Z")

</div>

elasticsearch does not support nanoseconds, you'll need to send the timestamps as milliseconds if you're going to use the `epoch_millis` date format

---

<div class="post-metadata">

### Author: ![spalger](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spalger/32/14092_2.png) [@spalger](https://discuss.elastic.co/u/spalger)
#### Post date: [April 24, 2017, 10:57pm UTC](https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372/5 "2017-04-24T22:57:59Z")

</div>

See [https://github.com/elastic/elasticsearch/issues/10005](https://github.com/elastic/elasticsearch/issues/10005)

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 22, 2017, 11:09pm UTC](https://discuss.elastic.co/t/imported-data-in-to-elastic-search-with-epoch-nano-not-showing-anything-in-kibana/83372/6 "2017-05-22T23:09:21Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
