solr range query errors

Question

http://localhost:8983/solr/select?wt=json&q=lat:[35%20to%2038] results in

org.apache.lucene.queryParser.ParseException: Cannot parse 'lat:[35 to 38]': Encountered " <RANGEIN_GOOP> "38 "" at line 1, column 11.
Was expecting:
    "]"

This is a pretty basic range query and this error will prevent us from using SOLR for our projects

Pascal Dimassimo · Accepted Answer · 2010-04-24 02:26:21Z

22

Try 'TO' in upper-case.

answered Apr 24, 2010 at 2:26

Pascal Dimassimo

6,9281 gold badge40 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mquinsland Over a year ago

You're right. lowercase 'to' appears to work, but 'TO' works as it should.

Mauricio Scheffer Over a year ago

yup, it has to be upper-case

Sujeet Over a year ago

correct it has to uppercase and all fields of table are case sensitive. Also do not forget to keep expression inside quote ' '

mquinsland · Accepted Answer · 2010-04-24 05:08:23Z

0

Switched default to use dismax instead of lucene parser.

answered Apr 24, 2010 at 5:08

mquinsland

711 silver badge2 bronze badges

Comments

Manimaran Samuthirapandi · Accepted Answer · 2017-11-08 06:50:58Z

0

/_search?q=lat:[35 TO 38]
or
/_search?q=lat:[35%20TO%2038]

Working & Tested the same.

https://search-xxxx-scyleqdxxxxx57yi4m.us-east-2.es.amazonaws.com/id/_search?q=id:2017-10-28&size=100

https://search-xxxx-scyleqdxxxxx57yi4m.us-east-2.es.amazonaws.com/id/_search?q=v:[0%20TO%20100]&size=100

https://search-xxxx-scyleqdxxxxx57yi4m.us-east-2.es.amazonaws.com/id/_search?q=id:[2017-10-26%20TO%202017-10-27]&size=100

answered Nov 8, 2017 at 6:50

Manimaran Samuthirapandi

6097 silver badges7 bronze badges

Collectives™ on Stack Overflow

solr range query errors

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related