[FastBit-users] Running Join Queries in FastBit

2017-02-11 Thread Malmee Weerasinghe
Hi, I am doing a project of integrating FastBit to Apache Spark. I want to know whether the TPC-DS Query 96 which involves joins between 4 tables, can be run on FastBit all at once. I have seen the jRange class as well as jNatural class. AFAIU both these classes support only a join between two

[FastBit-users] Getting an incorrect count for a natural join query

2017-02-16 Thread Malmee Weerasinghe
Hi, I have run this query which involves a natural join between two partitions. But the result I am getting is not the result that is expected. Can you please explain what is wrong in the way I am executing this query. 1) ibis::part *tbl1 = new ibis::part part1("/fastbitdata/table1", 0, false);