When do you need to deploy? As I understand it, the spatial search in Solr is being rewritten and is slated for Solr 4.0, the release after next.
The existing spatial search has some serious problems and is deprecated. Right now, I think the only way to get spatial search in Solr is to deploy a nightly snapshot from the active development on trunk. If you are deploying a year from now, that might change. There is not any support for SQL-like statements or for joins. The best practice for Solr is to think of your data as a single table, essentially creating a view from your database. The rows become Solr documents, the columns become Solr fields. wunder On Sep 27, 2010, at 9:34 AM, Sharma, Raghvendra wrote: > I am sure these kind of questions keep coming to you guys, but I want to > raise the same question in a different context...my own business situation. > I am very very new to solr and though I have tried to read through the > documentation, I have nowhere near completing the whole read. > > The need is like this - > > We have a huge rdbms database/table. A single table perhaps houses 100+ > million rows. Though oracle is doing a fine job of handling the insertion and > updation of data, the querying is where our main concerns lie. Since we have > spatial data, the index building takes hours and hours for such tables. > > That's when we thought of moving away from standard rdbms and thought of > trying something different and fast. > My last week has been spent in a journey reading through bigtable to hadoop > to hbase, to hive and then finally landed on solr. As far as I am in my > tests, it looks pretty good, but I have a few unanswered questions still. > Trying this group for them :) (I am sure I can find some answers if I > read/google more on the topic, but now I m being lazy and feel asking the > people who are already using it/or perhaps developing it is a better bet). > > 1. Can I get my solr instance to load data (fresh data for indexing) from a > stream (imagine a mq kind of queue, or similar) ? > 2. Can I host my solr instance to use hbase as the database/file system (read > HDFS) ? > 3. are there somewhere any reports available (as in benchmarks ) for a solr > instance's performance ? > 4. are there any APIs available which might help me apply ANSI sql kind of > statements to my solr data ? > > It would be great if people could help share their experience in the area... > if it's too much trouble writing all of it, perhaps url would be easier... I > welcome all kinds of help here... any advice/suggestions are good ... > > Looking forward to your viewpoints.. > > --raghav.. > ****************************************************************************************** > > This message may contain confidential or proprietary information intended > only for the use of the > addressee(s) named above or may contain information that is legally > privileged. If you are > not the intended addressee, or the person responsible for delivering it to > the intended addressee, > you are hereby notified that reading, disseminating, distributing or copying > this message is strictly > prohibited. If you have received this message by mistake, please immediately > notify us by > replying to the message and delete the original message and any copies > immediately thereafter. > > Thank you. > ****************************************************************************************** > > CLLD >