Saving Dataframe into Hive table

Hi,

I want to export spark dataframe directly to hive table. I already created the corresponding hive table from hive shell. I tried to use saveAsTable() method of Dataframe, its not giving any error but also its not exporting data to the hive table. Need help in that. FYI: I am using Scala Api for that.

Please reach out to me on kapil.mnnit90@gmail.com.

Thanks,
Kapil Kumar
Cont: 9582546615

Kapil ,

Try to save your output file into /user/hive/warehouse location where your table is situated.

Regards ,
Amit

1 Like

Hi amit, can we explicitly change the location of the location of dataframe for saveAsTable() method? Can you please tell me how.

I am not sure about that. @itversity Please help on this !!