IMPALA SQL_JOIN - loukenny/atme GitHub Wiki

JOIN

  1. INNER JOIN
    1. INNER JOIN
    2. SELF JOIN
  2. SELF JOIN
  3. OUTER JOIN
    1. LEFT [OUTER] JOIN
    2. RIGHT [OUTER] JOIN
    3. FULL [OUTER] JOIN
  4. CROSS JOIN
  5. SEMI JOIN/ANTI JOIN

β†’ SELF, SEMI, ANTI) built-in function μ—†κΈ° λ•Œλ¬Έμ— μ λ‹Ήνžˆ ν™œμš©ν•΄μ„œ λ§Œλ“€μ–΄μ•Ό 함