Thanks for you input.
But, the jdbc client should be something like this,
{{{
$ *./bin/beeline*
Beeline version 1.5.2 by Apache Hive
beeline>*!connect jdbc:hive2://ip:1*
*show tables;*
++--+--+
| tableName | isTemporary |
++--+--+
| check
Hi
temp tables are session specific and private to the session. You will not
be able to see temp tables created by another session in HiveContext.
Likewise creating a table in Hive using a syntax similar to below
CREATE TEMPORARY TABLE tmp AS
SELECT t.calendar_month_desc, c.channel_desc,