Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (nike.apache.org: domain of thelabdude@gmail.com designates
 209.85.128.169 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAKOFcwqxBj0mw1V12i1kgK_Y3Yx7o8JcxTJWJSO_qNqoZrjRhg@mail.gmail.com>
References: 
 <CAKOFcwqxBj0mw1V12i1kgK_Y3Yx7o8JcxTJWJSO_qNqoZrjRhg@mail.gmail.com>
Date: Wed, 4 Dec 2013 11:50:39 -0700
Message-ID: 
 <CAJt9WnhwDn9HUZ_VcUgu07n_J8L3APNG9rj02rZn4-8atiA0MA@mail.gmail.com>
Subject: Re: Survey: What do you use to interface with Hive?
From: Timothy Potter <thelabdude@gmail.com>
To: user@hive.apache.org
Content-Type: text/plain; charset=ISO-8859-1

I'm a big user of HCatalog from Pig but wish the HCat code used the
RESTful HTTP interface instead of Thrift because the version
incompatibilities in Thrift are frankly mind-boggling. We get around
them by shading the thrift classes used by HCat

Also, have many of scripts that are launched as part of larger
workflows from Oozie - nice but again we fight with classpath issues
all the time. Oozie at least has some nice classpath isolation between
hive and pig actions.

Cheers,
Tim


On Wed, Dec 4, 2013 at 10:31 AM, John Omernik <john@omernik.com> wrote:
> This can be an interesting subject, I know orgs that are all over on this
> questions. I'd be interested in hearing what you use, how it works for you,
> and what you are wishing you had in your interface.
>
> I'll start:
>
> We've used a number of things:
> - CLI for scheduled jobs.  Pros: Solid running, fairly bug free. Cons: not
> for analysis of data, clunky in that regard.
>
> -SQL Squirrel via JDBC: Pros: Supported platform. Some nice analysis
> features (keeping old results, sorting of results once obtained, keeping of
> old queries Cons: Buggy with Hive, sometimes it just crashes for no reason,
> can be frustrating with lots of tabs, hard to extend and add little features
> for how you work (from my perspective)
>
> - Custom web based tools: pros designed around how we interact with our
> data. cons: no support, it currently has memory leak issues etc.
>
> - Apache Hue/Beeswax: Just starting to look into this now.
>
> I'd be curious on what you are using and challenges/wins you've had.
>
> Thanks!
>
> John