Load the date field from hive to elasticsearch and visualize it on kibana

Elastic Stack Elasticsearch
1

Hi,

I have a Hive database and I connected it with es-hadoop, but I have a problem concerning the date type field, I can not load the date on elasticsearch and visualize it on Kibana, here is my problem in detail:

here is my table on hive :

create external table test (date_test string)
stored by 'org.elasticsearch.hadoop.hive.EsStorageHandler' 
TBLPROPERTIES('es.resource' = 'hosix/test');

I searched too much on google and the different problems in the forums, I found that elasticsearch supports the date with ISO 8601 format, so I inserted a line like this:

insert into test values ('2018-04-08T11:03:21+00:00');

And I made a select query to check that everything is OK on hive :

image

image

I created the index on Kibana and recognizes the date_test field :

image
image1428×476 20.3 KB

image
image1433×289 12.7 KB

but when want to do a visualization test on my data, there is no records :

image
image1638×609 14.4 KB

please help me, I searched too much on the internet I can not find the solution yet and I don't know what to do :disappointed_relieved:

2

can you search in that index for this document? Does it exist? If so, can you paste the mapping of the index and the json fo the document here?