Re: from_unix time problem

gt; On Tue, Sep 17, 2013 at 9:47 AM, Stephen Sprague wrote: > >> what happens if you use HH (instead of hh)? Any diff? >> >> >> On Tue, Sep 17, 2013 at 8:49 AM, Robert Li wrote: >> >>> Hi All >>> >>> I have a query where I want to convert the

from_unix time problem

" and "13:00" then "13:00" * *.* *.* But the problem is it seems like it's converting both 01:00 and 13:00 into the same bucket in the result. How can I tell from_unixtime to convert the times into a 24 format and not 12 hour format? timebucket date 01:00 2013-09-17 13:00:

Re: Question about weekofyear(string date)

; On Thu, Jun 13, 2013 at 2:44 PM, Robert Li wrote: > >> Hi All >> >> For this UDF, does it consider the week to be from Monday to Monday or >> first hour of Sunday to the last minute of Saturday for example? >> >> Robert >> >> -- >> * >

Question about weekofyear(string date)

Hi All For this UDF, does it consider the week to be from Monday to Monday or first hour of Sunday to the last minute of Saturday for example? Robert -- * Robert Li | Integration and Support Engineer | Kontagent Kontagent is Hiring! <http://www.kontagent.com/why/careers/> | Check us

collect_set question

it's reached a certain number of elements? -- * Robert Li | Integration and Support Engineer | Kontagent Kontagent is Hiring! <http://www.kontagent.com/why/careers/> | Check us out in the press! <http://www.kontagent.com/why/news/>* *Check out our blog: kScope <http://kaleid

Using TABLESAMPLE on inner queries

Hi Everyone I'm trying to use the TABLESAMPLE function to sample data, however it's a little more complicated and I am having trouble getting it to run. I know that this works fine and it will give me about 25% of the whole dataset select distinct s from testtable TABLESAMPLE(BUCKET 1 OUT OF 4 O