Re: Query does not work when changing param order

2011-08-18 Thread Juan Manuel Alvarez
efficient use of filterCache. Regards, *Juan* On Thu, Jul 7, 2011 at 12:07 PM, Juan Manuel Alvarez naici...@gmail.comwrote: 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

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+ascstart=0qf=tagsq.alt=*:*fq={!field q.op=AND

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=airqf=description%20namestart=0rows=60sort=name+ascfq=(projectId:1)defType=dismaxfq=(type:3)fq=(folder:0)

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 g...@mimirtech.com wrote: On Wed, Jan 5, 2011 at 9:54 AM, prasad deshpande prasad.deshpand...@gmail.com wrote: It

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 naici...@gmail.com wrote: Hi Ephraim! Thanks again for taking the time

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
, 2010 at 1:32 AM, Erick Erickson erickerick...@gmail.com wrote: Well, let's see the queries you're sending, and your DIH configuration. Otherwise, we're just guessing... Best Erick On Wed, Dec 29, 2010 at 9:58 PM, Juan Manuel Alvarez naici...@gmail.comwrote: Hi! I would like to ask you

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
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 Erick On Thu, Dec 30, 2010 at 7:52 AM, Juan Manuel Alvarez naici...@gmail.comwrote: Hi Erick! Here is my DIH configuration

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
Message- From: Juan Manuel Alvarez [mailto:naici...@gmail.com] Sent: Thursday, December 30, 2010 2:52 PM To: solr-user@lucene.apache.org Subject: Re: UPDATE query in deltaquery Hi Erick! Here is my DIH configuration: dataConfig    dataSource name=jdbc driver=org.postgresql.Driver url

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
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 naici...@gmail.comwrote: Erick: Thanks for the quick response. I can't use the timestamp for doing DIH, so I need to use a custom field that I need to update

Re: UPDATE query in deltaquery

2010-12-30 Thread Juan Manuel Alvarez
get_deltaimport_items 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: Thursday, December 30

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

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

2010-12-20 Thread Juan Manuel Alvarez
/browse/SOLR-1721 On Wed, Dec 8, 2010 at 11:21 PM, Juan Manuel Alvarez naici...@gmail.com 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 commit=false 2) DIH with commit=false + commit via Solr XML

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 bbar...@gmail.com wrote: Hi,

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

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

2010-12-08 Thread Juan Manuel Alvarez
before the delta-update finishes. Am I using the synchronous flag right? Thanks in advance! Juan M. On Mon, Dec 6, 2010 at 6:46 PM, Juan Manuel Alvarez naici...@gmail.com wrote: Thanks for all the help! It is really appreciated. For now, I can afford the parallel requests problem, but when I

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

2010-12-06 Thread Juan Manuel Alvarez
. HTH, Alex On Fri, Dec 3, 2010 at 10:33 PM, Juan Manuel Alvarez naici...@gmail.com wrote: 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

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

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

Re: Updating last_modified field when using DIH

2010-11-05 Thread Juan Manuel Alvarez
). you'll only need to update the last_modified field (in your application) when the entity is changed and you want solr to (re-)index your data. HTH, Stefan On Tue, Nov 2, 2010 at 7:35 PM, Juan Manuel Alvarez naici...@gmail.comwrote: Hello everyone! I would like to ask you a question about DIH

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: dataConfig dataSource name=jdbc driver=org.postgresql.Driver

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: 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 s...@elyograg.org 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 to sync the index

Re: Synchronizing Solr with a PostgreDB

2010-10-15 Thread Juan Manuel Alvarez
, 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 Postgre DB and now I am trying to integrate Solr to use full-text search and faceted search