hive에서 RDB와 CRUD

CREATE TABLE TEST1

(

C1 INT,

C2 STRING,

C3 INT,

C4 STRING

)

CLUSTERED BY (C1) into 3 buckets

ROW FORMAT DELIMITED

FIELDS TERMINATED BY ','

STORED as orc tblproperties('transactional'='true');

-- 테이블에 입력

INSERT INTO TABLE TEST1 VALUES (1,'A',30,'X'),

  (1,'B',18,'Y')

-- 테이블 수정

update TEST1

   SET C1 = 11

 WHERE C1 = 1;

-- 테이블 삭제 

DELETE FROM TEST1

 where C1=1;