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 >
