title: SPARK 1.6 Insert into existing Hive table (non-partitioned)
body: <p>Given that I can get these singleton insert statements below to work as from another stack overflow question (thanks), then   </p>
  
  <pre><code>  val sqlContext = new org.apache.spark.sql.hive.HiveContext(sc)
    sqlContext.sql("CREATE TABLE IF NOT EXISTS e360_models.employee(id INT, name STRING, age INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'")
  
     sqlContext.sql("insert into table e360_models.employee select t.* from (select 1210, 'rahul', 55) t")
     sqlContext.sql("insert into table e360_models.employee select t.* from (select 1211, 'sriram pv', 35) t")
     sqlContext.sql("insert into table e360_models.employee select t.* from (select 1212, 'gowri', 59) t")
  
     val result = sqlContext.sql("FROM e360_models.employee SELECT id, name, age")
     result.show()
  </code></pre>
  
  <p>what about if wanting to do an insert select from a SPARK DF registered as temporary table, to an already existing Hive table? I cannot seem to get it to work. Is it in fact possible? </p>
  
  <p>Using 1.6 SPARK. Not interested in creating a table a la CTAS, but rather inserting to as per the above, but in bulk, e.g.</p>
  
  <pre><code>sqlContext.sql("INSERT INTO TABLE default.ged_555 SELECT t.* FROM mytempTable t")
  </code></pre>