hive开窗日期类型导致无法排序

hive开窗日期类型导致无法排序

报错信息:

FAILED:SemanticException Failed to breakup Windowing invocations into Groupst least 1 group must only depend on input columns.Also check for circular dedencies.
Underlying error: Primitve type DATE not supported in Value Boundary expression
值边界表达式中不支持primitve类型DATE
类型DATE不支持,版本原因,换新版hive可能会解决,最好用转型
例子:order by buydate -->cast(buydate as string)

解决方式:

将date 类型转换成string，cast(buydate as string)