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.