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

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

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

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:

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?

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