Hi, Gaurav, Thanks for your interest in FastBit. We always welcome questions.
Regarding outer join, FastBit does not support it directly. One way to implement it would be to break up the join and issue a query on each distinct value in the left table. In your example, do the following - issue a query to get all distinct value of of a.first_col and a.second_col (subject to whatever other conditions desired) - for each combination of a.first_col and a.second_col, issue the query on table b. Hope this helps. John On 7/19/12 9:40 AM, Gaurav Agarwal wrote: > Hi John, > > Firstly, apologies for troubling you this frequently.. > I was curious how could I achieve LEFT OUTER JOIN using FastBit; for > instance if I have following two tables 'a' and 'b' and I do Join a > and b on first column (a.first_col=b.first_col) and then select > b.second_col, sum(a.second_col), I get USA-500, UK-100, NULL-500 as > result? > > Is it directly possible using existing fastbit? If not what would be > the best way to implement this? > > cheers, > gaurav > > --------- > a > --------- > 1,200 > 1,300 > 2,100 > 3,400 > 4,100 > --------- > > --------- > b > --------- > 1,USA > 2,UK > --------- > > > > > _______________________________________________ > 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
