How to use Hive DELETE?

1 comment

Important Note that

  • if you use DELETE on Hive MANAGED Table you will loose the data that is stored inside hive meta store i.e user/hive/warehouse.
  • if you use DELETE on Hive EXTERNAL Table you will not loose the data that has been stored on your local file system of your computer.


WHERE Condition

first lets see create diffrent table called JavachainManagedTable.


Let us INSERT into above table with some values manually.

Let us see what is there inside:

Let us try to delete row which contain nooftutorial = 101

OOPS error,let us try to fix this.

If you want to fix this issue, kindly click on this link HIVE CRUD Operations where i have given a solution for this.



Leave a comment

Your email address will not be published. Required fields are marked *

One thought on “How to use Hive DELETE?”