mysql - Hive 查询中的错误

Question

此查询的语法有什么问题 -

INSERT overwrite TABLE access_performance_partition
SELECT request
    ,exec_time
    ,rank() OVER (
        PARTITION BY request ORDER BY cast(exec_time AS BIGINT) DESC
        ) AS AddedRank
    ,count(*) OVER (PARTITION BY request) AS RequestCount
FROM access_performance;

正在显示

-FAILED: Parse Error: line 4:39 mismatched input '(' expecting FROM near 'over' in from clause

Answer 1

您拥有哪个 Hive 版本？貌似从0.11开始就支持了，见https://issues.apache.org/jira/browse/HIVE-4048