You could also consider using the HBase table handler in Hive: http://wiki.apache.org/hadoop/Hive/HBaseIntegration.
On Fri, Aug 27, 2010 at 4:56 PM, Daniel Einspanjer <[email protected]>wrote: > 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 >
