Return-Path: X-Original-To: apmail-hive-user-archive@www.apache.org Delivered-To: apmail-hive-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 9452B1108D for ; Fri, 15 Aug 2014 15:55:16 +0000 (UTC) Received: (qmail 40408 invoked by uid 500); 15 Aug 2014 15:55:08 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 40333 invoked by uid 500); 15 Aug 2014 15:55:08 -0000 Mailing-List: contact user-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@hive.apache.org Delivered-To: mailing list user@hive.apache.org Received: (qmail 40323 invoked by uid 99); 15 Aug 2014 15:55:08 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Aug 2014 15:55:08 +0000 X-ASF-Spam-Status: No, hits=2.2 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_HELO_PASS,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of Bradley.Wright@progress.com designates 216.82.251.3 as permitted sender) Received: from [216.82.251.3] (HELO mail1.bemta12.messagelabs.com) (216.82.251.3) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Aug 2014 15:54:42 +0000 Received: from [216.82.250.51:65218] by server-3.bemta-12.messagelabs.com id 3B/D0-31391-04D2EE35; Fri, 15 Aug 2014 15:54:40 +0000 X-Env-Sender: Bradley.Wright@progress.com X-Msg-Ref: server-10.tower-108.messagelabs.com!1408118079!9670937!1 X-Originating-IP: [131.239.30.141] X-StarScan-Received: X-StarScan-Version: 6.11.3; banners=-,-,- X-VirusChecked: Checked Received: (qmail 8191 invoked from network); 15 Aug 2014 15:54:40 -0000 Received: from lxmasmtp01.progress.com (HELO lxmasmtp01.progress.com) (131.239.30.141) by server-10.tower-108.messagelabs.com with DHE-RSA-AES256-SHA encrypted SMTP; 15 Aug 2014 15:54:40 -0000 Received: from progress.progress.com (progress [172.16.3.168]) by lxmasmtp01.progress.com (8.14.4/8.14.4) with ESMTP id s7FFsBgW029359 for ; Fri, 15 Aug 2014 11:54:11 -0400 Received: from ntmaexcas03.bedford.progress.com (ntmaexcas03.bedford.progress.com [10.128.13.18]) by progress.progress.com (8.14.4+Sun/8.14.4) with ESMTP id s7FFscKI002221 for ; Fri, 15 Aug 2014 11:54:39 -0400 (EDT) Received: from pscmail02.bedford.progress.com ([fe80::85ea:de09:e6b0:361c]) by ntmaexcas03.bedford.progress.com ([10.128.13.44]) with mapi; Fri, 15 Aug 2014 11:54:38 -0400 From: Bradley Wright To: "user@hive.apache.org" Date: Fri, 15 Aug 2014 11:54:41 -0400 Subject: Re: ODBC Calls Extremely Slow Thread-Topic: ODBC Calls Extremely Slow Thread-Index: Ac+4oTfBPzdNC3S6SNSx7w/MY7TzHg== Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.4.3.140616 acceptlanguage: en-US x-ems-proccessed: +CmIlJ+kdV7Z341JADFd9w== x-ems-stamp: HEzxgAPMy/FxpLqXOnEZOg== Content-Type: multipart/alternative; boundary="_000_D01396B35DBBAbradleywrightprogresscom_" MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org --_000_D01396B35DBBAbradleywrightprogresscom_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Try an eval of our commercial ODBC driver for Hive: http://www.progress.com/products/datadirect-connect/odbc-drivers/data-sourc= es/hadoop-apache-hive It will perform better! From: Charles Yorek > Reply-To: "user@hive.apache.org" > Date: Friday, August 15, 2014 9:54 AM To: "user@hive.apache.org" > Subject: ODBC Calls Extremely Slow Hello All, I am trying to use the ODBC driver but making ODBC Calls to fetch a list of= tables from Hive is extremely slow on a HiveServer2. The cluster has a la= rge number of tables but it takes in excess of 1 hour to extract a list of = tables via ODBC Calls. Are there any known workarounds for this issue? Thanks --_000_D01396B35DBBAbradleywrightprogresscom_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
Try an eval of our comme= rcial ODBC driver for Hive:


It will perf= orm better!

From:= Charles Yorek <charle= syorek@gmail.com>
Reply-To: "user@hive.apache.org" <= user@hive.apache.org>
Date: Friday, August 15, 2014 9:54 AM=
To: "user@hive.apache.org" <user@hive.apache.org>
= Subject: ODBC Calls Extremely Slow

= Hello All, 

I am trying to use the ODBC driver but making ODBC Calls to fetch a list o= f tables from Hive is extremely slow on a HiveServer2.  The cluster ha= s a large number of tables but it takes in excess of 1 hour to extract a li= st of tables via ODBC Calls.

Are there any known workarounds for this issue?

Thanks
= --_000_D01396B35DBBAbradleywrightprogresscom_--