Hi, I have organized some partitions to hold genomic features in my file system as follows:
organism/chromosome/feature_category Each feature_category partition has 3 columns (lets call them position, x, and y) I set it up this way because each query always had a fixed organism, chromosome, and feature_category. Now I want to ask more global queries like: select x, count(*) where y >= 10 AND organism="Bob" AND feature_category="exp1". Is it possible to use my existing layout to create a virtual table involving the partitions "Bob/*/exp1" ? An option is to move feature_category above chromosome, but there may be other queries involving multiple feature_categories but only one chromosome. Can you send some example code that shows how to load multiple partitions into a virtual table? Thanks, Andrew _______________________________________________ FastBit-users mailing list [email protected] https://hpcrdm.lbl.gov/cgi-bin/mailman/listinfo/fastbit-users
