Support Questions

Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

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

New Contributor

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

1 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 😉

View solution in original post

2 REPLIES 2

@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 😉

Mentor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.