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 partitions. It would be great if you could suggest a way to run this query. *TPC-DS Query 96* select count(*) as c from store_sales ,household_demographics ,time_dim, store where store_sales.ss_sold_time_sk = time_dim.t_time_sk and store_sales.ss_hdemo_sk = household_demographics.hd_demo_sk and store_sales.ss_store_sk = store.s_store_sk and time_dim.t_hour = 8 and time_dim.t_minute >= 30 and household_demographics.hd_dep_count = 5 and store.s_store_name = 'ese' order by c limit 100; Thank you.
_______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
