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()
Edward Capriolo 2013-08-09, 15:04
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
>