[HIVE-9546] Create table taking substantially longer time when other select queries are run in parallel.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.13.1

Environment

RedHat Linux, Cloudera 5.3.0

• Assignee: Aihua Xu
• Reporter: sri venu bora
• Created: 02/Feb/15 17:28
• Updated: 18/Feb/15 18:13
• Resolved: 18/Feb/15 18:13

Description

Create table taking substantially longer time when other select queries are run in parallel.

We were able to reproduce the issue using beeline in two sessions.

Beeline Shell 1:
a) create table with no other queries running on hive ( took approximately 0.313 seconds)
b) Insert Data into the table
c) Run a select count query on the above table
Beeline Shell 2:
a) create table while step c) is running in the Beeline Shell 1. (took approximately 60.431 seconds)

Issue Links

• is duplicated by: HIVE-9199 Excessive exclusive lock used in some DDLs with DummyTxnManager