ok. but in my usecase join's/union's wont help. Here is an example of my usecase from postgres, which I have to do it in similar way for hive. with recursive a as (select col from tb1), b as (select col from tb2), c as (select col from tb3)
select a,b,c from a,b,c; which output's me in a dataframe which i am writing to a csv and it looks like a b c 0.1 0.2 0.3 where hive is not supporting `with rec` in same functionality as in postgres and views are also not helping here. On Tue, May 15, 2018 at 11:19 AM, Alan Gates <alanfga...@gmail.com> wrote: > 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 <sowja...@agrible.com> > 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 >> > > -- Sowjanya Kakarala Infrastructure Software Engineer Agrible, Inc. | sowja...@agrible.com | 217-848-1128 2021 S. First Street, Suite 201, Champaign, IL 61820 <https://maps.google.com/?q=2021+S.+First+Street,+Suite+201,+Champaign,+IL+61820&entry=gmail&source=g> Agrible.com <http://agrible.com/> | facebook <https://www.facebook.com/Agrible> | youtube <https://www.youtube.com/c/AgribleInc_TheInsightToDecide> | twitter <https://twitter.com/Agribleinc> [image: Agrible_Logo_Email_Signature.jpg]