Created 05-19-2016 01:10 PM
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
Created 05-19-2016 01:22 PM
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
Created 05-19-2016 01:22 PM
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
Created 05-19-2016 01:40 PM
Thank you. Looks like it to be work around. However, I will comment there :).
Thank you very much.
Created 05-19-2016 01:51 PM
Glad it worked as a workaround 🙂 please accept it as an answer it this answer help you a bit.
Created 05-19-2016 03:38 PM
Sure @Jitendra Yadav