In the meantime, i did a very simple modification to be able to do what i wanted from the C api (see attached)
Thanks, From: [email protected] [mailto:[email protected]] On Behalf Of Dominique Prunier Sent: Thursday, January 12, 2012 3:04 PM To: FastBit Users Subject: [FastBit-users] Recommanded way to do SELECT DISTINCT <string_col> programatically Hi, I’m trying to reproduce a SELECT DISTINCT from a previous SQL system migrated to FastBit and so far, i ended up with the following snippet of code: ibis::part part("<part>", static_cast<const char*>(0)); ibis::query query; query.setPartition(&part); query.setWhereClause(static_cast<const char*>(0)); query.setSelectClause("p_devtype"); query.evaluate(); std::auto_ptr<ibis::bundle> bdl(ibis::bundle::create(query)); for (int ri = 0; ri < bdl->size(); ri++) { std::cout << bdl->getString(ri, 0) << "\n"; } My questions are: · Is it the recommended way of doing it ? Is there any other ways ? Is this something i can do trhough the C api ? · The getString(ri, 0) decorates strings with a leading and trailing quotes, is there another method to get the undecorated string ? Thanks, Dominique Prunier APG Lead Developper [cid:[email protected]] 4388, rue Saint-Denis Bureau 309 Montreal (Quebec) H2J 2L1 Tel. +1 514-842-6767 x310 Fax +1 514-842-3989 [email protected]<mailto:[email protected]> www.watch4net.com<http://www.watch4net.com/> This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of this electronic mail by you is prohibited. Ce message est pour le récipiendaire désigné seulement et peut contenir des informations privilégiées, propriétaires ou autrement privées. Si vous l'avez reçu par erreur, S.V.P. avisez l'expéditeur immédiatement et effacez l'original. Toute autre utilisation de ce courrier électronique par vous est prohibée.
<<inline: image001.gif>>
next_bundle.patch
Description: next_bundle.patch
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
