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 RE: pagination of results of grouping by more than one field
Date Mon, 01 May 2017 08:05:30 GMT
Hi,
Any clue?

Thanks


-----Original Message-----
From: Mikhail Ibraheem 
Sent: Sunday, April 30, 2017 10:09 AM
To: solr-user@lucene.apache.org
Subject: pagination of results of grouping by more than one field

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
View raw message