Could Hibernate Search do search like SQL"select * FROM TABLE WHERE A = B"?


#1

I want to do a search , search an Entity A which A.B = A.C,could I finish this search By Hibernate Search Lucene queries?


#2

There’s no built-in support for this in Hibernate Search itself.

I suppose that, if you’re using the Lucene integration (and not the Elasticsearch one), you could get your hands dirty, use low-level Lucene APIs and execute a join query (see “Query-time joins” here), but it will be rather complex, and I can’t give you much information beyond the fact you’ll have to access the IndexReader at some point.


#3

Thanks for your answer.