is it possible to write join query in Hive components

[Darmesh]

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

[Anonymous]

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