question

ChilukurthiHarikrishna-4158 avatar image
0 Votes"
ChilukurthiHarikrishna-4158 asked ·

how to read lookup activity output in HIVE activty

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
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Himanshu,

That requirement is on hold for now. I didn't get a chance to work on it. but I will let you for sure if the solution you proposed is working or not.

thanks for you time.

Hari.

0 Votes 0 ·

1 Answer

HimanshuSinha-MSFT avatar image
0 Votes"
HimanshuSinha-MSFT answered ·

Hello @ChilukurthiHarikrishna-4158 ,
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://docs.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




· 1 · Share
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @ChilukurthiHarikrishna-4158 ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .
If you have any question relating to the current thread, please do let us know and we will try out best to help you .
Thanks
Himanshu

0 Votes 0 ·