Can we delete data in a Hive table from spark-scala shell.

[#1]

Hi,

In Hive DB I got a table named "employee" with employee id as one field,

can I set HiveContext and delete data from Hive table() like below (if not what is the best way to do)

val sqlContext = new HiveContext(sc)

sqlContext.sql("DELETE FROM employee WHERE employee_id=6")

Thanks

[#2 · Accepted solution]

@mohammed sarfaraz

I don't think delete can be done and not supported.

You can create a new table without employee_id=6

Please read this

Hive is not RDBMS 😉

[#3]

@mohammed sarfaraz are you still having issues with this? Can you accept best answer or provide your workaround?