select DENSE_RANK() OVER(PARTITION BY mcc ORDER BY app_id) AS flag
from dm.test_table
where 1=1;
HIVE的报错信息如下:
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.