Out of the box? No. Could you develop one? Probably, or at least a rough approximation, at least some of the time... but probably at a cost significantly greater than converting queries by hand.
If it is taking you 2-4 hours per query then that suggests that the query complexity is not amenable to any simple mechanical reverse engineering. What aspects of the conversion is taking your so many hours? A few examples would be helpful. A mechanical reverse engineering from results would likely reduce the semantic content of the original query, so that the query may then return a false positive or false negative as new documents are added to the index that are no longer in the same pattern as the old results by still within the pattern of the original Oracle query. The trick may be whether the delta is meaningful for the actual application use case. -- Jack Krupansky On Thu, Feb 18, 2016 at 4:07 AM, Christian Effertz <seme...@gmail.com> wrote: > Hi, > > Can I somehow feed Solr with a result set or a list of primary keys and get > the shortest query that leads to this result? In other terms, can I reverse > engineer a query for a given result set? > > Some background why I ask this question: > We are currently migrating a search application from Oracle Text to Solr. > Our users have several (>30) complex queries that we need to migrate to our > new Solr index. This can be done by hand, but is rather time consuming. To > get an idea of how long the whole task would need, we started with a hand > full of them. We spent ~2-4h per query to get everything right. > > Thank you for your input >
