Federated query error

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

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!

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

1 Like

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

Dave