Hi John, Did I bother you? I have not receive your reply for a long time.
I found BLOB support in following email list. Does BLOB support bitwise operator which I can simulate IN() function, or will you realize it? Because my use case is in an important service, I need make everything under control. So I want to known the memory usage of fastbit. Detail list following: 1. Does fastbit read all rows which satisfied the condition? 2. Do only columns in select clause will hold in memory? 3. Does only a single part in memory at a certain time? If parts are processed one by one. How you deal with order by? 4. For String column, is only position hold in memory? If so, is string column query speed rely on the IO workload of File read. Best Regards, Davey -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Tuesday, July 17, 2012 3:01 AM To: [email protected] Subject: FastBit-users Digest, Vol 59, Issue 13 Send FastBit-users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of FastBit-users digest..." Today's Topics: 1. Inserting binary (ibis::BLOB) data using tablex::appendRow(const ibis::table::row&) (Gerrit Hendrikus van Doorn) 2. Re: Inserting binary (ibis::BLOB) data using tablex::appendRow(const ibis::table::row&) (K. John Wu) ---------------------------------------------------------------------- Message: 1 Date: Sun, 15 Jul 2012 15:52:42 -0700 From: Gerrit Hendrikus van Doorn <[email protected]> Subject: [FastBit-users] Inserting binary (ibis::BLOB) data using tablex::appendRow(const ibis::table::row&) To: [email protected] Message-ID: <CAL_hiPpjhEHjhkS21fUWv5eqk-=qvpwcjp64jybvunbn48i...@mail.gmail.com> Content-Type: text/plain; charset="utf-8" Hi, I've been using tablex::appendRow(const ibis::table::row&) to insert data to a table. I wanted to add some binary data using the ibis::BLOB type. When I tried this I got a segmentation fault. Is the BLOB type supported by fastbit? I did a quick scan through tafel.cpp and the appendRow method doesn't seem to be doing anything with the ibis::BLOB type. Is there any other way to insert binary data? Thanks, Gerrit -------------- next part -------------- An HTML attachment was scrubbed... URL: http://hpcrdm.lbl.gov/pipermail/fastbit-users/attachments/20120715/927b0f80/attachment-0001.htm ------------------------------ Message: 2 Date: Mon, 16 Jul 2012 07:43:00 -0700 From: "K. John Wu" <[email protected]> Subject: Re: [FastBit-users] Inserting binary (ibis::BLOB) data using tablex::appendRow(const ibis::table::row&) To: FastBit Users <[email protected]> Cc: Gerrit Hendrikus van Doorn <[email protected]> Message-ID: <[email protected]> Content-Type: text/plain; charset=ISO-8859-1 Dear Gerrit, We have been working on straightening out the code in dealing with BLOBs. Unfortunately, it might still going to take a couple of weeks. John On 7/15/12 3:52 PM, Gerrit Hendrikus van Doorn wrote: > Hi, > > I've been using tablex::appendRow(const ibis::table::row&) to insert > data to a table. > I wanted to add some binary data using the ibis::BLOB type. When I > tried this I got a segmentation fault. Is the BLOB type supported by > fastbit? I did a quick scan through tafel.cpp and the appendRow method > doesn't seem to be doing anything with the ibis::BLOB type. Is there > any other way to insert binary data? > > Thanks, > Gerrit > > > _______________________________________________ > 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 End of FastBit-users Digest, Vol 59, Issue 13 ********************************************* _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
