Xavier recently mentioned some code we use at Mozilla that should help here. It is a unioning scanner that would let you define a list of scan ranges to run for the job. You'd set a prefix for each Friday in the selected months and the range of 143000 through 143060 Then you'd apply a filter on the product. When it runs, it would generate all the scans you need and run them in a single job. If you want to give it a try, search the mailing list archive. I'll check with Xavier to see if the code can be cleaned up and posted somewhere too.
-Daniel Shuja Rehman <[email protected]> wrote: Hi I am trying to implement equivalent of this query in Hbase *SELECT *value1, value2, value3 , (value1+value2) as calculatedValue *FROM *myTable *WHERE *year=2010 and month in (2,4,6) and day= 'Friday' and time='14:30' and Product='Abc' The Hbase table has the row key with *YYYYMMDDHHMMSS *e.g *20100809023000 *and Product information is in *ProductInfo *column family. Can anybody help me how to proceed with this scenario? Thanks in advance -- Regards Shuja-ur-Rehman Baig http://pk.linkedin.com/in/shujamughal Cell: +92 3214207445
