Storing the Hive Query Results into Variable

[mahender bigdata]

Hi,
Is there option available to store hive results into variable like
select @i= count(*) from HiveTable.

or

Storing Table Results into variable and make use of it later stage of 
Query. I tired using HQL CTE but the scope of CTE is limited to next 
select only, Is there a way to intermediate results like join data into 
variable and make use of it latter stage.

Thanks,
Mahender