The ability of join operation supported as what http://wiki.apache.org/solr/Join says is so limited. I'm thinking how to support standard join operation in Solr/Lucene because not all can be de-normalized efficiently.
Take 2 schemas below as an example: (1) Student sid name cid // class id (2) class cid name major In SQL, it will be easy to get all students' name and its class name where student's name start with 'p' and class's major is "CS". Select s.name, c.name from student s, class c where s.name like 'p%' and c.major = "CS". How Solr/Lucene support the above query? It seems they do not. Thanks, ________________________________ Robert Yu Application Service - Backend Morningstar Shenzhen Ltd. Morningstar. Illuminating investing worldwide. +86 755 3311-0223 voice +86 137-2377-0925 mobile +86 755 0000-0000 fax robert...@morningstar.com<mailto:robert...@morningstar.com> 8FL, Tower A, Donghai International Center ( or East Pacific International Center) 7888 Shennan Road, Futian district, Shenzhen, Guangdong province, China 518040 http://cn.morningstar.com<http://cn.morningstar.com/> This e-mail contains privileged and confidential information and is intended only for the use of the person(s) named above. Any dissemination, distribution, or duplication of this communication without prior written consent from Morningstar is strictly prohibited. If you have received this message in error, please contact the sender immediately and delete the materials from any computer.