Skip to content

Instantly share code, notes, and snippets.

@vithalsamp

vithalsamp/hive-correlated-subquery.sql

Created February 25, 2018 10:54
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save vithalsamp/71f582b82684faaf6705efb855e80ae4 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save vithalsamp/71f582b82684faaf6705efb855e80ae4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hive-correlated-subquery.sql
hive> select * from stud where exists (select 1 from dept where dept.stud_id = stud.id);
Query ID = admin_20180118191502_ecaf3e2b-67c4-4e7b-88ba-a068b1e80e47
Total jobs = 1
…
OK
1 100 ABC
2 200 BBB
3 200 CCC
4 300 DDD
5 100 EEE
Time taken: 4.424 seconds, Fetched: 5 row(s)
hive>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment