Hi Vida,

Sorry for the late reply.

I tried creating 2 similar temp tables in spark based on a Hive table, 1 had data other one is empty

when I try to insert into empty table I get the below error

org.apache.spark.sql.AnalysisException: Inserting into an RDD-based table is not allowed.;

Please correct me if there are any issues with this approach. I tried exactly same as you said except I created the temp tables out of a Hive table

Regards,

~Sri