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, SUM(s.amount_sold) AS TotalSales will only be visible to that session and is created under /tmp/hive/hduser. HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* http://talebzadehmich.wordpress.com On 5 April 2016 at 05:52, ram kumar <ramkumarro...@gmail.com> wrote: > HI, > > I started a hive thrift server from hive home, > ./bin/hiveserver2 > > opened jdbc client, > ./bin/beeline > connected to thrift server, > > 0: > show tables; > +------------------------+--+ > | tab_name | > +------------------------+--+ > | check | > | people | > +------------------------+--+ > 4 rows selected (2.085 seconds) > 0:> > > I can't see the temp tables which i registered with HiveContext > from pyspark.sql import HiveContext, Row > schemaPeople.registerTempTable("testtemp") > Can some1 help me with it > > Thanks > >
