Re: Solr 8.0 query length limit

2021-02-18 Thread Anuj Bhargava
Thanks Alex and Shawn. Regards, Anuj On Thu, 18 Feb 2021 at 18:57, Shawn Heisey wrote: > On 2/18/2021 3:38 AM, Anuj Bhargava wrote: > > Solr 8.0 query length limit > > > > We are having an issue where queries are too big, we get no result. And > if > > w

Solr 8.0 query length limit

2021-02-18 Thread Anuj Bhargava
Solr 8.0 query length limit We are having an issue where queries are too big, we get no result. And if we remove a few keywords we get the result. Error we get - error 414 (Request-URI Too Long) Have made the following changes in jetty.xml, still the same error ** ** ** ** **

Re: Solr 8.6.2 text_general

2020-09-25 Thread Anuj Bhargava
Schema > screen). I still think your multiValued definition changed somewhere. > > Regards, > Alex. > > On Fri, 25 Sep 2020 at 03:57, Anuj Bhargava wrote: > > > > Schema on both are the same > > > > stored="true"/> > > > &

Re: Solr 8.6.2 text_general

2020-09-25 Thread Anuj Bhargava
they mapped to. > > Your text/_text_ field is not actually returned to the browser, > because it is "stored=false", so it is most likely a catch-all > copyField destination. You may be searching against it, but you are > returning other (original) fields. > > Regards

Re: Solr 8.6.2 text_general

2020-09-24 Thread Anuj Bhargava
nd on its fieldType. > > Regards, >Alex > P.s. However if your field is supposed to be single-valued, maybe you > should treat it as a feature not a bug. Multivalued fields have some > restrictions that single-valued fields do not have (around sorting for > example). > >

Solr 8.6.2 text_general

2020-09-24 Thread Anuj Bhargava
In solr 8.0.0 when running the query the data (type="text_general") was shown in brackets *[ ]* "country":*[*"IN"*]*, "currency":*[*"INR"*]*, "date_c":"2020-08-23T18:30:00Z", "est_cost":0, However, in solr 8.6.2 the query the data (type="text_general") is not showing in brackets [ ]

Solr 8.6.2 - Solr loaded a deprecated plugin/analysis

2020-09-22 Thread Anuj Bhargava
How to solve this issue? How to replace it? SolrResourceLoader Solr loaded a deprecated plugin/analysis class [solr.DataImportHandler]. Please consult documentation how to replace it accordingly.

Fetching and Adding Issue Solr 8.6.2

2020-09-18 Thread Anuj Bhargava
When importing data from *Solr Admin UI* When *Start, Row* not defined, it fetched but did not Add - Last Update: 17:11:54 Requests: 1 , Fetched: 1,750,700 , Skipped: 0 , Processed: 1,750,700 However, When *Start, Row* are defined, it *Fetches* and also *Adds* - Last Update: 17:19:04 Indexing

Re: Fetched but not Added Solr 8.6.2

2020-09-18 Thread Anuj Bhargava
:20, Shawn Heisey wrote: > On 9/18/2020 1:27 AM, Anuj Bhargava wrote: > > In managed schema, I have > stored="true" required="false" multiValued="false" /> > > > > Still getting the following error- > > > > org.apache.solr.common

Re: Fetched but not Added Solr 8.6.2

2020-09-18 Thread Anuj Bhargava
020 um 10:54 schrieb Anuj Bhargava : > > > > We just installed Solr 8.6.2 > > It is fetching the data but not adding > > > > Indexing completed. *Added/Updated: 0 *documents. Deleted 0 documents. > > (Duration: 06s) > > Requests: 1 ,* Fetched: 100* 17/s,

Unable to create core Solr 8.6.2

2020-09-17 Thread Anuj Bhargava
Getting the following error message while trying to create core # sudo su - solr -c "/opt/solr/bin/solr create_core -c 9lives" WARNING: Using _default configset with data driven schema functionality. NOT RECOMMENDED for production use. To turn off: bin/solr config -c 9lives -p 8984

Re: Fetched but not Added Solr 8.6.2

2020-09-17 Thread Anuj Bhargava
SolrWriter Error creating document : On Thu, 17 Sep 2020 at 15:53, Jörn Franke wrote: > Log file will tell you the issue. > > > Am 17.09.2020 um 10:54 schrieb Anuj Bhargava : > > > > We just installed Solr 8.6.2 > > It is fetching the data but not adding >

Fetched but not Added Solr 8.6.2

2020-09-17 Thread Anuj Bhargava
We just installed Solr 8.6.2 It is fetching the data but not adding Indexing completed. *Added/Updated: 0 *documents. Deleted 0 documents. (Duration: 06s) Requests: 1 ,* Fetched: 100* 17/s, Skipped: 0 , Processed: 0 The *data-config.xml*

Solr 8.0 Error - For input string

2020-01-26 Thread Anuj Bhargava
All of a sudden getting the following error. Need help to understand rectify the same - 1/27/2020, 9:36:58 AM ERROR true x:livedata RequestHandlerBase org.apache.solr.common.SolrException: For input string: "1*1*1*0" org.apache.solr.common.SolrException: For input string: "1*1*1*0" at

Starting Solr automatically

2019-12-16 Thread Anuj Bhargava
Often solr stops working. We have to then go to the root directory and give the command *'service solr start*' Is there a way to automatically start solr when it stops. Regards, Anuj >

Re: Indexing with customized parameters

2019-12-12 Thread Anuj Bhargava
Solr & Elasticsearch Consulting Support Training - http://sematext.com/ > > > > > On 12 Dec 2019, at 08:38, Anuj Bhargava wrote: > > > > Any suggestions? > > > > Regards, > > > > Anuj > > > > On Tue, 10 Dec 2019 at 20:52, Anuj

Re: Indexing with customized parameters

2019-12-11 Thread Anuj Bhargava
Any suggestions? Regards, Anuj On Tue, 10 Dec 2019 at 20:52, Anuj Bhargava wrote: > I am trying to index where the *sector field* has the values 27 and/or > 2701 and/or 2702 using the following - > >query="SELECT * FROM country WHERE sector = 27 OR sector = 2701 O

Indexing with customized parameters

2019-12-10 Thread Anuj Bhargava
I am trying to index where the *sector field* has the values 27 and/or 2701 and/or 2702 using the following - The sector field has comma separated multiple values like - 27,19,527 38,27,62701 2701,49 55,2702,327 The issue is when I run the above, it indexes the fields containing data

Re: Solr 8 - Sort Issue

2019-12-09 Thread Anuj Bhargava
Thanks Paras, that was very helpful. Restarted solr and for posting_id it showed pint earlier it was showing string. However, I change pint to plong because it was taking an awful lot of time to index. Thanks again, Regards, ANuj On Mon, 9 Dec 2019 at 11:32, Paras Lehana wrote: > Hi Anuj, >

Re: Solr 8 - Sort Issue

2019-12-08 Thread Anuj Bhargava
Hi Paras, Regards, Anuj On Mon, 9 Dec 2019 at 10:37, Paras Lehana wrote: > Hi Anuj, > > Please post the part of your schema for this field and its fieldType. > > On Sat, 7 Dec 2019 at 10:38, Anuj Bhargava wrote: > > > Tried with plong, pi

Re: Solr 8 - Sort Issue

2019-12-06 Thread Anuj Bhargava
Tried with plong, pint and string. Reindexed after each change. The sort results on numeric values being shown are the same - Ascending 1 10 100 2 2100 3 Descending 999 99 9 88 88 On Fri, 6 Dec 2019 at 17:15, Anuj Bhargava wrote: > Numeric sorting. Did the re-index

Re: Solr 8 - Sort Issue

2019-12-06 Thread Anuj Bhargava
gt; > It should have worked. please make sure data is reindexed after fieldType > changes > > Regards, > Munendra S N > > > > On Fri, Dec 6, 2019 at 4:10 PM Anuj Bhargava wrote: > > > I tried with pint also, but the result was the same. What should I use > for >

Re: Solr 8 - Sort Issue

2019-12-06 Thread Anuj Bhargava
> Munendra S N > > > > On Fri, Dec 6, 2019 at 3:12 PM Anuj Bhargava wrote: > > > When I sort desc on posting_id sort=posting_id%20desc, I get the > following > > result > > "posting_id":"313" > > "posting_id":"312

Solr 8 - Sort Issue

2019-12-05 Thread Anuj Bhargava
When I sort desc on posting_id sort=posting_id%20desc, I get the following result "posting_id":"313" "posting_id":"312" "posting_id":"310" When I sort asc on posting_id sort=posting_id%20asc, I get the following result "posting_id":"10005343" "posting_id":"10005349"

Re: Solr 8.0.0 Customized Indexing

2019-06-25 Thread Anuj Bhargava
your SQL (located in data-config.xml) to extract just what you > need > > (add a WHERE clause) > > > > -- > > Jan Høydahl, search solution architect > > Cominvent AS - www.cominvent.com > > > > > 25. jun. 2019 kl. 07:23 skrev Anuj Bhargava : > >

Solr 8.0.0 Customized Indexing

2019-06-24 Thread Anuj Bhargava
Customized Indexing date specific We have a huge database of more than 10 years. How can I index just some of the records - say for last 30 days. One of the fields in the database is *date_upload* which contains the date when the record was uploaded. Currently using Cron to index - curl -q

Solr8.0.0 Time Zone Issue

2019-04-18 Thread Anuj Bhargava
In mySql, date field *date_upload* shows entry as 2019-04-17 However, afer Solr Indexing *date_upload* is being shown as 2019-04-16T18:30:00Z I did change in solr.in.sh, SOLR_TIMEZONE="UTC" to SOLR_TIMEZONE="IST" and did a full-import again. The entry in *date_upload* is still being shown as

Re: Solr8.0.0 date search issue

2019-04-17 Thread Anuj Bhargava
Added the following in the Schema file - And modified to Still the following not working NOW NOW-7DAYS NOW-30DAYS The following has started working fq=date_upload:[2018-12-01 TO 2019-04-17] On Thu, 18 Apr 2019 at 08:15, Anuj Bhargava wrote: > I have an issue while searching on the D

Solr8.0.0 date search issue

2019-04-17 Thread Anuj Bhargava
I have an issue while searching on the Date field date_upload My Schema file has the following entry for DATE Field ** My data-config.xml has the following entry - ** *The following do not work -* fq=date_upload:NOW (does not work)

Re: Solr 8.0.0 Delta import add/delete data

2019-04-14 Thread Anuj Bhargava
how long does it take to index all the entries? > > Regards, > Edwin > > On Fri, 12 Apr 2019 at 12:32, Anuj Bhargava wrote: > > > We have a MySql database (news) which has the following fields - > > posting_id, date, name, currency, country, expiry etc > >

Re: Solr query particular value of a field last

2019-04-14 Thread Anuj Bhargava
g > > > spcific countries below other. > > > > > > fq=country :c1 OR c2 OR c3=if(termfreq (country,c2),1,0) desc > > > > > > > > > Here we are putting c2 below c1 and c3. > > > > > > You can also try term search a

Solr query particular value of a field last

2019-04-14 Thread Anuj Bhargava
I have a field *country*. I need to do a search in which I need to show the search result of a country or some countries, last in the search result for eg. country code *BD*. What query should I use to get the above result. fq=country:???=*%3A*

Solr 8.0.0 Delta import add/delete data

2019-04-11 Thread Anuj Bhargava
We have a MySql database (news) which has the following fields - posting_id, date, name, currency, country, expiry etc The database has more than 120 entries. Daily around 20 plus new records are added and around the same number deleted. posting_id is a unique ID for every record.

Solr 8.0.0 Indexing but not Adding

2019-04-06 Thread Anuj Bhargava
While doing full import, getting the following error - Indexing but not Adding/Upldating { "responseHeader":{ "status":0, "QTime":2}, "initArgs":[ "defaults",[ "config","db-data-config.xml"]], "command":"full-import", "status":"idle", "importResponse":"",