You are correct that Hive does not support "with recursive". A few more details of what you are trying to do would be helpful, since it's not clear why you need the iteration provided by "with recursive". If you really need the iteration I don't think Hive can do what you want.
Alan. On Tue, May 15, 2018 at 9:34 AM, Sowjanya Kakarala <sowja...@agrible.com> wrote: > 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] >
