ql/src/test/queries/clientnegative/read_only_delete.q

set hive.vectorized.execution.enabled=false;

set hive.support.concurrency=true;
set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;

set hive.exec.pre.hooks = org.apache.hadoop.hive.ql.hooks.EnforceReadOnlyDatabaseHook;

CREATE DATABASE writable;
CREATE TABLE writable.src
    (cint INT)
    CLUSTERED BY (cint) INTO 1 BUCKETS STORED AS ORC
    TBLPROPERTIES ('transactional'='true');
ALTER DATABASE writable SET DBPROPERTIES('readonly' = 'false');
DELETE FROM writable.src WHERE cint < 0;

CREATE DATABASE readonly;
CREATE TABLE readonly.src
    (cint INT)
    CLUSTERED BY (cint) INTO 1 BUCKETS STORED AS ORC
    TBLPROPERTIES ('transactional'='true');
ALTER DATABASE readonly SET DBPROPERTIES('readonly' = 'true');
DELETE FROM readonly.src WHERE cint < 0;