how to read lookup activity output in HIVE activty

Question

Hi Experts,

I want to read lookup activity output in Hive activtiy. in my case i'm creating count using lookup activity.

i want o use that count in Hive activity in SELECT statement.

like below,

SELECT
'Test' AS C1,
'@{activity('IctHeaderToMemberCheck').output.count}' AS C2

it is giving error. please help.

Answer 1

Hello @Chilukurthi Harikrishna ,
Thanks for the ask and using the Microsoft Q&A platform .

Can you try something like this using the concat function as called out here . https://learn.microsoft.com/en-us/answers/questions/273806/use-of-variables-within-post-message-body-of-a-cop.html

Please do let me know how it goes .

Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members