# Kibana4 doesn't recognize my timestamp; ES is mapping it as a string
**URL:** https://discuss.elastic.co/t/kibana4-doesnt-recognize-my-timestamp-es-is-mapping-it-as-a-string/22795
**Category:** Elasticsearch
**Created:** [March 21, 2015, 6:39pm UTC](https://discuss.elastic.co/t/kibana4-doesnt-recognize-my-timestamp-es-is-mapping-it-as-a-string/22795 "2015-03-21T18:39:53Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@omar\_ben\_salem](https://discuss.elastic.co/u/omar_ben_salem)
#### Post date: [March 21, 2015, 6:39pm UTC](https://discuss.elastic.co/t/kibana4-doesnt-recognize-my-timestamp-es-is-mapping-it-as-a-string/22795/1 "2015-03-21T18:39:53Z")
I want to push data I have in my hadoop cluster to ES and then visualize
the hole thing in kibana4.
this is what I’ve done :
1.
CREATE TABLE xx(traffic\_type\_id INT, caller INT, time STRING,
tranche\_horaire INT, called INT, call\_duration INT, code\_type\_trafic
STRING, code\_destination\_trafic STRING, location\_number STRING, id\_offre
INT, id\_service INT)
ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t';
LOAD DATA INPATH ‘/user/hive/outt.csv’ OVERWRITE INTO TABLE xx;
* * *
1.
CREATE EXTERNAL TABLE esxx (caller INT, time STRING, tranche INT,
called\_number INT, duration INT, code\_type STRING, code\_destination STRING,
location STRING, offre INT, service INT)
STORED BY ‘org.elasticsearch.hadoop.hive.EsStorageHandler’
TBLPROPERTIES(‘es.resource’ = ‘xx/xx’,
‘es.nodes’=’192.168.238.130:9200′,
‘es.mapping.names’ = ‘time:@timestamp’);
INSERT OVERWRITE TABLE escdr SELECT s.caller, s.time, s.tranche\_horaire,
s.called, s.call\_duration, s.code\_type\_trafic, s.code\_destination\_trafic,
s.location\_number, s.id\_offre, s.id\_service FROM xx s;
* * *
1.
CREATE EXTERNAL TABLE xx (
caller INT,
time TIMESTAMP,
tranche INT,
called\_number INT,
duration INT,
code\_type STRING,
code\_destination STRING,
location STRING,
offre INT,
service INT)
STORED BY ‘org.elasticsearch.hadoop.hive.EsStorageHandler’
TBLPROPERTIES(‘es.resource’ = ‘xx/xx/’,
‘es.nodes’=’192.168.238.130:9200′,
‘es.mapping.names’ = ‘time:@timestamp’);
But Kibana doesn’t seem to recognize my timestamp “time”, ES keeps on
mapping it as a string (the time field in my csv file is as so : exp :
01AUG2014:19:02:11 ! What should I do and change to let ES do the
appropriate mapping and thus recognize my timestamp?
Best regards,
Omar,
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/30597efd-b762-473d-94aa-9c1671fb0ff4%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/30597efd-b762-473d-94aa-9c1671fb0ff4%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@P\_lva](https://discuss.elastic.co/u/P_lva)
#### Post date: [March 22, 2015, 12:15am UTC](https://discuss.elastic.co/t/kibana4-doesnt-recognize-my-timestamp-es-is-mapping-it-as-a-string/22795/2 "2015-03-22T00:15:16Z")
By using this statement
'es.mapping.names’ = ‘time:@timestamp’
You've changed the name of the 'time' field in your hive table to
'@timestamp' in your elasticsearch index.
See if you have a can find a field called @timestamp in kibana and use that
as your time field in ES.
Alternatively try removing that line from your hive creation table see if
that changes anything.
On Sat, Mar 21, 2015 at 2:39 PM, BEN SALEM Omar [omar.bensalem@esprit.tn](mailto:omar.bensalem@esprit.tn)
wrote:
> I want to push data I have in my hadoop cluster to ES and then visualize
> the hole thing in kibana4.
>
> this is what I’ve done :
>
> 1.
>
> CREATE TABLE xx(traffic\_type\_id INT, caller INT, time STRING,
> tranche\_horaire INT, called INT, call\_duration INT, code\_type\_trafic
> STRING, code\_destination\_trafic STRING, location\_number STRING, id\_offre
> INT, id\_service INT)
> ROW FORMAT DELIMITED FIELDS TERMINATED BY ‘\t';
>
> LOAD DATA INPATH ‘/user/hive/outt.csv’ OVERWRITE INTO TABLE xx;
>
> * * *
>
> 1.
>
> CREATE EXTERNAL TABLE esxx (caller INT, time STRING, tranche INT,
> called\_number INT, duration INT, code\_type STRING, code\_destination STRING,
> location STRING, offre INT, service INT)
> STORED BY ‘org.elasticsearch.hadoop.hive.EsStorageHandler’
> TBLPROPERTIES(‘es.resource’ = ‘xx/xx’,
> ‘es.nodes’=’192.168.238.130:9200′,
> ‘es.mapping.names’ = ‘time:@timestamp’);
>
> INSERT OVERWRITE TABLE escdr SELECT s.caller, s.time, s.tranche\_horaire,
> s.called, s.call\_duration, s.code\_type\_trafic, s.code\_destination\_trafic,
> s.location\_number, s.id\_offre, s.id\_service FROM xx s;
>
> * * *
>
> 1.
>
> CREATE EXTERNAL TABLE xx (
> caller INT,
> time TIMESTAMP,
> tranche INT,
> called\_number INT,
> duration INT,
> code\_type STRING,
> code\_destination STRING,
> location STRING,
> offre INT,
> service INT)
> STORED BY ‘org.elasticsearch.hadoop.hive.EsStorageHandler’
> TBLPROPERTIES(‘es.resource’ = ‘xx/xx/’,
> ‘es.nodes’=’192.168.238.130:9200′,
> ‘es.mapping.names’ = ‘time:@timestamp’);
>
> But Kibana doesn’t seem to recognize my timestamp “time”, ES keeps on
> mapping it as a string (the time field in my csv file is as so : exp :
> 01AUG2014:19:02:11 ! What should I do and change to let ES do the
> appropriate mapping and thus recognize my timestamp?
> Best regards,
> Omar,
>
> --
> You received this message because you are subscribed to the Google Groups
> "elasticsearch" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
> To view this discussion on the web visit
> [https://groups.google.com/d/msgid/elasticsearch/30597efd-b762-473d-94aa-9c1671fb0ff4%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/30597efd-b762-473d-94aa-9c1671fb0ff4%40googlegroups.com)
> [https://groups.google.com/d/msgid/elasticsearch/30597efd-b762-473d-94aa-9c1671fb0ff4%40googlegroups.com?utm\_medium=email&utm\_source=footer](https://groups.google.com/d/msgid/elasticsearch/30597efd-b762-473d-94aa-9c1671fb0ff4%40googlegroups.com?utm_medium=email&utm_source=footer)
> .
> For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).
To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAO9TxdPRV%2BaGkScp58hRfhSzAK4ojDO2NV0MTWt7LGGU9cb-Ow%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAO9TxdPRV%2BaGkScp58hRfhSzAK4ojDO2NV0MTWt7LGGU9cb-Ow%40mail.gmail.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [July 6, 2017, 12:25am UTC](https://discuss.elastic.co/t/kibana4-doesnt-recognize-my-timestamp-es-is-mapping-it-as-a-string/22795/3 "2017-07-06T00:25:09Z")