Re: Can't able to access temp table via jdbc client

2016-04-05 Thread ram kumar
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

Re: Can't able to access temp table via jdbc client

2016-04-05 Thread Mich Talebzadeh
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,