Hi Dean, how is bat.getCount() different from aggr.count() ? ;-) Thanks! Stefan ----- On Sep 14, 2016, at 6:30 PM, Dean De Leo commits+dleo=cwi.nl@monetdb.org wrote:

Changeset: 9ac831deacb3 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9ac831deacb3 Modified Files: monetdb5/modules/kernel/bat5.c monetdb5/modules/kernel/bat5.h monetdb5/modules/kernel/bat5.mal Branch: graph1 Log Message:

Add the operator bat.getCount() to retrieve the cardinality of a bat

diffs (48 lines):

diff --git a/monetdb5/modules/kernel/bat5.c b/monetdb5/modules/kernel/bat5.c --- a/monetdb5/modules/kernel/bat5.c +++ b/monetdb5/modules/kernel/bat5.c @@ -496,6 +496,19 @@ BKCgetColumnType(str *res, const bat *bi }

str +BKCgetCount(lng *res, const bat *bid) +{ + *res = lng_nil; + if (BBPcheck(*bid, "bat.getCount")) { + BAT *b = BBPquickdesc(*bid, 0); + + if (b != NULL) + *res = (lng) BATcount(b); + } + return MAL_SUCCEED; +} + +str BKCgetRole(str *res, const bat *bid) { BAT *b; diff --git a/monetdb5/modules/kernel/bat5.h b/monetdb5/modules/kernel/bat5.h --- a/monetdb5/modules/kernel/bat5.h +++ b/monetdb5/modules/kernel/bat5.h @@ -29,6 +29,7 @@ mal_export str BKCbun_inplace_force(bat mal_export str BKCbat_inplace_force(bat *r, const bat *bid, const bat *rid, const bat *uid, const bit *force); mal_export str BKCgetCapacity(lng *res, const bat *bid); mal_export str BKCgetColumnType(str *res, const bat *bid); +mal_export str BKCgetCount(lng *res, const bat *bid); mal_export str BKCgetRole(str *res, const bat *bid); mal_export str BKCsetkey(bat *res, const bat *bid, const bit *param); mal_export str BKCisSorted(bit *res, const bat *bid); diff --git a/monetdb5/modules/kernel/bat5.mal b/monetdb5/modules/kernel/bat5.mal --- a/monetdb5/modules/kernel/bat5.mal +++ b/monetdb5/modules/kernel/bat5.mal @@ -77,6 +77,10 @@ command getCapacity(b:bat[:any_1]):lng address BKCgetCapacity comment "Returns the current allocation size (in max number of elements) of a BAT.";

+command getCount(b:bat[:any_1]):lng +address BKCgetCount +comment "Returns the current tuple count of a BAT."; + command getColumnType( b:bat[:any_1] ) :str address BKCgetColumnType comment "Returns the type of the tail column of a BAT, as an integer type number."; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |