Question

Which of the following is used to set transaction isolation level?

(a) –incremental=[true/false]

(b) –isolation=LEVEL

(c) –force=[true/false]

(d) –truncateTable=[true/false]

This question was posed to me in an online interview.

Asked question is from HiveQL in chapter Hive and HBase of Hadoop

Answer 1

Correct option is (b) –isolation=LEVEL

To explain I would say: Set the transaction isolation level to TRANSACTION_READ_COMMITTED or TRANSACTION_SERIALIZABLE.