Skip to content

Instantly share code, notes, and snippets.

@vithalsamp
Created February 25, 2018 11:01
Show Gist options
  • Select an option

  • Save vithalsamp/277e71ec65ac712989c5eceb8880ddcf to your computer and use it in GitHub Desktop.

Select an option

Save vithalsamp/277e71ec65ac712989c5eceb8880ddcf to your computer and use it in GitHub Desktop.
hive> select * from stud where id in (select stud_id from dept);
Query ID = admin_20180118151357_c109594d-2079-441f-afc0-328525b9709c
Total jobs = 1
Launching Job 1 out of 1
…
OK
1 100 ABC
2 200 BBB
3 200 CCC
4 300 DDD
5 100 EEE
Time taken: 9.386 seconds, Fetched: 5 row(s)
hive>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment