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
