Github user dongjoon-hyun commented on the issue:

    https://github.com/apache/spark/pull/14132
  
    The difference of JOIN[5] and JOIN[5] is just due to the following.
    * JOIN[5]
    ```
              TableScan
                alias: t1
                Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE 
Column stats: NONE
                Select Operator
                  expressions: a (type: int)
                  outputColumnNames: _col0
                  Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE 
Column stats: NONE
                  Reduce Output Operator
                    sort order: 
                    Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE 
Column stats: NONE
                    value expressions: _col0 (type: int)
    ```
    * JOIN[5]
    ```
              TableScan
                alias: t1
                Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE 
Column stats: NONE
                Reduce Output Operator
                  sort order: 
                  Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE 
Column stats: NONE
                  value expressions: a (type: int)
    ```
    For Query 3 and 4, `t1` -> `t2` and `a` -> `b`.


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to