You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "xiatch (Jira)" <ji...@apache.org> on 2022/05/23 09:50:00 UTC

[jira] [Created] (HIVE-26257) Mapjoin with LateralViewJoin generates wrong plan in Spark

xiatch created HIVE-26257:
-----------------------------

             Summary: Mapjoin with LateralViewJoin generates wrong plan in Spark
                 Key: HIVE-26257
                 URL: https://issues.apache.org/jira/browse/HIVE-26257
             Project: Hive
          Issue Type: Bug
            Reporter: xiatch
            Assignee: xiatch


Queries like these

SELECT

  *

FROM

  (

    SELECT

      C.lv_col,

      '1' AS match_col

    FROM

      (

        SELECT

          '1' AS a

      ) B LATERAL VIEW explode(split('abcd', ';')) C AS lv_col

  ) A

  LEFT JOIN

  (

    SELECT

      '1' AS match_col

    FROM

      (

        SELECT

          'a' AS b

      ) E

      LEFT JOIN (

        SELECT

          'a' AS c

      ) F ON E.b = F.c

  ) D ON A.match_col = D.match_col;

generates twice the number of rows in Spark when compared to MR.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)