Hive is supporting “Sub-Queries” functionality since version 0.13, as previously described in “Sub-Queries in Apache Hive.” We also discussed how the query syntax is similar
Tag: IN Operator in SubQuery in Hive
Sub-Queries in Apache Hive
A subquery is a SQL query that runs within another query. They are nested inquiries that offer data to the query that comes before it.
Big Data & SQL 