This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 8%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECH%3C/text%3E%3C/svg%3E)
Hi,
i'm very new to ADF. i want to read hive activity output to set variable. with in hive activity i have a query to select count(*) from a table. i want to read this count and assign it to a variable. when i use set variable activity i'm only getting option to use "@activity('Hive1').output" , but this is not reading the count what i required. please help
So it's returning other details like uri, status etc.. so seems not possible. Looks like hive activity is simply running the select query.
Probably try to use Lookup activity instead of Hive. Not so sure if that will work, not an expert in Hive.
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Thank you Vaibhav for your kind response.
I tried with lookup which is retuning count. I'm able to use that one and it is working fine. once again thank you very much for your timely response.
Glad that it worked. Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Check the output run details of hive activity, it should show something like below
@activity('Hive1').output is not enough..
you will have to use @activity('Hive1').output.count (or whatever work available in output)
Refer this blog to see how activity output can be used in further activities
https://www.mssqltips.com/sqlservertip/6320/logging-azure-data-factory-pipeline-audit-data/
----------
Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav
Hi Vaibhav, Thanks for replying so quickly,
I have tried with what you have suggested. but it is still giving me some error.
error says,
The expression 'activity('Hive1').output.count' cannot be evaluated because property 'count' doesn't exist,
kindly help.
Check the output of hive activity from debugged output and see if it is showing the count in output. You have to use that exact word that is shown in output activity
Sharing one more screenshot for reference. You have to click on symbol to open the output of hive activity run.
This is the Hive output I have got, I don't see any count over there