title: Can't access "spark registered table" from impala/hive/spark sql
body: <p>I create a datasource in spark using scala.  I have a case class and have created an RDD and registered it as a table.  Just like the example given in the spark documentation.</p>
  
  <pre><code>val sqlContext = new org.apache.spark.sql.SQLContext(sc)
  import sqlContext.createSchemaRDD
  case class Person(name: String, age: Int)
  val people = sc.textFile("examples/src/main/resources/people.txt").map(_.split(",")).map(p =&gt; Person(p(0), p(1).trim.toInt))
  people.registerAsTable("people")
  val teenagers = sqlContext.sql("SELECT name FROM people WHERE age &gt;= 13 AND age &lt;= 19")
  teenagers.map(t =&gt; "Name: " + t(0)).collect().foreach(println)
  </code></pre>
  
  <p>However I cannot access the table in hive, impala or spark-sql.  "Show tables" command does not show the tables. Any ideas on how to achieve this?</p>
  
  <p>Thank you!</p>