question Can we delete data in a Hive table from spark-scala shell. in Archives of Support Questions (Read Only)

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

mohammed_sarfar — Fri, 16 Sep 2022 09:59:38 GMT

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

nsabharwal — Mon, 25 Jan 2016 21:05:56 GMT

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 😉

aervits — Wed, 03 Feb 2016 09:36:34 GMT

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