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