Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

NON-ANSI JOIN in hive

Solved Go to solution

NON-ANSI JOIN in hive

Master 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

Accepted Solutions
Highlighted

Re: NON-ANSI JOIN in hive

Master 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

1 REPLY 1
Highlighted

Re: NON-ANSI JOIN in hive

Master 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

Don't have an account?
Coming from Hortonworks? Activate your account here