Some known limitations of hive SQL language

1.You cannot update data after it is inserted
2.There is no "insert into table values ... " statement
3.You can only load data using bulk load
4.There is no "delete from " command
5.You can only do bulk delete