Re: Query does not work when changing param order

2011-08-18 Thread Juan Manuel Alvarez
sult in a more efficient use of filterCache. > > Regards, > > *Juan* > > > > On Thu, Jul 7, 2011 at 12:07 PM, Juan Manuel Alvarez > wrote: > >> Hi everyone! >> >> I would like to ask you a question about a problem I am facing with a >> Solr query

Query does not work when changing param order

2011-07-07 Thread Juan Manuel Alvarez
Hi everyone! I would like to ask you a question about a problem I am facing with a Solr query. I have a field "tags" of type "textgen" and some documents with the values "myothertag,mytag". When I use the query: /solr/select?sort=name_sort+asc&start=0&qf=tags&q.alt=*:*&fq={!field q.op=AND f=tags

Re: Search in all the documents

2011-03-18 Thread Juan Manuel Alvarez
Thanks!!! That did the trick! =o) On Fri, Mar 18, 2011 at 5:09 PM, Ahmet Arslan wrote: >> I am trying to search in all documents using the dismax >> parser. >> >> A sample query that works using the q parameter goes like >> this: >> select/?q=air&qf=description%20name&start=0&rows=60&sort=name+as

Search in all the documents

2011-03-18 Thread Juan Manuel Alvarez
Hello everyone! I would like to ask you a question. I am trying to search in all documents using the dismax parser. A sample query that works using the q parameter goes like this: select/?q=air&qf=description%20name&start=0&rows=60&sort=name+asc&fq=(projectId:1)&defType=dismax&fq=(type:3)&fq=(fol

Re: How to integrate Solr with C/CPP client

2011-01-05 Thread Juan Manuel Alvarez
I use the POCO C++ library (http://pocoproject.org/) to send HTML requests to Solr and to parse the XML response. Cheers! Juan M. On Wed, Jan 5, 2011 at 1:28 AM, Gora Mohanty wrote: > On Wed, Jan 5, 2011 at 9:54 AM, prasad deshpande > wrote: >> It seems Solr/Lucene is completely developed in Ja

Re: UPDATE query in deltaquery

2011-01-03 Thread Juan Manuel Alvarez
I finally worked it out! The setting that was giving me trouble was autocommit. I set it to true and now the UPDATE queries are reflected in the database. Cheers! Juan M. On Thu, Dec 30, 2010 at 3:19 PM, Juan Manuel Alvarez wrote: > Hi Ephraim! Thanks again for taking the time to help

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
ems perform the update first and then > the select? Does it make a difference if you change the order? Did you try > omitting the TRANSACTION_SERIALIZABLE part? > > Ephraim Ofir > > -Original Message- > From: Juan Manuel Alvarez [mailto:naici...@gmail.com] > Sent: Thurs

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
id from blah > > But if that doesn't work then you may be out of luck. > > cheers, > > Travis > > On Thu, Dec 30, 2010 at 8:26 AM, Juan Manuel Alvarez > wrote: > >> Erick: >> >> Thanks for the quick response. >> >> I can't use

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
're using has > permissions to do the updates you want? Not sure about postgres but I > think some jdbc's require that the connection be defined as rw, maybe > you should try adding readOnly="false" to your jdbc definition. > > Ephraim Ofir > > -----Origi

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
t the UPDATE has no effect on the database" > Or do you mean "effect on the index"? If the latter, then the select > would only have a chance of updating the IDs of the Solr documents... > > At least I think that's close to reality... > > Best >

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
ids. The ids are returned ok, but the UPDATE has no effect on the database. Cheers! Juan M. On Thu, Dec 30, 2010 at 1:32 AM, Erick Erickson wrote: > Well, let's see the queries you're sending, and your DIH configuration. > > Otherwise, we're just guessing... > > B

UPDATE query in deltaquery

2010-12-29 Thread Juan Manuel Alvarez
Hi! I would like to ask you a question about using a deltaQuery in DIH. I am syncing with a PostgreSQL database. At first I was calling a function that made two queries: an UPDATE and a SELECT. The select result was properly returned, but the UPDATE query did not made any changes, so I tried calli

Re: Syncing 'delta-import' with 'select' query

2010-12-20 Thread Juan Manuel Alvarez
ira/browse/SOLR-1721 > > On Wed, Dec 8, 2010 at 11:21 PM, Juan Manuel Alvarez > wrote: >> Hello everyone! >> I have been doing some tests, but it seems I can't make the >> synchronize flag work. >> >> I have made two tests: >> 1) DIH with comm

Re: Concurrent DIH calls

2010-12-13 Thread Juan Manuel Alvarez
Thanks for the answer Barani! I was doing the same thing (queuing requests and querying solr status), but I was hoping some flag/configuration would do the trick. I will continue with that approach then! =o) Thanks! Juan M. On Sat, Dec 11, 2010 at 3:50 AM, bbarani wrote: > > Hi, > > As far as I

Concurrent DIH calls

2010-12-09 Thread Juan Manuel Alvarez
Hello!!! I am working with Solr on my first project and I am really happy so far, both with the product and with the community. I am having some doubts about how DIH works. How does DIH handles concurrent requests from different users? Does it queue them? Or if an import is in progress it reject

Re: Syncing 'delta-import' with 'select' query

2010-12-08 Thread Juan Manuel Alvarez
ectUpdateHandler2 commit INFO: start commit(optimize=false,waitFlush=true,waitSearcher=true,expungeDeletes=false) In (2) it seems like the commit is being fired before the delta-update finishes. Am I using the "synchronous" flag right? Thanks in advance! Juan M. On Mon, Dec 6, 2010

Re: Syncing 'delta-import' with 'select' query

2010-12-06 Thread Juan Manuel Alvarez
Thanks for all the help! It is really appreciated. For now, I can afford the parallel requests problem, but when I put synchronous=true in the delta import, the call still returns with outdated items. Examining the log, it seems that the commit operation is being executed after the operation retur

Re: Syncing 'delta-import' with 'select' query

2010-12-06 Thread Juan Manuel Alvarez
> previous request is still running it bounces the second request. > > HTH, > Alex > > > > On Fri, Dec 3, 2010 at 10:33 PM, Juan Manuel Alvarez > wrote: >> Hello everyone! I would like to ask you a question about DIH. >> >> I am using a database and DIH to

Syncing 'delta-import' with 'select' query

2010-12-03 Thread Juan Manuel Alvarez
Hello everyone! I would like to ask you a question about DIH. I am using a database and DIH to sync against Solr, and a GUI to display and operate on the items retrieved from Solr. When I change the state of an item through the GUI, the following happens: a. The item is updated in the DB. b. A del

Re: Updating last_modified field when using DIH

2010-11-05 Thread Juan Manuel Alvarez
ity and run again at 11:20 .. > then, no > entity will match the delta-query because solr will ask for a > modification_date > 11:10 (last solr-run at this time). > > you'll only need to update the last_modified field (in your application) > when the entity is changed and

Updating last_modified field when using DIH

2010-11-02 Thread Juan Manuel Alvarez
Hello everyone! I would like to ask you a question about DIH and delta import. I am trying to sync Solr with a PostgreSQL database and I have a field "ent_lastModified" of type "timestamp without timezone". Here is my xml file: Full-import works fine, but whe

Re: Using different schemas when syncing with PostgreSQL and DIH

2010-10-22 Thread Juan Manuel Alvarez
Thank you Shawn! That was exactly what I was looking for! =o) On Fri, Oct 22, 2010 at 4:29 PM, Shawn Heisey wrote: > On 10/22/2010 10:06 AM, Juan Manuel Alvarez wrote: >> >> My question is: >> Every time I do an import operation (delta or full) with DIH, I only >> need

Using different schemas when syncing with PostgreSQL and DIH

2010-10-22 Thread Juan Manuel Alvarez
Hello everyone! I am using Solr synced with a PostgreSQL database using DIH and I am facing an issue. The thing is that I use one Solr server and different Postgre schemas in the same database, with the same tables inside each one, so the following queries: SELECT * FROM "schema1"."Objects"; and

Re: Synchronizing Solr with a PostgreDB

2010-10-15 Thread Juan Manuel Alvarez
distro. > > allistair > > On Oct 14, 2010, at 6:13 PM, Juan Manuel Alvarez wrote: > >> Hello everyone! I am new to Solr and Lucene and I would like to ask >> you a couple of questions. >> >> I am working on an existing system that has the data saved in a &g

Synchronizing Solr with a PostgreDB

2010-10-14 Thread Juan Manuel Alvarez
Hello everyone! I am new to Solr and Lucene and I would like to ask you a couple of questions. I am working on an existing system that has the data saved in a Postgre DB and now I am trying to integrate Solr to use full-text search and faceted search, but I am having a couple of doubts about it.