Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-14293

Query with order run as hybrid query when there's an index for the entity and field

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not a Bug
    • Minor
    • None
    • None
    • Indexing
    • None

    Description

      When running a query with order by that should be fully indexed is emitting the following warning (but still works) :

      WARN  (blocking-thread--p3-t5) [org.infinispan.query.core.impl.BaseEmbeddedQuery] ISPN014827: Distributed sort not supported for non-indexed query 'FROM crawlix.CrawlingJob ORDER BY lastCrawlAttempt DESC'. Consider using an index for optimal performance.

       

      The protobuf schema is annotated for indexing as follows:

       

      /**
       * @Indexed
       */
      message CrawlingJob {
         
      ....
         
         /**
          * @Field(index = Index.YES, store = Store.NO)
          */
         optional string status = 2;

        ...

         /**
          * @Field(index = Index.YES, store = Store.NO)
          */
         optional fixed64 lastCrawlAttempt = 8;
        ...

       

      The cache is actually showing in the console as 'Indexed'.

      The query is reported as hybrid,  while other queries with the same cache, entity are reported as indexed (see screenshot)

      With other indexed fields of type String similar symptoms are shown.

      Attachments

        Activity

          People

            fercoli@redhat.com Fabio Massimo Ercoli
            pzapataf@redhat.com Pedro Zapata Fernandez
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: