hi, We have a similar requirement in our organization.We are planning to use an ETL tool to synchronize our DB with Solr. Looks like this is a better approach. Is it production quality? When do you plan to commit this to Solr? Cheers Vijay
On Feb 18, 2008 11:20 PM, Noble Paul (JIRA) <[EMAIL PROTECTED]> wrote: > > [ > https://issues.apache.org/jira/browse/SOLR-469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12569979#action_12569979] > > Noble Paul commented on SOLR-469: > --------------------------------- > > Add a facility to delete documents from Solr index on the basis of a solr > query. > It is useful if you wish to expire the documents after a certain period of > time. > > > > DB Import RequestHandler > > ------------------------ > > > > Key: SOLR-469 > > URL: https://issues.apache.org/jira/browse/SOLR-469 > > Project: Solr > > Issue Type: New Feature > > Components: update > > Affects Versions: 1.3 > > Reporter: Noble Paul > > Priority: Minor > > Fix For: 1.3 > > > > Attachments: SOLR-469.patch, SOLR-469.patch, SOLR-469.patch > > > > > > We need a RequestHandler Which can import data from a DB or other > dataSources into the Solr index .Think of it as an advanced form of > SqlUpload Plugin (SOLR-103). > > The way it works is as follows. > > * Provide a configuration file (xml) to the Handler which takes in > the necessary SQL queries and mappings to a solr schema > > - It also takes in a properties file for the data source > configuraution > > * Given the configuration it can also generate the solr schema.xml > > * It is registered as a RequestHandler which can take two commands > do-full-import, do-delta-import > > - do-full-import - dumps all the data from the Database into > the index (based on the SQL query in configuration) > > - do-delta-import - dumps all the data that has changed since > last import. (We assume a modified-timestamp column in tables) > > * It provides a admin page > > - where we can schedule it to be run automatically at regular > intervals > > - It shows the status of the Handler (idle, full-import, > delta-import) > > -- > This message is automatically generated by JIRA. > - > You can reply to this email to add a comment to the issue online. > >
