How to express update set statement in hive

Data updating is a common operation, and then the concept of data warehouse generally requires that the data is complete and stable. HIVE, as a data warehouse supported by HDFS in distributed environment, also requires data invariance.

Set according to the online method.

hive . support . concurrency–true

Hive.enforce.bucking–true (not required since Hive 2.0)

Hive.exec.dynamic.partition.mode–non-limiting.

hive . txn . manager–org . Apache . Hadoop . hive . QL . lock mgr . dbtxn manager

Hive.compressor.initiator.on–true (only applicable to one instance of Thrift metastore service)

Hive. compressor.worker.threads–positive

Also added:? Stored as orctbl properties ("transactional" = "true"); To support the requirements of ACID.

Write update operation command: update * * set name =' AAA' where ID =1;

Finally get the result.