Question #1:
triple_type collection has a few hundred docs and triple has 25M docs.
When I search for a particular subject_id in triple which I know has 14
results and do not pass in 'rows' params, it returns 0 results:
innerJoin(
search(triple, q=subject_id:1656521, fl="triple_id,subject_id,type_id",
sort="type_id asc"),
search(triple_type, q=*:*, fl="triple_type_id,triple_type_label",
sort="triple_type_id asc"),
on="type_id=triple_type_id"
)
When I do the same search with rows=10000, it returns 14 results:
innerJoin(
search(triple, q=subject_id:1656521, fl="triple_id,subject_id,type_id",
sort="type_id asc", rows=10000),
search(triple_type, q=*:*, fl="triple_type_id,triple_type_label",
sort="triple_type_id asc", rows=10000),
on="type_id=triple_type_id"
)
Am I doing this right? Is there a magic number to pass into rows which
says "give me all the results which match this query"?
Question #2:
Perhaps related to the first question but I want to run the innerJoin()
without the subject_id - rather have it use the results of another query.
But this does not return any results. I'm saying "search for this entity
based on id then use that result's entity_id as the subject_id to look
through the triple/triple_type collections:
hashJoin(
innerJoin(
search(triple, q=*:*, fl="triple_id,subject_id,type_id",
sort="type_id asc"),
search(triple_type, q=*:*, fl="triple_type_id,triple_type_label",
sort="triple_type_id asc"),
on="type_id=triple_type_id"
),
hashed=search(entity,
q=id:"urn:sid:entity:455dfa1aa27eedad21ac2115797c1580bb3b3b4e",
fl="entity_id,entity_label", sort="entity_id asc"),
on="subject_id=entity_id"
)
Am I using doing this hashJoin right?
Thanks very much, Ryan
