I want to get distinct fields in an index for given filter, for eg
for the below data
|Name|age |Country|Amount|
|Alfreds|34|Germeny|100|
|Andrew|43|U.K|333|
|Raj|54|India|4553|
|John|43|U.K|325|
|Ana|32|Mexico|56|
|Christina |22|Sweden|345|
I want to have a distinct country name when say, the amount is greater than 300.
what is the best possible way to achieve the same?
What if the field for which I want distinct values is multivalued, In an another use case I want to have distinct elements from a multivalued fields for given filters, the output should contains only distinct elements across the records.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.