Also, you can make a variety by small alteration on BigTable structure. If you have any questions, Shoot an email to me.
------------------------------ B. Regards, Edward yoon @ NHN, corp. Home : http://www.udanax.org > From: [EMAIL PROTECTED] > To: hadoop-user@lucene.apache.org > Subject: RE: how to insert and select timestamp in hbase > Date: Fri, 21 Dec 2007 20:30:23 +0000 > > > > I recommend define date column for specified record like this. > Then, you can use index in date columnfamily. > > date:yyyy-mm-dd hh:mm:ss.fffffffff > > Thanks, > Edward. > ------------------------------ > > B. Regards, > > Edward yoon @ NHN, corp. > Home : http://www.udanax.org > > >> Date: Fri, 21 Dec 2007 01:10:26 +0800 >> From: [EMAIL PROTECTED] >> Subject: how to insert and select timestamp in hbase >> To: hadoop-user@lucene.apache.org >> >> Hi all, >> >> I would like to know that has anyone tried to insert timestamp in the table >> created in hbase? I tried to insert timestamp with the command insert but >> every time I tried, it displayed error with timestamp. So I would like to >> know how to use it and thank you in advance. Also, after I inserted it into >> the table next time how can I use select command to select the table with >> the specified timestamp? >> >> The command format I have tried : >> INSERT INTO table_name (colmn_name, ...) >> VALUES ('value', ...) >> WHERE row = 'row-key' >> TIMESTAMP 'yyyy-mm-dd hh:mm:ss.fffffffff'; >> >> Thanks, >> Chenjia Wang >> >> >> --------------------------------- >> 雅虎邮箱传递新年祝福,个性贺卡送亲朋! > > _________________________________________________________________ > Don't get caught with egg on your face. Play Chicktionary! > http://club.live.com/chicktionary.aspx?icid=chick_wlhmtextlink1_dec _________________________________________________________________ Get the power of Windows + Web with the new Windows Live. http://www.windowslive.com?ocid=TXT_TAGHM_Wave2_powerofwindows_122007