question Re: Can we see sparkSQL/DF temp tables in beeline? in Archives of Support Questions (Read Only)

Can we see sparkSQL/DF temp tables in beeline?

smartninja723 — Thu, 19 May 2016 20:10:03 GMT

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  | 
+------------+--------------+--+

jyadav — Thu, 19 May 2016 20:22:52 GMT

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

smartninja723 — Thu, 19 May 2016 20:40:43 GMT

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

Thank you very much.

jyadav — Thu, 19 May 2016 20:51:17 GMT

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

smartninja723 — Thu, 19 May 2016 22:38:35 GMT