Share via

how to read lookup activity output in HIVE activty

Chilukurthi Harikrishna 41 Reputation points
2021-02-15T16:09:07.46+00:00

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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,639 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,491 Reputation points Microsoft Employee Moderator
    2021-02-16T20:43:43.717+00:00

    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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.