You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Frank A <fs...@gmail.com> on 2010/08/18 16:08:26 UTC

Help Debugging Delta Query

Hi,

I'm trying to use a delta query to update a specific entity by its
primary key.  The URL I'm using is:

http://localhost:8080/solr/core2/dataimport?command=delta-import&did=5&commit=true&debug=true

Where 5 is the PK.

In my db config I have:

            <entity name="place"
            	query="select OurID,Name,City,State,lat,lng,cost from place"
                deltaQuery="select OurID from place where OurID=
'${dataimporter.request.did}'"
                deltaImportQuery="select
OurID,Name,City,State,lat,lng,cost from place where
OurID='${dataimporter.delta.id}'"
                >

When I run the URL above I see the following results:

<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">0</int>
</lst>
<lst name="initArgs
<lst name="defaults">
<str name="config">db-data-config.xml</str>
</lst>
</lst>
<str name="command">delta-import</str>
<str name="status">idle</str>
<str name="importResponse"/>
<lst name="statusMessages">
<str name="Total Requests made to DataSource">2</str>
<str name="Total Rows Fetched">1</str>
<str name="Total Documents Skipped">0</str>
<str name="Delta Dump started">2010-08-18 10:06:17</str>
<str name="Identifying Delta">2010-08-18 10:06:17</str>
<str name="Deltas Obtained">2010-08-18 10:06:17</str>
<str name="Building documents">2010-08-18 10:06:17</str>
<str name="Total Changed Documents">1</str>
<str name="Total Documents Processed">0</str>
<str name="Time taken ">0:0:0.32</str>
</lst>

</response>

It looks like its finding the row, but for some reason it's not
processing it - any ideas?

Thanks.
Frank

Re: Help Debugging Delta Query

Posted by nagarjuna <na...@gmail.com>.
Hi  iorixxx 

did u got it? can u pls explain it?


thanks in advance

--
View this message in context: http://lucene.472066.n3.nabble.com/Help-Debugging-Delta-Query-tp1206439p3371647.html
Sent from the Solr - User mailing list archive at Nabble.com.

Re: Help Debugging Delta Query

Posted by Frank A <fs...@gmail.com>.
Uhg... my mistake.

Thanks!


On Wed, Aug 18, 2010 at 10:22 AM, Ahmet Arslan <io...@yahoo.com> wrote:
>> I'm trying to use a delta query to update a specific entity
>> by its
>> primary key.  The URL I'm using is:
>>
>> http://localhost:8080/solr/core2/dataimport?command=delta-import&did=5&commit=true&debug=true
>>
>> Where 5 is the PK.
>>
>> In my db config I have:
>>
>>             <entity
>> name="place"
>>
>>     query="select
>> OurID,Name,City,State,lat,lng,cost from place"
>>
>> deltaQuery="select OurID from place where OurID=
>> '${dataimporter.request.did}'"
>>
>> deltaImportQuery="select
>> OurID,Name,City,State,lat,lng,cost from place where
>> OurID='${dataimporter.delta.id}'"
>>
>> >
>>
>> When I run the URL above I see the following results:
>>
>> <response>
>> <lst name="responseHeader">
>> <int name="status">0</int>
>> <int name="QTime">0</int>
>> </lst>
>> <lst name="initArgs
>> <lst name="defaults">
>> <str name="config">db-data-config.xml</str>
>> </lst>
>> </lst>
>> <str name="command">delta-import</str>
>> <str name="status">idle</str>
>> <str name="importResponse"/>
>> <lst name="statusMessages">
>> <str name="Total Requests made to
>> DataSource">2</str>
>> <str name="Total Rows Fetched">1</str>
>> <str name="Total Documents Skipped">0</str>
>> <str name="Delta Dump started">2010-08-18
>> 10:06:17</str>
>> <str name="Identifying Delta">2010-08-18
>> 10:06:17</str>
>> <str name="Deltas Obtained">2010-08-18
>> 10:06:17</str>
>> <str name="Building documents">2010-08-18
>> 10:06:17</str>
>> <str name="Total Changed Documents">1</str>
>> <str name="Total Documents Processed">0</str>
>> <str name="Time taken ">0:0:0.32</str>
>> </lst>
>>
>> </response>
>>
>> It looks like its finding the row, but for some reason it's
>> not
>> processing it - any ideas?
>
> Shouldn't it be OurID='${dataimporter.delta.OurID}' in deltaQuery?
>
>
>
>

Re: Help Debugging Delta Query

Posted by Ahmet Arslan <io...@yahoo.com>.
> I'm trying to use a delta query to update a specific entity
> by its
> primary key.  The URL I'm using is:
> 
> http://localhost:8080/solr/core2/dataimport?command=delta-import&did=5&commit=true&debug=true
> 
> Where 5 is the PK.
> 
> In my db config I have:
> 
>             <entity
> name="place"
>            
>     query="select
> OurID,Name,City,State,lat,lng,cost from place"
>                
> deltaQuery="select OurID from place where OurID=
> '${dataimporter.request.did}'"
>                
> deltaImportQuery="select
> OurID,Name,City,State,lat,lng,cost from place where
> OurID='${dataimporter.delta.id}'"
>                
> >
> 
> When I run the URL above I see the following results:
> 
> <response>
> <lst name="responseHeader">
> <int name="status">0</int>
> <int name="QTime">0</int>
> </lst>
> <lst name="initArgs
> <lst name="defaults">
> <str name="config">db-data-config.xml</str>
> </lst>
> </lst>
> <str name="command">delta-import</str>
> <str name="status">idle</str>
> <str name="importResponse"/>
> <lst name="statusMessages">
> <str name="Total Requests made to
> DataSource">2</str>
> <str name="Total Rows Fetched">1</str>
> <str name="Total Documents Skipped">0</str>
> <str name="Delta Dump started">2010-08-18
> 10:06:17</str>
> <str name="Identifying Delta">2010-08-18
> 10:06:17</str>
> <str name="Deltas Obtained">2010-08-18
> 10:06:17</str>
> <str name="Building documents">2010-08-18
> 10:06:17</str>
> <str name="Total Changed Documents">1</str>
> <str name="Total Documents Processed">0</str>
> <str name="Time taken ">0:0:0.32</str>
> </lst>
> 
> </response>
> 
> It looks like its finding the row, but for some reason it's
> not
> processing it - any ideas?

Shouldn't it be OurID='${dataimporter.delta.OurID}' in deltaQuery?