def test_number_avg_with_predicate(self):
average = self.map.aggregate(number_avg(),
greater_or_equal("this", 47))
self.assertEqual(48, average)
def test_number_avg_with_attribute_path(self):
average = self.map.aggregate(number_avg("this"))
self.assertEqual(24.5, average)
def test_number_avg(self):
average = self.map.aggregate(number_avg())
self.assertEqual(24.5, average)
predicate.sql(_sql_string),
predicate.equal(_sql_string, REFERENCE_OBJECTS["Integer"]),
predicate.not_equal(_sql_string, REFERENCE_OBJECTS["Integer"]),
predicate.greater(_sql_string, REFERENCE_OBJECTS["Integer"]),
predicate.greater_or_equal(_sql_string, REFERENCE_OBJECTS["Integer"]),
),
"InstanceOfPredicate": predicate.instance_of(
"com.hazelcast.nio.serialization.compatibility.CustomStreamSerializable"
),
"DistinctValuesAggregator": aggregator.distinct(_sql_string),
"MaxAggregator": aggregator.max_(_sql_string),
"MaxByAggregator": aggregator.max_by(_sql_string),
"MinAggregator": aggregator.min_(_sql_string),
"MinByAggregator": aggregator.min_by(_sql_string),
"CountAggregator": aggregator.count(_sql_string),
"NumberAverageAggregator": aggregator.number_avg(_sql_string),
"IntegerAverageAggregator": aggregator.int_avg(_sql_string),
"LongAverageAggregator": aggregator.long_avg(_sql_string),
"DoubleAverageAggregator": aggregator.double_avg(_sql_string),
"IntegerSumAggregator": aggregator.int_sum(_sql_string),
"LongSumAggregator": aggregator.long_sum(_sql_string),
"DoubleSumAggregator": aggregator.double_sum(_sql_string),
"FixedSumAggregator": aggregator.fixed_point_sum(_sql_string),
"FloatingPointSumAggregator": aggregator.floating_point_sum(_sql_string),
"SingleAttributeProjection": projection.single_attribute(_sql_string),
"MultiAttributeProjection": projection.multi_attribute(
_sql_string, _sql_string, _sql_string
),
"IdentityProjection": projection.identity(),
}
)
import hazelcast
from hazelcast.aggregator import count, number_avg, max_by
from hazelcast.predicate import less_or_equal
client = hazelcast.HazelcastClient()
people = client.get_map("people").blocking()
people.put_all({
"Philip": 46,
"Elizabeth": 44,
"Henry": 13,
"Paige": 15,
})
people_count = people.aggregate(count())
print("There are %d people." % people_count)
children_count = people.aggregate(count(), less_or_equal("this", 18))
print("There are %d children." % children_count)
average_age = people.aggregate(number_avg())
print("Average age is %f." % average_age)
eldest_person = people.aggregate(max_by("this"))
print("Eldest person is %s, with the age of %d." %
(eldest_person.key, eldest_person.value))
client.shutdown()
"com.hazelcast.nio.serialization.compatibility.CustomStreamSerializable" ), "DistinctValuesAggregator": aggregator.distinct(_sql_string), "MaxAggregator": aggregator.max_(_sql_string), "MaxByAggregator": aggregator.max_by(_sql_string), "MinAggregator": aggregator.min_(_sql_string), "MinByAggregator": aggregator.min_by(_sql_string), "CountAggregator": aggregator.count(_sql_string), "NumberAverageAggregator": aggregator.number_avg(_sql_string), "IntegerAverageAggregator": aggregator.int_avg(_sql_string), "LongAverageAggregator": aggregator.long_avg(_sql_string), "DoubleAverageAggregator": aggregator.double_avg(_sql_string), "IntegerSumAggregator": aggregator.int_sum(_sql_string), "LongSumAggregator": aggregator.long_sum(_sql_string), "DoubleSumAggregator": aggregator.double_sum(_sql_string), "FixedSumAggregator": aggregator.fixed_point_sum(_sql_string), "FloatingPointSumAggregator":