Support Questions

Find answers, ask questions, and share your expertise

Can we see sparkSQL/DF temp tables in beeline?

avatar
Expert Contributor

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

1 ACCEPTED SOLUTION

avatar
Super Guru
4 REPLIES 4

avatar
Super Guru

avatar
Expert Contributor
@Jitendra Yadav

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

Thank you very much.

avatar
Super Guru

@Smart Solutions

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

avatar
Expert Contributor