is it possible to write join query in Hive components

Darmesh — Fri, 15 Nov 2024 23:34:52 GMT

i wanted to join 2 or 3 tables from hive and pass the output values to target.

my requirement is to

select a.lifnr as Vendor_Num, b.stras as Street,b.regio as Region,

a.bukrs as TaxIDNum from sapc11.lfb1_current a inner join sapc11.lfa1_current b

on (a.lifnr=b.lifnr)

where a.bukrs

in (2400, 2500, 2600, 2001, 2015, 2100, 2102, 2104, 2107, 2210, 3001, 3002, 3007, 3020);

i have used this query in tHiveinput and tHiverow but not working.

if i use tlogrow as output. i should get vendor_num, street, region, taxidnum as output field

Re: is it possible to write join query in Hive components

Anonymous — Fri, 29 Oct 2021 03:17:16 GMT

Hello,

Is it perfectly working when we use query without having any condition in tHiveInput component?

Make sure that you have permission (Hadoop user) for conditional/join query.

Best regards

Sabrina