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.

Syntax:

DELETE * FROM TABLENAME
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?”