RE: Delta Import with something other than Date

2010-09-12 Thread Ephraim Ofir
id in last_id_table (for the next delta-import) in addition to returning the data from the query. Ephraim Ofir -Original Message- From: Shawn Heisey [mailto:s...@elyograg.org] Sent: Friday, September 10, 2010 4:54 AM To: solr-user@lucene.apache.org Subject: Re: Delta Import with some

Re: Delta Import with something other than Date

2010-09-10 Thread Alexey Serba
> Can you provide a sample of passing the parameter via URL? And how using it > would look in the data-config.xml http://wiki.apache.org/solr/DataImportHandler#Accessing_request_parameters

Re: Delta Import with something other than Date

2010-09-09 Thread Shawn Heisey
On 9/9/2010 1:23 PM, Vladimir Sutskever wrote: Shawn, Can you provide a sample of passing the parameter via URL? And how using it would look in the data-config.xml Here's the URL that I send to do a full build on my last shard: http://idxst5-a:8983/solr/build/dataimport?command=full-import

RE: Delta Import with something other than Date

2010-09-09 Thread Vladimir Sutskever
Subject: Re: Delta Import with something other than Date On 9/8/2010 4:32 PM, David Yang wrote: > I have a table that I want to index, and the table has no datetime > stamp. However, the table is append only so the primary key can only go > up. Is it possible to store the last primary key

Re: Delta Import with something other than Date

2010-09-09 Thread Shawn Heisey
On 9/8/2010 4:32 PM, David Yang wrote: I have a table that I want to index, and the table has no datetime stamp. However, the table is append only so the primary key can only go up. Is it possible to store the last primary key, and use some delta query="select id where id>${last_id_value}" I

Re: Delta Import with something other than Date

2010-09-08 Thread Lukas Kahwe Smith
On 09.09.2010, at 00:44, David Yang wrote: > Currently DIH delta import uses the SQL query of type "select id from > item where last_modified > ${dataimporter.last_index_time}" > What I need is some field like ${dataimporter.last_primary_key} > wiki.apache.org/solr/DataImportHandler > I am thinki

Re: Delta Import with something other than Date

2010-09-08 Thread Lance Norskog
To: solr-user@lucene.apache.org Subject: Re: Delta Import with something other than Date Of course you can store whatever you want in a solr index. And if you store an integer as a Solr 1.4 "int" type, you can certainly query for all documents that have greater than some specified integer in a fi

RE: Delta Import with something other than Date

2010-09-08 Thread David Yang
To: solr-user@lucene.apache.org Subject: Re: Delta Import with something other than Date Of course you can store whatever you want in a solr index. And if you store an integer as a Solr 1.4 "int" type, you can certainly query for all documents that have greater than some specified integer in a field

Re: Delta Import with something other than Date

2010-09-08 Thread Jonathan Rochkind
Of course you can store whatever you want in a solr index. And if you store an integer as a Solr 1.4 "int" type, you can certainly query for all documents that have greater than some specified integer in a field. You can't use SQL to query Solr though. I'm not sure what you're really asking?

Delta Import with something other than Date

2010-09-08 Thread David Yang
Hi, I have a table that I want to index, and the table has no datetime stamp. However, the table is append only so the primary key can only go up. Is it possible to store the last primary key, and use some delta query="select id where id>${last_id_value}" Cheers, David