Skip to content

Instantly share code, notes, and snippets.

@vithalsamp

vithalsamp/hive-correlated-subquery1.sql

Created February 25, 2018 10:56
Show Gist options

  • Select an option

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

Select an option

Learn more about clone URLs
Save vithalsamp/fbbf1576b29ae48d76de97a1fd8e80c4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
hive-correlated-subquery1.sql
hive> SELECT stud.name,dept.dep_name
> FROM stud
> LEFT JOIN dept
> on (stud.id = dept.stud_id)
> ;
Query ID = admin_20180118195811_e94be9f5-176d-4e8b-8743-64d2bd12c826
Total jobs = 1
Launching Job 1 out of 1
…
OK
ABC Chem
BBB CS
CCC Phy
DDD Phy
EEE Chem
Time taken: 8.396 seconds, Fetched: 5 row(s)
hive>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment