Apache Solr 컬럼 JOIN 검색...

19down voteaccepted

This comment says it's possible by using: {!join from=fromField to=toField fromIndex=fromCoreName}fromQuery I tried it myself, and here's a more detailed example: Have two cores brands {id,name} products {id, name, brand_id} BRANDS: {1, Apple}, {2, Samsung}, {3, HTC} PRODUCTS: {1, iPhone, 1}, {2, iPad, 1}, {3, Galaxy S3, 2}, {4, Galaxy Note, 2}, {5, One X, 3} http://example.com:8999/solr/brands/select?q=*:*&fq={!join from=brand_id to=id fromIndex=products}name:iPad This translates to something like: SELECT b.* FROM brands b INNER JOIN products p ON b.id=p.brand_id WHERE p.name="iPad"; Result will be: {id: "1", name:"Apple"}

이건 컬럼 조인 검색

http://stackoverflow.com/questions/12665797/is-solr-4-0-capable-of-using-join-for-multiple-core