tags:

views:

26

answers:

1
Q: 

Can Solr return the actual final query that was used when synonyms and stemming are used?

Hello, I would like to be able to show in my UI what the query terms were that solr used to run the final query. For example, I might type the query "run" but behind the scenes solr will use stemming to also query "ran" and "running", I may also have a synonym defined which has "run = sprint".

I would like to show the user that although they typed in "run" the actual query was "run ran running sprint"

Any easy way to do this?

Thanks!

+1  A: 

Try setting debugQuery=on. See this and this.

Mauricio Scheffer  2010-08-19 15:12:00
Thanks Mauricio.Do you know how much of a performance hit this is (if any)?Would you know of any way to get the same information without the other debugging information?It doesn't seem right to be using debugQuery in a production system.
Pinguthepenguin  2010-08-20 14:29:23
@Pinguthepenguin: Re performance: measure it. It's not free, that's for sure, but I don't think it will be too slow either. I don't know any other way to do this, it's only available through debugQuery since it *is* a debugging tool and not something that is normally exposed to the end user.
Mauricio Scheffer  2010-08-20 15:15:43

related questions

How do you create a parameterized query in MS Access 2003 and use other queries/forms to fill the parameters and obtain a resultset
How do I return random numbers as a column in SQL Server 2005?
SQL Text Searching, AND Ordering
How to programmatically make a Query in MS Access default to landscape when printed
SQL Query - Use Like only if no exact match exists?
SharePoint Content Query Web Part
Which is faster/best? SELECT * or SELECT column1, colum2, column3, etc.
How to force nolock hint for sql server logins
What table/view do you query against to select all the table names in a schema in Oracle?
SQL Query to get latest price
How can I monitor the executed sql statements on a ms SQL server 2005
SQL: Select like column from two tables
C# - SQLClient - Simplest INSERT
Do indexes work with "IN" clause
Table Scan vs. Add Index - which is quicker?
Mysql: Using "AND" Operation on tags and categories tables in Wordpress
use table metadata for select statement in SQL Server?
Why are relational set-based queries better than cursors?
is it better to structure an SQL table to have a match, or return no result
SQL/Query tools?
SQL query to compare product sales by month
SQL, Auxiliary table of numbers
How do I Concatenate entire result sets in MySQL?
Multiple Updates in MySQL
Why doesn't SQL Full Text Indexing return results for words containing #?