# Federated query error

**URL:** <https://community.siren.io/t/federated-query-error/376>\
**Category:** Siren Federate (Elasticsearch Plugin)\
**Created:** [April 14, 2021, 3:30pm UTC](https://community.siren.io/t/federated-query-error/376 "2021-04-14T15:30:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dmwpepper](https://avatars.discourse-cdn.com/v4/letter/d/ce73a5/32.png) [@dmwpepper](https://community.siren.io/u/dmwpepper)\
**Post date:** [April 14, 2021, 3:30pm UTC](https://community.siren.io/t/federated-query-error/376/1 "2021-04-14T15:30:47Z")

</div>

I’ve imported two simple data sets to understand federated queries but I’m getting the following error in Dev Tools:

 ![federatedqueryerror](https://canada1.discourse-cdn.com/flex032/uploads/siren/original/1X/3682f137a173da2f44d6b90d83abb151c20ce29c.png)

Mappings for the books and publisher indices:  
{  
“siren-import-home-books” : {  
“mappings” : {  
“properties” : {  
“@timestamp” : {  
“type” : “date”  
},  
“AUTHOR\_FIRSTNAME” : {  
“type” : “keyword”  
},  
“AUTHOR\_LASTNAME” : {  
“type” : “keyword”  
},  
“CATEGORY” : {  
“type” : “keyword”  
},  
“ID” : {  
“type” : “integer”  
},  
“PUBDATE” : {  
“type” : “date”  
},  
“PUBLISHER” : {  
“type” : “keyword”  
},  
“TITLE” : {  
“type” : “text”,  
“fields” : {  
“keyword” : {  
“type” : “keyword”,  
“ignore\_above” : 768  
}  
},  
“analyzer” : “english”,  
“fielddata” : true  
},  
“\_siren” : {  
“properties” : {  
“sic” : {  
“properties” : {  
“namespace” : {  
“type” : “keyword”  
}  
}  
}  
}  
}  
}  
}  
}  
}

{  
“siren-import-home-publishers” : {  
“mappings” : {  
“properties” : {  
“@timestamp” : {  
“type” : “date”  
},  
“ADDRESS” : {  
“type” : “text”,  
“fields” : {  
“keyword” : {  
“type” : “keyword”,  
“ignore\_above” : 768  
}  
},  
“analyzer” : “english”,  
“fielddata” : true  
},  
“CITY” : {  
“type” : “keyword”  
},  
“ID\_” : {  
“type” : “integer”  
},  
“PUBLISHER\_NAME” : {  
“type” : “keyword”  
},  
“STATE” : {  
“type” : “keyword”  
},  
“ZIP” : {  
“type” : “keyword”  
},  
“\_siren” : {  
“properties” : {  
“sic” : {  
“properties” : {  
“namespace” : {  
“type” : “keyword”  
}  
}  
}  
}  
}  
}  
}  
}  
}

Not sure what needs to be changed to eliminate the error. Thanks for your help!

---

<div class="post-metadata">

**Author:** ![Simon\_Danielczyk](https://yyz2.discourse-cdn.com/flex032/user_avatar/community.siren.io/simon_danielczyk/32/57_2.png) [@Simon\_Danielczyk](https://community.siren.io/u/Simon_Danielczyk)\
**Post date:** [April 14, 2021, 4:23pm UTC](https://community.siren.io/t/federated-query-error/376/2 "2021-04-14T16:23:15Z")

</div>

Hi Dave

Could you try to put “siren/” in front of you index Like  
siren/siren-import-home-publishers/\_search

This will tell the system to use the “/siren” endpoint to handle the join query

Best Regards  
Simon

---

<div class="post-metadata">

**Author:** ![dmwpepper](https://avatars.discourse-cdn.com/v4/letter/d/ce73a5/32.png) [@dmwpepper](https://community.siren.io/u/dmwpepper)\
**Post date:** [April 14, 2021, 4:47pm UTC](https://community.siren.io/t/federated-query-error/376/3 "2021-04-14T16:47:01Z")

</div>

Thanks, Simon! That did solve the problem. Subtle things like that.

Dave