https://community.cloudera.com/t5/Support-Questions/org-apache-spark-sql-AnalysisException-Table-not-found/m-p/168214#M130544 <P>Dinesh, I recreated your scenario (in spark-shell) and its working fine for me. Are you running this in Zeppelin by chance? I've noticed sometimes in Zeppelin, it doesnt create the hive context correctly, so what you can do to make sure you're doing it correctly is run the following code.</P><PRE>val sqlContext = New HiveContext(sc) //your code here </PRE><P>What will happen is we'll create a new HiveContext, and it should fix your problem. I think we're losing the pointer to your sqlContext for some reason, so by recreating, we'll guarantee that the temptable is registered to a sqlContext, and the same sqlContext is going to be queried. Let me know if that fixes your problem, or if you have more issues.</P> Fri, 10 Feb 2017 08:39:08 GMT jwiden 2017-02-10T08:39:08Z