Remove data from index
Hello I'm trying a way to do that : I index a db query like "select id from table_documents" Some documents are updated or deleted from the data table. Using DIH, I can indexe the updated document But I want to remove from the index the documents that were removed in the database. How could I do this? A way would be to delete in the index each time a doc is deleted in the database but this is not possible because I canot modify the code of my documents management tool Thanks a lot -- View this message in context: http://www.nabble.com/Remove-data-from-index-tp25063736p25063736.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Remove data from index
I hope it could be a solution. But I think I understood that u can use deletePkQuery like this "select document_id from table_document where statusDeleted= 'Y'" In my case I have no status like "statusDeleted". The request I would like to write is "Delete from my solr Index the id that are no longer present in my table_document" With Lucene I had a way to do that : open IndexReader, for each lucene document : check in table_document and remove in lucene index if document is no longer present in the table -- View this message in context: http://www.nabble.com/Remove-data-from-index-tp25063736p25063965.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Remove data from index
hossman wrote: > > : > The request I would like to write is > : > > : > "Delete from my solr Index the id that are no longer present in my > : > table_document" > : > > : > With Lucene I had a way to do that : > : > open IndexReader, > : > for each lucene document : check in table_document and remove in > lucene > : > index if document is no longer present in the table > > you can still do that with Solr, you can even do it as a Solr plugin (I > would suggest a RequestHandler that you hit after each DIH call) so > you can reuse your existing code that deals directly with an IndexReader > -- but you'd probably want to tweak it a bit to use the UpdateHandler from > the SolrCore instead of deleting the doc direclty, that way it's logged > properly and you can trigger a commit to make Solr aware you've modified > the index. > > -Hoss > I read this answer and tried to understand the way to write new RequestHandler I think i begin to understand but don't see the way to implement it to resolve my problem. If I lit my CustomRequestHandler after each DIH how can it solve my delta pb as the DIH -- View this message in context: http://www.nabble.com/Remove-data-from-index-tp25063736p25076138.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Remove data from index
I don't understand this point. -- View this message in context: http://www.nabble.com/Remove-data-from-index-tp25063736p25080669.html Sent from the Solr - User mailing list archive at Nabble.com.
Drill down into hierarchical facet : how to?
Hello I'm looking for a way to do that I have a hierachical facet ex : Continent / Country / City / Blok Europe/France/Paris/Saint Michel America/USA/NYC/Chelsea etc ... I have some points of interest tagged in differents level of a same tree ex : some POI can be tagged Saint Michel and other tagged Paris etc ... I facet on a fiel "location". This i a fiel stored like this Continent/Country/City/Blok I want to drill down on this facet during the search and show the facets for the next level of a level Ex : When I search at the level continent I want to facet the level Europe, USA etc ... and to show all the results (Europe contains POI tagged as Europe and POI tagged as France for example) I know I can make a facet query something like Europe/France/* to search all POI in France but how can I show the facet level under France (Paris, Lyon etc ...) ??? Thank u -- View this message in context: http://www.nabble.com/Drill-down-into-hierarchical-facet-%3A-how-to--tp25235058p25235058.html Sent from the Solr - User mailing list archive at Nabble.com.
datadir configuration
hello As I try to deploy my app on a tomcat server, I'd like to custome datadir variable outside the solrconfig.xml file. Is there a way to custom it in a context file? Thanks -- View this message in context: http://www.nabble.com/datadir-configuration-tp25782469p25782469.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: datadir configuration
What do I put in
${solr.foo.data.dir:/default/path/to/datadir}
?
What is /default/path/to/datadir?
Gasol Wu wrote:
>
> Hi,
>
> add JAVA_OPTS variable in TOMCAT_HOME/bin/catalina.sh like below,
> JAVA_OPTS="$JAVA_OPTS -Dsolr.home=/opt/solr
> -Dsolr.foo.data.dir=/opt/solr/data"
>
> solr.data.dir must mapping to in solrconfig.xml
>
> here is example (solrconfig.xml):
> ${solr.foo.data.dir:/default/path/to/datadir}
>
> On Wed, Oct 7, 2009 at 4:27 PM, clico wrote:
>
>>
>> hello
>> As I try to deploy my app on a tomcat server, I'd like to custome datadir
>> variable outside the solrconfig.xml file.
>>
>> Is there a way to custom it in a context file?
>>
>> Thanks
>> --
>> View this message in context:
>> http://www.nabble.com/datadir-configuration-tp25782469p25782469.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/datadir-configuration-tp25782469p25783320.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: datadir configuration
I tried this in my context.xml It doesn't work -- View this message in context: http://www.nabble.com/datadir-configuration-tp25782469p25783937.html Sent from the Solr - User mailing list archive at Nabble.com.
manage rights
Hi everybody As I'm ready to deploy my solr server (after many tests and use cases) I'd like ton configure my server in order that some request cannot be post As an example : My CMS or data app can use - dataimport - and other indexing commands My website can only perform a search on the server could one explain me where this configuration has to be done? Thanks -- View this message in context: http://www.nabble.com/manage-rights-tp25784152p25784152.html Sent from the Solr - User mailing list archive at Nabble.com.
Facet query pb
Hello I have a pb trying to retrieve a tree with facet use I 've got a field location_field Each doc in my index has a location_field Location field can be continent/country/city I have 2 queries: http://server/solr//select?fq=(location_field:NORTH*) : ok, retrieve docs http://server/solr//select?fq=(location_field:NORTH AMERICA*) : not ok I think with NORTH AMERICA I have a pb with the space caractere Could u help me -- View this message in context: http://www.nabble.com/Facet-query-pb-tp25790667p25790667.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Facet query pb
That's not a pb I want to use that in order to drill down a tree Christian Zambrano wrote: > > Clico, > > Because you are doing a wildcard query, the token 'AMERICA' will not be > analyzed at all. This means that 'AMERICA*' will NOT match 'america'. > > On 10/07/2009 12:30 PM, Avlesh Singh wrote: >> I have no idea what "pb" mean but this is what you probably want - >> fq=(location_field:(NORTH AMERICA*)) >> >> Cheers >> Avlesh >> >> On Wed, Oct 7, 2009 at 10:40 PM, clico wrote: >> >> >>> Hello >>> I have a pb trying to retrieve a tree with facet use >>> >>> I 've got a field location_field >>> Each doc in my index has a location_field >>> >>> Location field can be >>> continent/country/city >>> >>> >>> I have 2 queries: >>> >>> http://server/solr//select?fq=(location_field:NORTH*)<http://server/solr//select?fq=%28location_field:NORTH*%29>: >>> ok, retrieve docs >>> >>> http://server/solr//select?fq=(location_field:NORTH<http://server/solr//select?fq=%28location_field:NORTH>AMERICA*) >>> : not ok >>> >>> >>> I think with NORTH AMERICA I have a pb with the space caractere >>> >>> Could u help me >>> >>> >>> >>> -- >>> View this message in context: >>> http://www.nabble.com/Facet-query-pb-tp25790667p25790667.html >>> Sent from the Solr - User mailing list archive at Nabble.com. >>> >>> >>> >> > > -- View this message in context: http://www.nabble.com/Facet-query-pb-tp25790667p25792177.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Facet query pb
clico wrote: > > That's not a pb > I want to use that in order to drill down a tree > > > Christian Zambrano wrote: >> >> Clico, >> >> Because you are doing a wildcard query, the token 'AMERICA' will not be >> analyzed at all. This means that 'AMERICA*' will NOT match 'america'. >> >> On 10/07/2009 12:30 PM, Avlesh Singh wrote: >>> I have no idea what "pb" mean but this is what you probably want - >>> fq=(location_field:(NORTH AMERICA*)) >>> >>> Cheers >>> Avlesh >>> >>> On Wed, Oct 7, 2009 at 10:40 PM, clico >>> wrote: >>> >>> >>>> Hello >>>> I have a pb trying to retrieve a tree with facet use >>>> >>>> I 've got a field location_field >>>> Each doc in my index has a location_field >>>> >>>> Location field can be >>>> continent/country/city >>>> >>>> >>>> I have 2 queries: >>>> >>>> http://server/solr//select?fq=(location_field:NORTH*)<http://server/solr//select?fq=%28location_field:NORTH*%29>: >>>> ok, retrieve docs >>>> >>>> http://server/solr//select?fq=(location_field:NORTH<http://server/solr//select?fq=%28location_field:NORTH>AMERICA*) >>>> : not ok >>>> >>>> >>>> I think with NORTH AMERICA I have a pb with the space caractere >>>> >>>> Could u help me >>>> >>>> >>>> >>>> -- >>>> View this message in context: >>>> http://www.nabble.com/Facet-query-pb-tp25790667p25790667.html >>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>> >>>> >>>> >>> >> >> > > I'm sorry, this syntax does not work anymore -- View this message in context: http://www.nabble.com/Facet-query-pb-tp25790667p25799911.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Facet query pb
clico wrote: > > > > clico wrote: >> >> That's not a pb >> I want to use that in order to drill down a tree >> >> >> Christian Zambrano wrote: >>> >>> Clico, >>> >>> Because you are doing a wildcard query, the token 'AMERICA' will not be >>> analyzed at all. This means that 'AMERICA*' will NOT match 'america'. >>> >>> On 10/07/2009 12:30 PM, Avlesh Singh wrote: >>>> I have no idea what "pb" mean but this is what you probably want - >>>> fq=(location_field:(NORTH AMERICA*)) >>>> >>>> Cheers >>>> Avlesh >>>> >>>> On Wed, Oct 7, 2009 at 10:40 PM, clico >>>> wrote: >>>> >>>> >>>>> Hello >>>>> I have a pb trying to retrieve a tree with facet use >>>>> >>>>> I 've got a field location_field >>>>> Each doc in my index has a location_field >>>>> >>>>> Location field can be >>>>> continent/country/city >>>>> >>>>> >>>>> I have 2 queries: >>>>> >>>>> http://server/solr//select?fq=(location_field:NORTH*)<http://server/solr//select?fq=%28location_field:NORTH*%29>: >>>>> ok, retrieve docs >>>>> >>>>> http://server/solr//select?fq=(location_field:NORTH<http://server/solr//select?fq=%28location_field:NORTH>AMERICA*) >>>>> : not ok >>>>> >>>>> >>>>> I think with NORTH AMERICA I have a pb with the space caractere >>>>> >>>>> Could u help me >>>>> >>>>> >>>>> >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/Facet-query-pb-tp25790667p25790667.html >>>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>>> >>>>> >>>>> >>>> >>> >>> >> >> > > I'm sorry, this syntax does not work anymore > When I try a debug mode here is the result +location_field:NORTH+location_field:AMERICA* My location_field is a type String, containing NORTH AMERICA/NY/NYC Thanks for helping me -- View this message in context: http://www.nabble.com/Facet-query-pb-tp25790667p25802964.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Facet query pb
clico wrote: > > > clico wrote: >> >> >> >> clico wrote: >>> >>> That's not a pb >>> I want to use that in order to drill down a tree >>> >>> >>> Christian Zambrano wrote: >>>> >>>> Clico, >>>> >>>> Because you are doing a wildcard query, the token 'AMERICA' will not be >>>> analyzed at all. This means that 'AMERICA*' will NOT match 'america'. >>>> >>>> On 10/07/2009 12:30 PM, Avlesh Singh wrote: >>>>> I have no idea what "pb" mean but this is what you probably want - >>>>> fq=(location_field:(NORTH AMERICA*)) >>>>> >>>>> Cheers >>>>> Avlesh >>>>> >>>>> On Wed, Oct 7, 2009 at 10:40 PM, clico >>>>> wrote: >>>>> >>>>> >>>>>> Hello >>>>>> I have a pb trying to retrieve a tree with facet use >>>>>> >>>>>> I 've got a field location_field >>>>>> Each doc in my index has a location_field >>>>>> >>>>>> Location field can be >>>>>> continent/country/city >>>>>> >>>>>> >>>>>> I have 2 queries: >>>>>> >>>>>> http://server/solr//select?fq=(location_field:NORTH*)<http://server/solr//select?fq=%28location_field:NORTH*%29>: >>>>>> ok, retrieve docs >>>>>> >>>>>> http://server/solr//select?fq=(location_field:NORTH<http://server/solr//select?fq=%28location_field:NORTH>AMERICA*) >>>>>> : not ok >>>>>> >>>>>> >>>>>> I think with NORTH AMERICA I have a pb with the space caractere >>>>>> >>>>>> Could u help me >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> View this message in context: >>>>>> http://www.nabble.com/Facet-query-pb-tp25790667p25790667.html >>>>>> Sent from the Solr - User mailing list archive at Nabble.com. >>>>>> >>>>>> >>>>>> >>>>> >>>> >>>> >>> >>> >> >> I'm sorry, this syntax does not work anymore >> > > > When I try a debug mode here is the result > > > +location_field:NORTH+location_field:AMERICA* > > > My location_field is a type String, containing > NORTH AMERICA/NY/NYC > > I can use > fq=(location_field:NORTH*AMERICA*) replacing all whitespaces by *, but I m > not sure that's a good solution > > Thanks for helping me > > > > one can help me? -- View this message in context: http://www.nabble.com/Facet-query-pb-tp25790667p25847849.html Sent from the Solr - User mailing list archive at Nabble.com.
