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

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XMLWordPrintable

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

      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.

              fercoli Fabio Massimo Ercoli
              pzapataf@redhat.com Pedro Zapata Fernandez
              Archiver:
              rhn-support-adongare Amol Dongare

                Created:
                Updated:
                Resolved:
                Archived: