Regarding the issue posted with rank and dense_rank. The example posted was:
CREATE TABLE test (a INT);
EXPLAIN
SELECT
DENSE_RANK() OVER (PARTITION BY a),
a
FROM test;
Some comments on this:
1. The underlying issue is the bug that ranking functions had to be lowercase.
This was fixed in Ji
https://issues.apache.org/jira/browse/HIVE-5038
On Fri, Aug 9, 2013 at 11:44 AM, Lars Francke wrote:
> Thank you very much guys for the response.
>
> I saw your thread but I must have totally missed your resolution of
> the issue. Sorry for the "repost".
>
> I'd be happy to file an issue as well
Thank you very much guys for the response.
I saw your thread but I must have totally missed your resolution of
the issue. Sorry for the "repost".
I'd be happy to file an issue as well.
Cheers,
Lars
On Fri, Aug 9, 2013 at 4:26 PM, j.barrett Strausser
wrote:
> rank is case-sensitive. Use the low
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 wrote:
> Please file a jira about rank being case sensitive.
>
>
> On Fri, Aug 9, 2013 at 10:26 AM, j.barrett Str
Please file a jira about rank being case sensitive.
On Fri, Aug 9, 2013 at 10:26 AM, j.barrett Strausser <
j.barrett.straus...@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
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
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 dep
