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
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions