topic Re: How to set hybridEnabled true in DbOrIndexSwitchingQueryLanguage alfresco solr? in Alfresco Forum

How to set hybridEnabled true in DbOrIndexSwitchingQueryLanguage alfresco solr?

devkinandanchau — Thu, 18 Oct 2018 11:02:43 GMT

Using Alfresco Community - 5.0.0 version.Use Case: For fetching documents we want to query Solr first then DB.First I've tried below properties in alfresco-global.properties file:solr.query.cmis.queryConsistency=EVENTUALsolr.query.fts.queryConsistency=EVENTUALAfter the above changes, I was able to s

Re: How to set hybridEnabled true in DbOrIndexSwitchingQueryLanguage alfresco solr?

afaust — Thu, 18 Oct 2018 11:46:35 GMT

It looks like you have already looked into the source code, so you might have seen the property solr.query.hybrid.enabled used to configure to property you mentioned from the DbOrIndexSwitchingQueryLanguage class.

As far as I know, the HYBRID mode is not officially supported / recommended. In fact, the documentation even mentions that in the page about the admin console configuration page for SOLR.

Re: How to set hybridEnabled true in DbOrIndexSwitchingQueryLanguage alfresco solr?

devkinandanchau — Tue, 23 Oct 2018 11:32:34 GMT

If I use queryConsistency=EVENTUAL then it'll hit the Solr.

If queryConsistency=HYBRID then it'll hit Solr and DB.

Is there any way to hit Solr first and if there are no results from Solr then it'll query the DB?

Re: How to set hybridEnabled true in DbOrIndexSwitchingQueryLanguage alfresco solr?

afaust — Wed, 24 Oct 2018 10:45:46 GMT

There is no such option and no way to do that, unless you were to completely replace the DbOrIndexSwitchingQueryLanguage implementation.