| --! qt:dataset:srcpart |
| set hive.compute.query.using.stats=false; |
| set hive.support.concurrency=true; |
| create database lockneg1; |
| use lockneg1; |
| |
| create table tstsrcpart like default.srcpart; |
| |
| insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11') |
| select key, value from default.srcpart where ds='2008-04-08' and hr='11'; |
| |
| lock database lockneg1 shared; |
| show locks database lockneg1; |
| select count(1) from tstsrcpart where ds='2008-04-08' and hr='11'; |
| |
| unlock database lockneg1; |
| show locks database lockneg1; |
| lock database lockneg1 exclusive; |
| show locks database lockneg1; |
| select count(1) from tstsrcpart where ds='2008-04-08' and hr='11'; |