Spark to Hive Table creation

Question

I am storing the data in hive table. The table is getting created but in the hive when we try to fetch the data, I am getting run time exception.

==================

val sqlContext = new org.apache.spark.sql.SQLContext(sc)
val data = sqlContext.read.format('csv').option('header', 'true').load('Satish/AppleStore.csv')
val mobil_dataframe = data.toDF()
val conv_data= sql('select a.*,a.size_bytes.toInt/(1024) Data_IN_MB ,a.size_bytes/(1024*1024) Data_IN_GB from mytab a')
conv_data.write.saveAsTable('satishm.AppleStore')

Answer 1

There's an easier way to achieve your requirement. First, create an empty table in hive and then execute the below command:

conv_data.write("overwrite").saveAsTable("satishm.AppleStore")