Cloudera Community

Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Solved Go to solution

NON-ANSI JOIN in hive

avatar
author-rank aliyesami
Super Collaborator

Created ‎10-10-2018 09:58 PM

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,346 Views
0 Kudos
1 ACCEPTED SOLUTION

avatar
author-rank aliyesami
Super Collaborator

Created ‎10-11-2018 01:38 AM

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,159 Views
0 Kudos
1 REPLY 1

avatar
author-rank aliyesami
Super Collaborator

Created ‎10-11-2018 01:38 AM

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,160 Views
0 Kudos
webinar banner
Announcements
Community Announcements
April 2024 Community Highlights
Community Announcements
January 2024 Community Highlights
Product Announcements
[ANNOUNCE] Cloudera on Public Cloud Runtime 7.2.18 is GA!
What's New @ Cloudera
Cloudera Operational Database (COD) supports enhancements to...
Community Announcements
March 2024 Community Highlights
View More Announcements
meetups banner