Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-52990

[FTS] Differing ES and FTS results for geospatial queries

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Critical
    • None
    • 7.1.2
    • fts
    • None
    • Untriaged
    • 1
    • No

    Description

      This ticket is a log of geospatial queries that return differing results with ES and FTS during functional testing. 

      The dataset for this testing is attached as `geoshape2.json`. The plots contain the query shape and the differing hits plotted as a GeoJSON file for convenient visualisation using geojson.io 

      1. A multipolygon 'intersects' query results in FTS returning 1 hit and ES returning none. 

      The executor logs showing the test failure are available on this link

      The query is in `query.json` and the plot is in `map(1).geojson`. 

       

      2. A polygon 'within' query results in FTS returning a point, but ES returns no hits.

      The executor logs showing the test failure are available here: http://qa.sc.couchbase.com/job/test_suite_executor/491922/console.

      The query is in `query2.json`. The plot is in in `map(2).geojson`. 

       

      3. A polygon 'intersects' query results in FTS returning an additional hit compared to the ES hits.

      The query is in `query3.json`. The plot is in `map(3).geojson`.

       

      4. A polygon 'within' query returning an additional hit in FTS compared to the ES hits.

      The query is in `query4.json`. The plot is in `map(4).geojson`.

       

      5. A polygon 'intersects' query returns 2 additional ES hits compared to FTS.

      The query is in `query5.json`. The plot is in `map(5).geojson`. 

       

      6. A polygon 'within' query returns an additional ES hit compared to the FTS hits.

      The query is in `query6.json`. The plot is in `map(6).geojson`. 

       

       

       

       

       

       

       

      Attachments

        1. geoshape2.json
          11 kB
          Aditi Ahuja
        2. map (1).geojson
          3 kB
          Aditi Ahuja
        3. map (2).geojson
          0.7 kB
          Aditi Ahuja
        4. map (3).geojson
          0.5 kB
          Aditi Ahuja
        5. map (4).geojson
          0.4 kB
          Aditi Ahuja
        6. map (5).geojson
          0.5 kB
          Aditi Ahuja
        7. map (6).geojson
          0.6 kB
          Aditi Ahuja
        8. query.json
          9 kB
          Aditi Ahuja
        9. query2.json
          2 kB
          Aditi Ahuja
        10. query3.json
          1 kB
          Aditi Ahuja
        11. query4.json
          1.0 kB
          Aditi Ahuja
        12. query5.json
          1.0 kB
          Aditi Ahuja
        13. query6.json
          1 kB
          Aditi Ahuja
        14. run-1-plot-geodesic.png
          174 kB
          Sreekanth Sivasankaran
        15. run-3-plot-geodesic.png
          182 kB
          Sreekanth Sivasankaran
        16. run-4-plot-geodesic.png
          211 kB
          Sreekanth Sivasankaran
        17. run-5-plot-geodesic.png
          268 kB
          Sreekanth Sivasankaran
        18. run-6-plot.png
          668 kB
          Sreekanth Sivasankaran
        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        Activity

          People

            Sreekanth Sivasankaran Sreekanth Sivasankaran (Inactive)
            aditi.ahuja Aditi Ahuja
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty