Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

NON-ANSI JOIN in hive

avatar
Super Collaborator

i am reading in documentation that hive only supports ANSI-SQL joins , but i can do a NON-ANSI-SQL join fine

so does hive support both types of joins?

1 ACCEPTED SOLUTION

avatar
Super Collaborator

ok i found the answer on apache site , starting hive 0.13 both syntax are supported .

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins

View solution in original post

1 REPLY 1

avatar
Super Collaborator

ok i found the answer on apache site , starting hive 0.13 both syntax are supported .

https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Joins