# Trouble loading data from pig to elasticsearch
**URL:** https://discuss.elastic.co/t/trouble-loading-data-from-pig-to-elasticsearch/22552
**Category:** Elasticsearch
**Created:** [March 6, 2015, 1:39pm UTC](https://discuss.elastic.co/t/trouble-loading-data-from-pig-to-elasticsearch/22552 "2015-03-06T13:39:57Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@omar\_ben\_salem](https://discuss.elastic.co/u/omar_ben_salem)
#### Post date: [March 6, 2015, 1:39pm UTC](https://discuss.elastic.co/t/trouble-loading-data-from-pig-to-elasticsearch/22552/1 "2015-03-06T13:39:57Z")
I have a hadoop cluster managed by Cloudera CDH 5.3.
I have ElasticSearch 1.4.4 installed in my master machine(10.44.162.169)
I have downloaded the marvel plugin and so access to my ES via :
[http://10.44.162.169:9200/\_plugin/marvel/kibana/index.html#/dashboard/file/marvel.overview.json](http://10.44.162.169:9200/_plugin/marvel/kibana/index.html#/dashboard/file/marvel.overview.json)
I have created an index via sense named myindex with a type named mytype to
push my data in it later.
I did also install kibana 4 and changed the kibana.yml like this :
# The host to bind the server to
host: "10.44.162.169"
# The Elasticsearch instance to use for all your queries.
elasticsearch\_url: "[http://10.44.162.169:9200](http://10.44.162.169:9200)"
I access to it via port 5601 (10.44.162.169:5601)
Now I want to load a data I have in my hdfs into my ElasticSearch.
After dowloading the es-hadoop jar and adding it to the path.
This is how I proceeded :
REGISTER
/usr/elasticsearch-hadoop-2.0.2/dist/elasticsearch-hadoop-pig-2.0.2.jar
--load the CDR.csv file
cdr= LOAD '/user/omar/CDR.csv' using PigStorage(';')
AS
TRAFFIC\_TYPE\_ID:int,APPELANT:int,CALLED\_NUMBER:int,CALL\_DURATION:int,LOCATION\_NUMBER:chararray,DATE\_HEURE\_APPEL:chararray);
STORE cdr INTO 'myindex/mytype' USING
org.elasticsearch.hadoop.pig.PigRunner.run('es.nodes'='10.44.162.169');
When I execute this; the job is a success !!!
BUT, nothing seems to appear in my ES !
1. When I go and access to marvel, I don't find any documents in myindex !
2 )Neither in my Kibana plugin !
1. Furthermore, when I want to consult the logs in the HUE, I can't find a
thing!
Why data isn't pushed in my ES?
What should I do to visualize it?
Why is my created job a success but none log is there to see what's
happening!
Any help? Thank you !
--
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/4b347df6-2d60-4791-b6f6-b04ab3da0c40%40googlegroups.com](https://groups.google.com/d/msgid/elasticsearch/4b347df6-2d60-4791-b6f6-b04ab3da0c40%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:28am UTC](https://discuss.elastic.co/t/trouble-loading-data-from-pig-to-elasticsearch/22552/2 "2017-07-06T00:28:06Z")