Error in Caching a Table in SparkSQL

Question

I am trying to cache a Table available in Hive(using spark-shell). Given below is my code

scala> val hiveContext = new org.apache.spark.sql.hive.HiveContext(sc)

scala> hiveContext.cacheTable("sparkdb.firsttable")

and I am getting the below Exception

org.apache.spark.sql.catalyst.analysis.NoSuchTableException
    at org.apache.spark.sql.hive.client.ClientInterface$$anonfun$getTable$1.apply(ClientInterface.scala:112)

The table firsttable is available in database sparkdb(in Hive). Looks like the issue seems to be in providing database name. How do I achieve this?

PS : HiveQL query like the one shown below does work without any issues

scala> hiveContext.sql("select * from sparkdb.firsttable")

Find below results from few other method calls

scala> hiveContext.tables("sparkdb")
res14: org.apache.spark.sql.DataFrame = [tableName: string, isTemporary: boolean]

scala> hiveContext.tables("sparkdb.firsttable")
res15: org.apache.spark.sql.DataFrame = [tableName: string, isTemporary: boolean]

Answer 1

Aha! I was right, this seems to be SPARK-8105. So, for now, your best bet is to do the select * and cache that.