Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-5972

Hiveserver2 is much slower than hiveserver1

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 0.10.0
    • Fix Version/s: None
    • Component/s: HiveServer2
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                qwert a bc
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: