Can you describe how did you cache the tables? In another HiveContext? AFAIK, 
cached table only be visible within the same HiveContext, you probably need to 
execute the sql query like
“cache table mytable as SELECT xxx” in the JDBC connection also.

Cheng Hao

From: Brandon White [mailto:bwwintheho...@gmail.com]
Sent: Wednesday, July 15, 2015 8:26 AM
To: user
Subject: How do you access a cached Spark SQL Table from a JBDC connection?

Hello there,

I have a JBDC connection setup to my Spark cluster but I cannot see the tables 
that I cache in memory. The only tables I can see are those that are in my Hive 
instance. I use a HiveContext to register a table and cache it in memory. How 
can I enable my JBDC connection to query this in memory table?

Brandon

Reply via email to