Hi :s
Sorry I tried that : /video/dataimport?command=full-import&min=0&max=10000
and I put at the end of my request : WHERE video.video_id between
${dataimport.request.min} and ${dataimport.request.max}"
But I've an error and my log bring me back : WHERE video.video_id between
and Processing Document
Did I miss something ?
Thanks,
Noble Paul നോബിള് नोब्ळ् wrote:
>
> Say you pass two extra params offset and count
> as offset=0&count=10
>
> and your query is
> select * from x limit ${dataimport.request.offset},
> ${dataimport.request.count}
>
> On Wed, Nov 5, 2008 at 2:39 PM, sunnyfr <[EMAIL PROTECTED]> wrote:
>>
>> Sorry I'm quite new in Java,
>>
>> So I should add in my data-config something like:
>> <document name="param" value="limit 1000">
>>
>> And then in dataimporter add this dataimport.request.param at the end of
>> my
>> query.
>> I just don't get where it does collect this query, didn't find it in my
>> dataimpoter.
>>
>> Sorry a lot for that,
>>
>>
>> Noble Paul നോബിള് नोब्ळ् wrote:
>>>
>>> If all that you wish to do is adding a start and limit
>>>
>>> you can pass the parameters as request parameters. The parameter name
>>> can be anything. You can use those values in the query as
>>> $dataimporter.request.<param-name>}
>>>
>>> --Noble
>>>
>>> On Wed, Nov 5, 2008 at 2:55 AM, sunnyfr <[EMAIL PROTECTED]> wrote:
>>>>
>>>> Hi Shalin,
>>>> Thanks for your answer. I tried to understand how work DocBuilder,
>>>> didn't
>>>> get really where can I get the request from query and add at the end
>>>> limit
>>>> ??
>>>> What about this debug ??? Where can I find it ??
>>>> Thanks a lot,
>>>>
>>>>
>>>> Shalin Shekhar Mangar wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>> Most of that happens in DocBuilder#buildDocument method.
>>>>>
>>>>> Solr 1.3 has a bug which does not let the "start" and "rows" parameter
>>>>> work
>>>>> in normal mode (they work only in debug mode). The trunk versions have
>>>>> that
>>>>> bug fixed which can be used to limit indexing.
>>>>>
>>>>> On Tue, Nov 4, 2008 at 6:49 PM, sunnyfr <[EMAIL PROTECTED]> wrote:
>>>>>
>>>>>>
>>>>>> Hi everybody
>>>>>> I'm using solr 1.3 and mysql, and the query is too big to get back
>>>>>> rows
>>>>>> without OOM
>>>>>> I would to modify the code cuz I can't use batchSize -1 on the
>>>>>> production
>>>>>> database during 10hours without stack other process on it.
>>>>>>
>>>>>> So I would like to make several request on it with a limit between a
>>>>>> and
>>>>>> b
>>>>>> ...
>>>>>> I've the class jdbcdataimport which make the connection with mysql
>>>>>> but
>>>>>> I
>>>>>> just don't where can I find the class which collect the query or the
>>>>>> deltaQuery from data-config.xml.
>>>>>>
>>>>>> Thanks a lot for your help,
>>>>>>
>>>>>> --
>>>>>> View this message in context:
>>>>>> http://www.nabble.com/dataimporthandler-where-is-the-class-chich-collect-query-and-deltaQuery-tp20322092p20322092.html
>>>>>> Sent from the Solr - Dev mailing list archive at Nabble.com.
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Shalin Shekhar Mangar.
>>>>>
>>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/dataimporthandler-where-is-the-class-chich-collect-query-and-deltaQuery-tp20322092p20331492.html
>>>> Sent from the Solr - Dev mailing list archive at Nabble.com.
>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> --Noble Paul
>>>
>>>
>>
>> --
>> View this message in context:
>> http://www.nabble.com/dataimporthandler-where-is-the-class-chich-collect-query-and-deltaQuery-tp20322092p20338240.html
>> Sent from the Solr - Dev mailing list archive at Nabble.com.
>>
>>
>
>
>
> --
> --Noble Paul
>
>
--
View this message in context:
http://www.nabble.com/dataimporthandler-where-is-the-class-chich-collect-query-and-deltaQuery-tp20322092p20339768.html
Sent from the Solr - Dev mailing list archive at Nabble.com.
