Solr Spellcheck
Hi, I am having issues with spell check and suggestions. I am using one of the column data as source for the text suggestions and handler is setup as DirectSolrSpellChecker in solrconfig.xml. Also defined copyField for this data and using this as spell check source. I am on version 6.3.0 I want to show the row data if the search word is found and if it misspelled would like to get suggestions. Eg, If I am searching for all rows with word cholera, I am running following query to get suggestions by sending search word as colera. localhost://8983/solr/mycore/spell?spellcheck.q=colera&spellcheck=true I am getting some suggestions but I am always getting the results saying word is misspelled with both of following queries. localhost://8983/solr/mycore/spell?spellcheck.q=colera&spellcheck=true localhost://8983/solr/mycore/spell?spellcheck.q=cholera&spellcheck=true I am not getting any errors, not sure what I am missing. Regards Prasad
help get 'count of distinct' using solr via cql against datastax?
Hi all, I have a datastax (DSE) server with cassandra. I am running the node in "search" mode, which means solr is enabled and working. I want to use CQL to write a query against my core/table. If this were a traditional SQL, here is how I would write it: SELECT COUNT(DISTINCT my_field) FROM my_table WHERE my_field LIKE 'S%' Is there a way to accomplish a select count distinct? Thanks! (ps I have been trying to subscribe to this mailing list but it seems like nabble is not sending out an initial subscribe request. I have looked in my spam folder and have tried several different email domains) -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
Re: help get 'count of distinct' using solr via cql against datastax?
On 11/26/2017 7:45 AM, lamelylounges wrote: I have a datastax (DSE) server with cassandra. I am running the node in "search" mode, which means solr is enabled and working. I want to use CQL to write a query against my core/table. I'm fairly certain that CQL is not something created by the Solr project. You're going to need to talk to either the Cassandra project or DataStax for help with CQL. Most questions about DataStax are best handled by them, even if they concern Solr, because they do a lot of customization of Solr, and only they are going to know how they've got everything configured. If this were a traditional SQL, here is how I would write it: SELECT COUNT(DISTINCT my_field) FROM my_table WHERE my_field LIKE 'S%' Is there a way to accomplish a select count distinct? Solr's facet functionality might be a lot like a distinct count. The basic facet capability shows the number of documents in the index that match each of the possible terms in the index for a given field. Because you're running the highly customized Solr in DSE, you may get better (and faster) answers from DataStax. Solr includes something in recent versions where you can access it as if it were a database. I really don't know anything about it, but there are others on this list who do: https://lucene.apache.org/solr/guide/6_6/parallel-sql-interface.html (ps I have been trying to subscribe to this mailing list but it seems like nabble is not sending out an initial subscribe request. I have looked in my spam folder and have tried several different email domains) Nabble is not the mailing list. Their solr-user pages are a mirror of the mailing list in forum format. If you're having trouble with Nabble, you're going to need to talk to Nabble about it. I have never used Nabble. Here is where you can find info about the actual mailing list, which is maintained by the Apache Software Foundation: https://lucene.apache.org/solr/community.html#mailing-lists-irc Thanks, Shawn
Re: Solr7 org.apache.lucene.index.IndexUpgrader
Hi Shawn, Thanks for the help. I hate to burst your bubble here ... but 4 million docs is pretty small for > a Solr index. I have one index that's a hundred times larger, and there > are people with *billions* of documents in SolrCloud. > Sorry I missed a "0" there. It's actually 40 Millions, still according to you, it's still a small sized index. 😊😊 You would need to keep the schema the same for the upgrade, except that you > would need to disable docValues on some of your fields to get rid of the > error you encountered. You won't be able to take advantage of some of the > new capability in the new version unless you re-engineer your config/schema > and reindex. > Thanks.. Got your point. > > Upgrading an index, especially through three major versions, is generally > not recommended. I always reindex when upgrading Solr, especially to a new > major version, because Solr evolves quickly. > What method do you actually follow to re-index upon Solr major upgrade..? I think I should do re-index since I am upgrading 3 major versions at once. What is best method to re-index..? At present, I am planning to re-index by SELECT from previous version (4.10.2) and then UPDATE into latest version(7.1.0). Any other better thoughts to re-index..? Thanks in advance, Leo Prince.
