https://community.cloudera.com/t5/Archives-of-Support-Questions/NON-ANSI-JOIN-in-hive/m-p/217613#M84227 <P>ok i found the answer on apache site , starting hive 0.13 both syntax are supported .</P><P><A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins</A></P> Thu, 11 Oct 2018 08:38:56 GMT aliyesami 2018-10-11T08:38:56Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NON-ANSI-JOIN-in-hive/m-p/217612#M84226 <P>i am reading in documentation that hive only supports ANSI-SQL joins , but i can do a NON-ANSI-SQL join fine </P><P>so does hive support both types of joins? </P> Thu, 11 Oct 2018 04:58:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NON-ANSI-JOIN-in-hive/m-p/217612#M84226 aliyesami 2018-10-11T04:58:53Z https://community.cloudera.com/t5/Archives-of-Support-Questions/NON-ANSI-JOIN-in-hive/m-p/217613#M84227 <P>ok i found the answer on apache site , starting hive 0.13 both syntax are supported .</P><P><A href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins</A></P> Thu, 11 Oct 2018 08:38:56 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/NON-ANSI-JOIN-in-hive/m-p/217613#M84227 aliyesami 2018-10-11T08:38:56Z