Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Problem with rank() and dense_rank()


Copy link to this message
-
Re: Problem with rank() and dense_rank()
I'll do this in a bit.
There is also the issue of why Rank even accepts a param. It was never made
clear to me why this should be so.
On Fri, Aug 9, 2013 at 11:04 AM, Edward Capriolo <[EMAIL PROTECTED]>wrote:

> Please file a jira about rank being case sensitive.
>
>
> On Fri, Aug 9, 2013 at 10:26 AM, j.barrett Strausser <
> [EMAIL PROTECTED]> wrote:
>
>> rank is case-sensitive. Use the lower-case invocation.
>>
>> It is a rather odd error for the underlying cause and one I would have
>> never thought to check.
>>
>> I ran across the same issue you did. It was discussed in the email thread
>> I started  a few weeks ago titled "Semantics of Rank".
>> I'd advise you to go look in the archives for that thread.
>>
>>
>> -barrett
>>
>>
>> On Fri, Aug 9, 2013 at 9:39 AM, Lars Francke <[EMAIL PROTECTED]>wrote:
>>
>>> Hi again,
>>>
>>> CREATE TABLE test (a INT);
>>> EXPLAIN
>>> SELECT
>>>   DENSE_RANK() OVER (PARTITION BY a),
>>>   a
>>> FROM test;
>>>
>>> this minimal example fails with:
>>>
>>> FAILED: SemanticException Failed to breakup Windowing invocations into
>>> Groups. At least 1 group must only depend on input columns. Also check
>>> for circular dependencies.
>>> Underlying error:
>>> org.apache.hadoop.hive.ql.exec.UDFArgumentTypeException: One or more
>>> arguments are expected.
>>>
>>> Does anyone have an idea if we're using this wrong? It is correct that
>>> RANK() and DENSE_RANK() take a parameter (by looking at the code). I'm
>>> not entirely sure what it does but in any case it's undocumented and
>>> the tests seem to work without one too.
>>>
>>> Thank you for your help.
>>>
>>> Cheers,
>>> Lars
>>>
>>
>>
>>
>> --
>>
>>
>> https://github.com/bearrito
>> @deepbearrito
>>
>
>
--
https://github.com/bearrito
@deepbearrito