Mixing Lucene FullTextQuery and HQL?

skausl · **Posted:** Fri Mar 02, 2007 8:34 am

Is it possible to mix a Lucene FullTextQuery and HQL?

I need a full text search for product names.
Moreover products are selected by prices, shops etc.

Maybe a kind of FullTextCriteria would be helpful!?

Scenario:

Code:

select * from products where name like '%canon%';

Because LIKE is very slow I use Lucene for full text search.

Next, I select products with a given name and price range.

Code:

select * from products where name like '%canon%' and price between 100 and 200;

Maybe it's not very elegant, but it's possible to manage price ranges with Lucene.

Last, I search products belonging to specific shops:

Code:

select * from products p left join shop s on p.shop_id=s.id 
where s.postcode like '2%' and p.name like '%canon%' and p.price between 100 and 200;

This is not possible with a Lucene FullTextQuery. Therefore I want to combine Lucene FullTextQuery with HQL or Criterias.

emmanuel · **Posted:** Fri Mar 02, 2007 12:52 pm

The main problem is that you need to do that in 2 steps, ie load all the ids from the Lucene query, then apply a HQL query with an additional in restriction.
This does not work well esp if the Lucene query is not discriminative enough.

Your actual scenario should be made possible though.
You should be able to store the shop location informations into the product index (falling back to a single Lucene query)

Today you can solve the issue writing a custom FieldBridge, but I hope to indroduce a more generic solution sometimes in the future.

emmanuel · **Posted:** Wed Mar 07, 2007 7:21 pm

Your problem is fixed :-)
http://opensource.atlassian.com/projects/hibernate/browse/HSEARCH-27

skausl · **Posted:** Thu Mar 08, 2007 3:41 am

Great :-)
Will it ship with the next Hibernate version?
Some more documentation and a demo would be nice...

emmanuel · **Posted:** Thu Mar 08, 2007 7:16 pm

Yes it will ship with the next version, I still need to refine a couple of things
You mean more doc than what's inside SVN?