Can we see sparkSQL/DF temp tables in beeline?

[#1]

Folks,

I am registering temp table in Spark-shell : using

 people.registerTempTable("people"). 

( Kerberized cluster user xyz). on the shell I see

+---------+-----------+ 
|tableName|isTemporary|
+---------+-----------+
|   people|       true|

And now, I am trying to login with beeline with the same user (xyz) . But when I do show tables,

I do not see the people table when I issue, show tables on beeline:

Connected to: Spark SQL (version 1.6.0)

Driver: Hive JDBC (version 1.2.1000.2.4.0.0-169)

Transaction isolation: TRANSACTION_REPEATABLE_READ

Beeline version 1.2.1000.2.4.0.0-169 by Apache Hive

0: jdbc:hive2://STS_SERVER> show tables;

+------------+--------------+--+
| tableName  | isTemporary  | 
+------------+--------------+--+

@vshukla, @Timothy Spann, @Jitendra Yadav, @Yuta Imai@Simon Elliston Ball

[#2 · Accepted solution]

@Smart Solutions

Please refer latest answer from below post, that probably help you.

https://community.hortonworks.com/questions/32810/spark-temporary-table-is-not-shown-in-beeline.html

[#3]

@Jitendra Yadav

Thank you. Looks like it to be work around. However, I will comment there :).

Thank you very much.

[#4]

@Smart Solutions

Glad it worked as a workaround 🙂 please accept it as an answer it this answer help you a bit.

[#5]

Sure @Jitendra Yadav