Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Hive >> mail # user >> Problem with rank() and dense_rank()


Copy link to this message
-
Problem with rank() and dense_rank()
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
+
j.barrett Strausser 2013-08-09, 14:26
+
Edward Capriolo 2013-08-09, 15:04
+
j.barrett Strausser 2013-08-09, 15:07
+
Lars Francke 2013-08-09, 15:44
+
j.barrett Strausser 2013-08-09, 17:40
+
Harish Butani 2013-08-20, 02:27