hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Problem with rank() and dense_rank()
Date Fri, 09 Aug 2013 15:04:10 GMT
Please file a jira about rank being case sensitive.


On Fri, Aug 9, 2013 at 10:26 AM, j.barrett Strausser <
j.barrett.strausser@gmail.com> 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 <lars.francke@gmail.com>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
>

Mime
View raw message