# Graph query elasticsearch **URL:** \ **Category:** Elasticsearch\ **Tags:** elastic-stack-graph\ **Created:** [August 23, 2020, 3:45am UTC](https://discuss.elastic.co/t/graph-query-elasticsearch/246004 "2020-08-23T03:45:54Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![Abhinav\_Gandhi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/abhinav_gandhi/32/60794_2.png) [@Abhinav\_Gandhi](https://discuss.elastic.co/u/Abhinav_Gandhi)\ **Post date:** [August 23, 2020, 3:45am UTC](https://discuss.elastic.co/t/graph-query-elasticsearch/246004/1 "2020-08-23T03:45:54Z")
Hi, I was trying to visualise a graph in elasticsearch. The data set i am using is for contacts. Basically it has fields such as name, email, company\_name and owner\_name. The owner\_name field specifies who is the owner of the particular contact. I want to establish relations between a company its owners and then the emails under that owner. For e.g James and [jbutt@gmail.com](mailto:jbutt@gmail.com) belong to an organisation called Benton. James is the owner of [jbutt@gmail.com](mailto:jbutt@gmail.com) So above mentioned linkage as shown in graph is completely fine for [jbutt@gmail.com](mailto:jbutt@gmail.com) ![Screenshot 2020-08-23 at 9.13.47 AM](https://us1.discourse-cdn.com/elastic/original/3X/4/b/4b705c3e3fd396be9c4c359d8fdf704e74196484.png) ```auto Questions-> 1. James is also the owner of donette.foller@cox.net and both also belong to Benton then why is donette linked differently than jbutt? 2. James is also the owner of leota@hotmail.com however this person is missing in the graph Basically i want to observe the hierarchy within the organisation and build a recommender on top of that. ``` I am using settings with certainty of 1 and sample set of 20. Below is the dataset which i imported to elasticssearch using csv as a source ```auto first_name,last_name,company_name,address,city,county,state,zip,phone1,phone,email,owner_name James,Butt,Benton,6649 N Blue Gum St,New Orleans,Orleans,LA,70116,504-621-8927,504-845-1427,jbutt@gmail.com,James Josephine,Darakjy,Benton,4 B Blue Ridge Blvd,Brighton,Livingston,MI,48116,810-292-9388,810-374-9840,josephine_darakjy@darakjy.org,James Art,Venere,Benton,8 W Cerritos Ave #54,Bridgeport,Gloucester,NJ,8014,856-636-8749,856-264-4130,art@venere.org,James Lenna,Paprocki,Benton,639 Main St,Anchorage,Anchorage,AK,99501,907-385-4412,907-921-2010,lpaprocki@hotmail.com,James Donette,Foller,Benton,34 Center St,Hamilton,Butler,OH,45011,513-570-1893,513-549-4561,donette.foller@cox.net,James Simona,Morasca,Benton,3 Mcauley Dr,Ashland,Ashland,OH,44805,419-503-2484,419-800-6759,simona@morasca.com,James Mitsue,Tollner,Benton,7 Eads St,Chicago,Cook,IL,60632,773-573-6914,773-924-8565,mitsue_tollner@yahoo.com,James Leota,Dilliard,Benton,7 W Jackson Blvd,San Jose,Santa Clara,CA,95111,408-752-3500,408-813-1105,leota@hotmail.com,James Sage,Wieser,Benton,5 Boston Ave #88,Sioux Falls,Minnehaha,SD,57105,605-414-2147,605-794-4895,sage_wieser@cox.net,Leota Kris,Marrier,Benton,228 Runamuck Pl #2808,Baltimore,Baltimore City,MD,21224,410-655-8723,410-804-4694,kris@gmail.com,Leota Minna,Amigon,Benton,2371 Jerrold Ave,Kulpsville,Montgomery,PA,19443,215-874-1229,215-422-8694,minna_amigon@yahoo.com,Abel Abel,Maclead,Rangoni,37275 St Rt 17m M,Middle Island,Suffolk,NY,11953,631-335-3414,631-677-3675,amaclead@gmail.com,Abel Kiley,Caldarera,Rangoni,25 E 75th St #69,Los Angeles,Los Angeles,CA,90034,310-498-5651,310-254-3084,kiley.caldarera@aol.com,Abel Graciela,Ruta,Rangoni,98 Connecticut Ave Nw,Chagrin Falls,Geauga,OH,44023,440-780-8425,440-579-7763,gruta@cox.net,Abel Cammy,Albares,Rangoni,56 E Morehead St,Laredo,Webb,TX,78045,956-537-6195,956-841-7216,calbares@gmail.com,Abel Mattie,Poquette,Rangoni,73 State Road 434 E,Phoenix,Maricopa,AZ,85013,602-277-4385,602-953-6360,mattie@aol.com,Cammy Meaghan,Garufi,Rangoni,69734 E Carrillo St,Mc Minnville,Warren,TN,37110,931-313-9635,931-235-7959,meaghan@hotmail.com,Cammy Gladys,Rim,Rangoni,322 New Horizon Blvd,Milwaukee,Milwaukee,WI,53207,414-661-9598,414-377-2880,gladys.rim@rim.org,Meaghan Yuki,Whobrey,Rangoni,1 State Route 27,Taylor,Wayne,MI,48180,313-288-7937,313-341-4470,yuki_whobrey@aol.com,Meaghan ``` ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 20, 2020, 3:45am UTC](https://discuss.elastic.co/t/graph-query-elasticsearch/246004/2 "2020-09-20T03:45:56Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.