lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mikhail Ibraheem <mikhail.ibrah...@oracle.com>
Subject pagination of results of grouping by more than one field
Date Sun, 30 Apr 2017 08:09:09 GMT
Hi,

I have a problem that I need to group by X and Y and aggregator on Z and I need to paginate
on the results. 

The results aren't flat they are in hierarchy so how to flat the results  so we can paginate
on them for each combination of X,Y like:

Computers, Computer Laptops, 5.684790733920929E10

Computers, PE_Server, 1.1207993365851181E10

Computers, Monitors, 1.2723246848002455E9

Data Communications Hardware, Datacom Hardware, 6.3539691650598495E10

 

>From the sample of the results:

 

"X":{

      "buckets":[{

          "val":"Computers",

          "count":981466,

          "Y":{

            "buckets":[{

                "val":"Computer Laptops",

                "count":391064,

                "sum":5.684790733920929E10},

              {

                "val":"PE_Server",

                "count":218148,

                "sum":1.1207993365851181E10},

              {

                "val":"Monitors",

                "count":122176,

                "sum":1.2723246848002455E9}]}},

        {

          "val":"Data Communications Hardware",

          "count":428230,

          "Y":{

            "buckets":[{

                "val":"Datacom Hardware",

                "count":428230,

                "sum":6.3539691650598495E10}]}},

        {

          "val":"Leasehold Improvements",

          "count":33677,

          "Y":{

            "buckets":[{

                "val":"Leasehold improvements",

                "count":33676,

                "sum":1.6308392462957385E12},

              {

                "val":"Electrical & Air Conditioning",

                "count":1,

                "sum":4505.0}]}},

        {

 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message