Uploaded image for project: 'Geode'
  1. Geode
  2. GEODE-4155

Lucene search in gfsh fails for integer values

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • 1.3.0
    • gfsh, lucene
    • None

    Description

      Using the geode-example/lucene, follow the README file to build the example, start up the cluster, and load the Employee data.
      In gfsh, I can successfully use OQL to query for entries with salary=75000, but a Lucene query for the same salary returns no results:
      OQL Query:

      gfsh>query --query="select * from /example-region where salary=75000"
      Result : true
      Limit  : 100
      Rows   : 2
      
           contacts      |         email         | emplNumber | firstName | hoursPerWeek | lastName | salary | startDate
      ------------------ | --------------------- | ---------- | --------- | ------------ | -------- | ------ | -------------
      org.json.JSONArray | Kris.Call@example.com | 10003      | Kris      | 40           | Call     | 75000  | 1502397254080
      org.json.JSONArray | Pat.Puts@example.com  | 10028      | Pat       | 40           | Puts     | 75000  | 1502397254080
      

      Lucene Query:

      gfsh>search lucene --name=simpleIndex --region=example-region --queryStrings="salary:75000" --defaultField=salary
      No results
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            dhardman Diane Hardman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: