In general this is done using joins, as in all SQL engines. A google search on "intro to SQL joins" will suggest a number of resources, for example https://www.essentialsql.com/get-ready-to-learn-sql-12-introduction-to-database-joins/
Alan. On Tue, May 15, 2018 at 7:37 AM, Sowjanya Kakarala <[email protected]> wrote: > Hi all, > > Is there a way in hive that different tables data, can be read as in a > single query? > > example: > (something like) > select a,b from (select col1 from tbl1)a , (select col1 from tb2)b); > > output as : > a b > 0.1 0.2 > > Any help is appreciated. > > Thanks > Sowjanya >
