Pain Sun created IMPALA-15588:
---------------------------------

             Summary: Calcite planner: IllegalStateException in 
ViewAliasCorrector when a view contains UNION
                 Key: IMPALA-15588
                 URL: https://issues.apache.org/jira/browse/IMPALA-15588
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 5.0.0
            Reporter: Pain Sun


SET
    PLANNER = CALCITE;
SET
    FALLBACK_PLANNER = NONE;
 
CREATE VIEW test111.v_union_top AS
SELECT
    1 AS c
UNION
ALL
SELECT
    2;


CREATE VIEW test111.v_union_sub AS
SELECT
    *
FROM
    (
        SELECT
            1 AS c
        UNION
        ALL
        SELECT
            2
    ) t;

SET
    PLANNER = CALCITE;

SET
    FALLBACK_PLANNER = NONE;

-- error:IllegalStateException
SELECT
    *
FROM
    test111.v_union_top;

-- error:IllegalStateException
SELECT
    *
FROM
    test111.v_union_sub;





-- success
SELECT
    *
FROM
    (
        SELECT
            1 AS c
        UNION
        ALL
        SELECT
            2
    ) t;



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to