How to insert value in empty data frame in spark
<p>I am developing a spark application using SPARK sql, one of my job is selecting value from two tables and insert it into an empty table which is my result. but for this i am experimenting with spark for creating a empty table ,i have created a empty data frame but cant  register it as table  here is my situation now the code</p>

<pre><code>from pyspark import SQLContext
from pyspark.sql.types import StructType,StructField,StringType,DateType,IntegerType
sqlc=SQLContext(sc)

schema= StructType([StructField("Name",StringType(),False),StructField("AGE",IntegerType(),False),StructField("DATE",DateType(),False)])

dataframe=sqlc.createDataFrame([],schema)
dataframe.show()
</code></pre>

<p>it is showing a dataframe  but  i am not sure whether it is register or not cause the there is no value </p>

<pre><code>dataframe.registerTempTable("Exp")
experiment=sqlc.sql("SELECT * FROM Exp")
experiment.show()
</code></pre>

<p>I think i am making mistake here , so for this issue  i want to insert some value  for testing but i am unable to do it. i am new in spark so not sure how could i solve this situation . i have gone through some forums i have seen some forum user mentioned about parallelize() method for creating table but i did not properly understand how it works.Is it mandatory to use hive context for operation purpose?  my requirements are doing this job without hive context . Please guide me </p>