topic Re: Unable to perform inner join in tMap while fetching data from tHiveInput component in Talend Studio

Unable to perform inner join in tMap while fetching data from tHiveInput component

Anonymous — Sun, 27 May 2018 06:25:36 GMT

I am trying to perform inner join in tMap component while fetching data from tHiveInput component. I am getting data from the main flow as well as the lookup flow but it is failing at join. The data coming from lookup is not more than 100 records. Even if I put a where clause in the tHiveInput query, the component starts giving a NullPointer exception, even if the data is present.

Attaching the job design and the tMap configuration.

Re: Unable to perform inner join in tMap while fetching data from tHiveInput component

TRF — Sun, 27 May 2018 18:19:37 GMT

At least you have to enter the keys which define global variables used by your lookup table as a filter.

That's probably why you get this error.

In my opinion you should also change the expression "eqq.dataset" by "row9.dataset".

Hope this helps.

Re: Unable to perform inner join in tMap while fetching data from tHiveInput component

Anonymous — Sun, 27 May 2018 19:15:26 GMT

Thanks for the response. But can you please elaborate on the first point you mentioned which says, "At least you have to enter the keys which define global variables used by your lookup table as a filter"

Re: Unable to perform inner join in tMap while fetching data from tHiveInput component

TRF — Sun, 27 May 2018 20:18:22 GMT

Sorry, I miss to give you this usefull linkhttps://www.talend.com/resources/talend-job-design-patterns-best-practices-part-4/
Search for "Reload at each Row" in the page and carefully read the section.
You may also read the whole page and also all the documentation.