Hi, Stan, Thanks for your interest in FastBit software.
The key word distinct is typically used together with count, therefore, FastBit only suport a function named countdistinct in the select clause. You can use countdistinct(variable-name) or countdistinct(math-expression(arguments)), however, countdistinct(*) always behave as count(*). This is a little usual short-cut because countdistinct(*) implies that the system have to access all columns to make sure a row is unique - which is time-consuming for a column-oriented database engine. Here is the doxygen documentation about the select clause http://lbl.gov/~kwu/fastbit/doc/html/classibis_1_1selectClause.html#details Hope this helps. John On Thu, Dec 27, 2012 at 12:41 PM, Stan Seltser <[email protected]> wrote: > > does anybody know if count distinct works in fastbit? also does anybody know > if monetdb integration code is available ? > > Sent from my Verizon Wireless 4G LTE Smartphone > > _______________________________________________ > FastBit-users mailing list > [email protected] > https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users > _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
