[jira] [Updated] (SOLR-5842) facet.pivot need provide the more information and additional function
[ https://issues.apache.org/jira/browse/SOLR-5842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raintung Li updated SOLR-5842: -- Attachment: patch-5842-2.txt Fix the bug facet.pivot need provide the more information and additional function - Key: SOLR-5842 URL: https://issues.apache.org/jira/browse/SOLR-5842 Project: Solr Issue Type: Improvement Components: SolrCloud Affects Versions: 4.6 Reporter: Raintung Li Attachments: patch-5842-2.txt, patch-5842.txt Because facet can set the facet.limit and facet.offset, we can't get the next array size for facet.pivot. If you want to get the next pivot size, you have to set the facet.limit to max integer then to count the array size. In that way you will get a lot of terms for pivot field that's impact the network and Client. Update some functions in the API For example: facet=truefacet.pivot=test,testb,id facet.pivot.min.field=id -- Get the id min value facet.pivot.max.field=id -- Get the id max value facet.pivot.sum.field=id-- Sum the id value facet.pivot.count=true --- Open the get array size function facet.pivot.count.field=id --Get the id array size facet.pivot.count.next=true -- Get the next pivot field array size Response: lst name=facet_pivot long name=idSUM572/long long name=idMAX333/long long name=idMIN1/long long name=idArrCount12/long arr name=test,testb,id lst str name=fieldtest/str str name=valuechange.me/str int name=count5/int long name=idSUM91/long long name=idMAX33/long long name=idMIN1/long long name=idArrCount5/long long name=testbArrCount2/long arr name=pivot lst str name=fieldtestb/str str name=valuetest/str int name=count1/int long name=idSUM3/long long name=idMAX3/long long name=idMIN3/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value3/int int name=count1/int /lst /arr /lst lst str name=fieldtestb/str null name=value/ int name=count4/int long name=idSUM88/long long name=idMAX33/long long name=idMIN1/long long name=idArrCount4/long arr name=pivot lst str name=fieldid/str int name=value1/int int name=count1/int /lst lst str name=fieldid/str int name=value22/int int name=count1/int /lst lst str name=fieldid/str int name=value32/int int name=count1/int /lst lst str name=fieldid/str int name=value33/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value100/str int name=count1/int long name=idSUM66/long long name=idMAX66/long long name=idMIN66/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM66/long long name=idMAX66/long long name=idMIN66/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value66/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value200/str int name=count1/int long name=idSUM34/long long name=idMAX34/long long name=idMIN34/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM34/long long name=idMAX34/long long name=idMIN34/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value34/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value500/str int name=count1/int long name=idSUM23/long long name=idMAX23/long long name=idMIN23/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM23/long long name=idMAX23/long long name=idMIN23/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value23/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=valuechange.me1/str int name=count1/int long name=idSUM4/long long name=idMAX4/long long name=idMIN4/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str str name=valuetest1/str int name=count1/int long name=idSUM4/long long name=idMAX4/long long name=idMIN4/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value4/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=valueme/str int name=count1/int long name=idSUM11/long long name=idMAX11/long long name=idMIN11/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str str name=valuechange.me/str int name=count1/int long name=idSUM11/long long name=idMAX11/long long
[jira] [Updated] (SOLR-5842) facet.pivot need provide the more information and additional function
[ https://issues.apache.org/jira/browse/SOLR-5842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raintung Li updated SOLR-5842: -- Description: Because facet can set the facet.limit and facet.offset, we can't get the next array size for facet.pivot. If you want to get the next pivot size, you have to set the facet.limit to max integer then to count the array size. In that way you will get a lot of terms for pivot field that's impact the network and Client. Update some functions in the API For example: facet=truefacet.pivot=test,testb,id facet.pivot.min.field=id -- Get the id min value facet.pivot.max.field=id -- Get the id max value facet.pivot.sum.field=id-- Sum the id value facet.pivot.count=true --- Open the get array size function facet.pivot.count.field=id --Get the id array size facet.pivot.count.next=true -- Get the next pivot field array size Response: lst name=facet_pivot long name=idSUM572/long long name=idMAX333/long long name=idMIN1/long long name=idArrCount12/long arr name=test,testb,id lst str name=fieldtest/str str name=valuechange.me/str int name=count5/int long name=idSUM91/long long name=idMAX33/long long name=idMIN1/long long name=idArrCount5/long long name=testbArrCount2/long arr name=pivot lst str name=fieldtestb/str str name=valuetest/str int name=count1/int long name=idSUM3/long long name=idMAX3/long long name=idMIN3/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value3/int int name=count1/int /lst /arr /lst lst str name=fieldtestb/str null name=value/ int name=count4/int long name=idSUM88/long long name=idMAX33/long long name=idMIN1/long long name=idArrCount4/long arr name=pivot lst str name=fieldid/str int name=value1/int int name=count1/int /lst lst str name=fieldid/str int name=value22/int int name=count1/int /lst lst str name=fieldid/str int name=value32/int int name=count1/int /lst lst str name=fieldid/str int name=value33/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value100/str int name=count1/int long name=idSUM66/long long name=idMAX66/long long name=idMIN66/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM66/long long name=idMAX66/long long name=idMIN66/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value66/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value200/str int name=count1/int long name=idSUM34/long long name=idMAX34/long long name=idMIN34/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM34/long long name=idMAX34/long long name=idMIN34/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value34/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value500/str int name=count1/int long name=idSUM23/long long name=idMAX23/long long name=idMIN23/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM23/long long name=idMAX23/long long name=idMIN23/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value23/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=valuechange.me1/str int name=count1/int long name=idSUM4/long long name=idMAX4/long long name=idMIN4/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str str name=valuetest1/str int name=count1/int long name=idSUM4/long long name=idMAX4/long long name=idMIN4/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value4/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=valueme/str int name=count1/int long name=idSUM11/long long name=idMAX11/long long name=idMIN11/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str str name=valuechange.me/str int name=count1/int long name=idSUM11/long long name=idMAX11/long long name=idMIN11/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value11/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=valueok/str int name=count1/int long name=idSUM333/long long name=idMAX333/long long name=idMIN333/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str str name=valueok/str int name=count1/int long name=idSUM333/long long name=idMAX333/long long name=idMIN333/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value333/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str null name=value/ int
[jira] [Updated] (SOLR-5842) facet.pivot need provide the more information and additional function
[ https://issues.apache.org/jira/browse/SOLR-5842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Raintung Li updated SOLR-5842: -- Attachment: patch-5842.txt update code for functions facet.pivot need provide the more information and additional function - Key: SOLR-5842 URL: https://issues.apache.org/jira/browse/SOLR-5842 Project: Solr Issue Type: Improvement Components: SolrCloud Affects Versions: 4.6 Reporter: Raintung Li Attachments: patch-5842.txt Because facet can set the facet.limit and facet.offset, we can't get the next array size for facet.pivot. If you want to get the next pivot size, you have to set the facet.limit to max integer then to count the array size. In that way you will get a lot of terms for pivot field that's impact the network and Client. Update some functions in the API For example: facet=truefacet.pivot=test,testb,id facet.pivot.min.field=id -- Get the id min value facet.pivot.max.field=id -- Get the id max value facet.pivot.sum.field=id-- Sum the id value facet.pivot.count=true --- Open the get array size function facet.pivot.count.field=id --Get the id array size facet.pivot.count.next=true -- Get the next pivot field array size Response: lst name=facet_pivot long name=idSUM572/long long name=idMAX333/long long name=idMIN1/long long name=idArrCount12/long arr name=test,testb,id lst str name=fieldtest/str str name=valuechange.me/str int name=count5/int long name=idSUM91/long long name=idMAX33/long long name=idMIN1/long long name=idArrCount5/long long name=testbArrCount2/long arr name=pivot lst str name=fieldtestb/str str name=valuetest/str int name=count1/int long name=idSUM3/long long name=idMAX3/long long name=idMIN3/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value3/int int name=count1/int /lst /arr /lst lst str name=fieldtestb/str null name=value/ int name=count4/int long name=idSUM88/long long name=idMAX33/long long name=idMIN1/long long name=idArrCount4/long arr name=pivot lst str name=fieldid/str int name=value1/int int name=count1/int /lst lst str name=fieldid/str int name=value22/int int name=count1/int /lst lst str name=fieldid/str int name=value32/int int name=count1/int /lst lst str name=fieldid/str int name=value33/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value100/str int name=count1/int long name=idSUM66/long long name=idMAX66/long long name=idMIN66/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM66/long long name=idMAX66/long long name=idMIN66/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value66/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value200/str int name=count1/int long name=idSUM34/long long name=idMAX34/long long name=idMIN34/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM34/long long name=idMAX34/long long name=idMIN34/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value34/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=value500/str int name=count1/int long name=idSUM23/long long name=idMAX23/long long name=idMIN23/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str null name=value/ int name=count1/int long name=idSUM23/long long name=idMAX23/long long name=idMIN23/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value23/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=valuechange.me1/str int name=count1/int long name=idSUM4/long long name=idMAX4/long long name=idMIN4/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str str name=valuetest1/str int name=count1/int long name=idSUM4/long long name=idMAX4/long long name=idMIN4/long long name=idArrCount1/long arr name=pivot lst str name=fieldid/str int name=value4/int int name=count1/int /lst /arr /lst /arr /lst lst str name=fieldtest/str str name=valueme/str int name=count1/int long name=idSUM11/long long name=idMAX11/long long name=idMIN11/long long name=idArrCount1/long long name=testbArrCount1/long arr name=pivot lst str name=fieldtestb/str str name=valuechange.me/str int name=count1/int long name=idSUM11/long long name=idMAX11/long long