title: Is LEFT JOIN same as LEFT OUTER JOIN in Hive like RDBMS server
body: <p>As per the reference provided here, there is no difference between LEFT JOIN and LEFT OUTER JOIN in RDBMS server, except the point that term 'OUTER' is mentioned explicitly as discussed in the below post:
  <a href="https://stackoverflow.com/questions/406294/left-join-vs-left-outer-join-in-sql-server">LEFT JOIN vs. LEFT OUTER JOIN in SQL Server</a></p>
  
  <p>Can someone confirm if any way Apache HIVE has changed the semantics of LEFT JOIN or LEFT OUTER JOIN compared to SQL support in RDBMS server?</p>