THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
INSERT INTO TABLE pageviews PARTITION (datestamp) VALUES ('tjohnson', 'sports.com', 'finance.com', '2014-09-23'), ('tlee', 'finance.com', null, '2014-09-21');
Update
| Note | ||
|---|---|---|
| ||
UPDATE is available starting in Hive 0.14. Updates can only be performed on tables that support ACID. See Hive Transactions for details. |
...
- Vectorization will be turned off for update operations. This is automatic and requires no action on the part of the user. Non-update operations are not affected. Updated tables can still be queried using vectorization.
Delete
| Note | ||
|---|---|---|
| ||
DELETE is available starting in Hive 0.14. Deletes can only be performed on tables that support ACID. See Hive Transactions for details. |
| Code Block |
|---|
Standard Syntax:
DELETE FROM tablename [WHERE expression] |
Synopsis
- Only rows that match the WHERE clause will be deleted.
- In Hive 0.14, upon successful completion of this operation the changes will be auto-committed.
Notes
- Vectorization will be turned off for delete operations. This is automatic and requires no action on the part of the user. Non-delete operations are not affected. Tables with deleted data can still be queried using vectorization.
...