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
