You can only specify an explicit time, not "greater than a specific timestamp". The timestamp format is that of System.currentTimeMillis().
St.Ack

Bin YANG wrote:
for example, I want to find the values after a specifi time, how can I
write the HQL?

And I wonder to know how to use the TIMESTAMP in SELECT clause?

On Wed, Mar 19, 2008 at 10:15 PM, edward yoon <[EMAIL PROTECTED]> wrote:
HQL will be moved to hrdf project.
 Use the Hbase pure client  :

 obtainScanner(Text[] columns, Text startRow, long timestamp)



 On 3/19/08, Bin YANG <[EMAIL PROTECTED]> wrote:
 > Dear colleagues,
 >
 > I want to specify a time in SELECT function in HQL?
 >
 > I trys the following statements:
 >
 >  select * from table_web TIMESTAMP '2008/3/19' ;
 >
 >  select * from table_web TIMESTAMP '2008/3/19 15:10';
 >
 > It tells that the format of the TIMESTAMP is incorrect, could you
 > please tell me the right format of the TIMESTAMP?
 >
 > thanks a lot!
 >
 > bin yang
 >
 > --
 > Bin YANG
 > Department of Computer Science and Engineering
 > Fudan University
 > Shanghai, P. R. China
 > EMail: [EMAIL PROTECTED]
 >


 --
 B. Regards,
 Edward yoon @ NHN, corp.





Reply via email to