Creating temp tables in select statements

[Mainak Ghosh]

Hello,

We want to create temp tables at a select query level. For example:

with x as (1, 2, 3) select * from x;

Or

Select * from table where id in <list of integers>; Here list of integers is an 
input and can change. 

Currently Postgres VALUES syntax is not supported in Hive. Is there some easy 
workarounds which does not involved explicitly creating temporary tables and 
can be specified at the select query level?

Thanks and Regards,
Mainak