comments inline
Amandeep Khurana Computer Science Graduate Student University of California, Santa Cruz On Tue, Sep 29, 2009 at 3:10 PM, Sujee Maniyam <[email protected]> wrote: > HI all, > I am in the process of migrating a relational table to Hbase. > > Current table: records user access logs > id : PK > userId > url > timestamp > refer_url > ip_address > cc : country code of ip address > > my potential queries would be > - grab all pages visited by a user > - generate a report of country : number of page views > > You can either create 2 tables. One can have the user as the key and the other can have the country as the key.. Or.. you can create a single table with user+country as the key. Third way is to have only one table with user as the key. For the country query you can scan across the table and do aggregations. The choice will depend on whether these are batch processed queries or real time.
