# How tp push timestamp field (exp:01AUG2014:19:03:00) and location field : (exp :21700000000000) to KIBANA 4 and make ES map it as so?
**URL:** https://discuss.elastic.co/t/how-tp-push-timestamp-field-exp-01aug2014-19-03-00-and-location-field-exp-21700000000000-to-kibana-4-and-make-es-map-it-as-so/22802
**Category:** Elasticsearch
**Created:** [March 22, 2015, 5:15pm UTC](https://discuss.elastic.co/t/how-tp-push-timestamp-field-exp-01aug2014-19-03-00-and-location-field-exp-21700000000000-to-kibana-4-and-make-es-map-it-as-so/22802 "2015-03-22T17:15:06Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@omar\_ben\_salem](https://discuss.elastic.co/u/omar_ben_salem)
#### Post date: [March 22, 2015, 5:15pm UTC](https://discuss.elastic.co/t/how-tp-push-timestamp-field-exp-01aug2014-19-03-00-and-location-field-exp-21700000000000-to-kibana-4-and-make-es-map-it-as-so/22802/1 "2015-03-22T17:15:06Z")
I want to push data I have in my hadoop cluster to ES and then visualize
the hole thing in kibana.
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 xxx;
* * *
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 esxx 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:03:00 !
And the location field is like this : exp : 21700000000000 .
What should I change to let ES do the appropriate mapping and thus
recognize my timestamp and geo\_location?
Should I try to change my field in the CSV file or another solution is
available?
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/9d1749b5-8b50-4155-8d91-8b13a8bc2fbe%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/9d1749b5-8b50-4155-8d91-8b13a8bc2fbe%40googlegroups.com).
For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout).
---
### Author:  [@omar\_ben\_salem](https://discuss.elastic.co/u/omar_ben_salem)
#### Post date: [March 23, 2015, 10:27am UTC](https://discuss.elastic.co/t/how-tp-push-timestamp-field-exp-01aug2014-19-03-00-and-location-field-exp-21700000000000-to-kibana-4-and-make-es-map-it-as-so/22802/2 "2015-03-23T10:27:23Z")
I have managed to change my time field to a recognizable format using
talend
On Sunday, March 22, 2015 at 6:15:06 PM UTC+1, BEN SALEM Omar wrote:
> I want to push data I have in my hadoop cluster to ES and then visualize
> the hole thing in kibana.
>
> 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 xxx;
>
> * * *
>
> 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 esxx 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:03:00 !
>
> And the location field is like this : exp : 21700000000000 .
>
> What should I change to let ES do the appropriate mapping and thus
> recognize my timestamp and geo\_location?
>
> Should I try to change my field in the CSV file or another solution is
> available?
>
> 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/343f7bff-f10a-469b-9fee-429df43035be%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/343f7bff-f10a-469b-9fee-429df43035be%40googlegroups.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:24am UTC](https://discuss.elastic.co/t/how-tp-push-timestamp-field-exp-01aug2014-19-03-00-and-location-field-exp-21700000000000-to-kibana-4-and-make-es-map-it-as-so/22802/3 "2017-07-06T00:24:56Z")