Need Support - Apache Solr - 20180915

2018-09-15 Thread senthil
Dear Team, We are beginners to Apache Solr and its implementations. We need the following basic clarifications regarding Apache Solr usage and implementing with MS-SQL server database. 1. Our MS-SQL server database having the data table which contains 20 columns with billions of data. 2

Re: Need Support - Apache Solr - 20180915

2018-09-15 Thread Erick Erickson
2. It's almost always a mistake to think about it this way. You're not going to "implement Apache Solr in the particular above table to increase search capability", you're going to build a search application where the system of record is the database. So forget about the table! Just consider the da

Re: Need Support - Apache Solr - 20180915

2018-09-15 Thread Shawn Heisey
On 9/14/2018 9:51 PM, senthil wrote: We are beginners to Apache Solr and its implementations. We need the following basic clarifications regarding Apache Solr usage and implementing with MS-SQL server database. I don't know what you think of Erick's answers, but he's right on the money wi

Re: Need Support - Apache Solr - 20180915

2018-09-15 Thread Rajdeep Sahoo
You can go for solr cloud if you have billions of data and in future if you want to increase the volume. Solr is a file based database for retriving data and not for complex oprations like joining multiple tables.If your requirement is only storing and fast retrieving then solr is the best option i

Re: Solr File based spellchecker is not returning expected result

2018-09-15 Thread Rajdeep Sahoo
can anyone please help me regarding spell checking issue what I have mentioned? On Thu, Sep 13, 2018 at 12:31 AM Rajdeep Sahoo wrote: > Hi , > I am using solr 4.6 version. > My document is having a "iphone 7" but when I am searching with with > "iphone7" I am getting the result because here word

Re: Need Support - Apache Solr - 20180915

2018-09-15 Thread Walter Underwood
> On Sep 15, 2018, at 12:14 PM, Rajdeep Sahoo > wrote: > > Solr is a file based database for retriving data and not for complex > oprations like joining multiple tables. Solr is NOT a file-based database. Solr is a search engine. It is not any kind of database because it does not meet the ACI

Re: Merge update request with existing documents

2018-09-15 Thread Vincenzo D'Amore
any suggestions? On Wed, Sep 12, 2018 at 10:20 AM Vincenzo D'Amore wrote: > Hi all, > > I have to update a bunch of documents but in the update requests there are > only parts of the documents. > > Given that the atomic update is not a feasible option, because sometimes I > have to remove one or