hbase-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "edward yoon" <edw...@udanax.org>
Subject Re: How to specify a timestamp in HQL ?
Date Thu, 20 Mar 2008 03:30:39 GMT
lad, please don't define it yourself.

On 3/20/08, Bryan Duxbury <bryan@rapleaf.com> wrote:
> HQL is meant only for simple administrative use cases, so there
> aren't features for doing complex queries.
>
> -Bryan
>
> On Mar 19, 2008, at 7:24 PM, Bin YANG wrote:
>
> > It means that HQL can only support point query, but cannot support
> > range query, right?
> >
> > On Thu, Mar 20, 2008 at 1:08 AM, stack <stack@duboce.net> wrote:
> >> 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 <edward@udanax.org>
> >>> 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 <yangbinisme82@gmail.com> 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: yangbinisme82@gmail.com
> >>>>>
> >>>>
> >>>>
> >>>>  --
> >>>>  B. Regards,
> >>>>  Edward yoon @ NHN, corp.
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >
> >
> >
> > --
> > Bin YANG
> > Department of Computer Science and Engineering
> > Fudan University
> > Shanghai, P. R. China
> > EMail: yangbinisme82@gmail.com
>
>


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

Mime
View raw message