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 <edlinuxg...@gmail.com>wrote: > 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 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.fran...@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 >> > > -- https://github.com/bearrito @deepbearrito
