[HIVE-5972] Hiveserver2 is much slower than hiveserver1

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Duplicate
• Affects Version/s: 0.10.0
• Component/s: HiveServer2
• Assignee: Unassigned
• Reporter: a bc
• Created: 06/Dec/13 03:19
• Updated: 16/Dec/13 05:18
• Resolved: 16/Dec/13 05:17

Description

we are building ms sql cube by linkedserver connectiong hiveserver with Cloudera's ODBC driver.

There are two test results:
1. hiveserver1 running on 2CPUs, 8G mem, took about 8 hours
2. hiveserver2 running on 4CPUs, 16 mem, took about 13 hours and 27min (never successful on machine with 2CPUs, 8G mem)

Although on both cases, almost all CPUs are busy when building cube.

But I cannot understand why hiveserver2 is much slower than hiveserver1, because from doc, hs2 support concurrency, it should be faster than hs1, isn't it?

Thanks.

CDH4.3 on CentOS6.

Issue Links

• duplicates: HIVE-3746 Fix HS2 ResultSet Serialization Performance Regression
• is related to: HIVE-5276 Skip redundant string encoding/decoding for hiveserver2