Skip to content

OmniOperator: Spark window does not support lieteral expression #58

@XiaoqiMa

Description

@XiaoqiMa

子查询中含有常量表达式作为投影列,然后在外层作为窗口函数的分组列,转化为列引用失败出错了

SELECT
statis_cycle_sign, name, dept, salary, ROW_NUMBER() OVER (PARTITION BY statis_cycle_sign, name, dept ORDER BY salary) AS rank
FROM
( SELECT 'pt_today' AS statis_cycle_sign, name, dept, salary, age from employees) ;

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions