Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

how to import mysql tables to SOLR

i can never understand how solr works.

it just talks about schema files all the way but how do i import content from the database to it with a painless method?

i have tried to figure it out by reading their tutorials but it just mess up my head.

its written for the Einsteins out there cause apparently there are a lot of people who also have difficulty of understanding it.

and they keep talking about the example folder. "just type java -jar ./start.jar". i mean..is this an example or can you use it as final for your website? where is data-config.xml located??? there are just no good tutorials out there explaining to that first time beginners can understand.

like image 655
ajsie Avatar asked Dec 13 '09 08:12

ajsie


People also ask

What is full-import and Delta-import in SOLR?

In other words, a full-import will execute exactly 1 query for each defined entity + N queries for each sub-entity, while a delta-import will execute 1 query to get given entity's changed elements list + N queries for each changed element + another N queries for each defined sub-entity.

Can SOLR be used as a database?

Solr, however, is more than a search engine — it's also often used as a document-based NoSQL database with transactional support that can be used for storage purposes and even a key-value store.

What is Delta-import in SOLR?

delta-import. For incremental imports and change detection. Only the SqlEntityProcessor supports delta imports. For example: http://localhost:8983/solr/dih/dataimport?command=delta-import . This command supports the same clean , commit , optimize and debug parameters as full-import command described below.


1 Answers

The easiest way to import data from a RDBMS is the DataImportHandler. Check out this step-by-step quick start.

Also, here's a pretty thorough walk-through of its usage.

like image 199
Mauricio Scheffer Avatar answered Sep 28 '22 22:09

Mauricio Scheffer