Cloudera Community

Archives of Support Questions (Read Only)

This is an archived board for historical reference. Information and links may no longer be available or relevant
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
This board is archived and read-only for historical reference. To ask a new question, please post a new topic on the appropriate active board.
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?

2,349 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

2,162 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

2,163 Views
0 Kudos
Announcements
What's New @ Cloudera
Cloudera Real time Monitoring for 7.1.9+ and 7.2.18+ with Cl...
What's New @ Cloudera
Announcing Cloudera Streaming Analytics 1.17: Python UDFs, S...
Community Announcements
Content Update: Evolving Our Community Content for Better, A...
Community Announcements
Product Name Updates — Community Label Changes & Notificatio...
What's New @ Cloudera
Announcing Cloudera Data Lineage for Trino
View More Announcements