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 E16BD1000B for ; Mon, 30 Dec 2013 01:33:30 +0000 (UTC) Received: (qmail 39001 invoked by uid 500); 30 Dec 2013 01:33:29 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 38865 invoked by uid 500); 30 Dec 2013 01:33:29 -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 38857 invoked by uid 99); 30 Dec 2013 01:33:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Dec 2013 01:33:29 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of jayunit100@gmail.com designates 209.85.128.54 as permitted sender) Received: from [209.85.128.54] (HELO mail-qe0-f54.google.com) (209.85.128.54) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 30 Dec 2013 01:33:22 +0000 Received: by mail-qe0-f54.google.com with SMTP id cy11so10939449qeb.41 for ; Sun, 29 Dec 2013 17:33:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=references:mime-version:in-reply-to:content-type :content-transfer-encoding:message-id:cc:from:subject:date:to; bh=6/cwBYm4nFJgZXpefOkZkL4D18LrRutK/7ZW9pQV5A4=; b=o+IQ1fJmUVZjn0UkRm+5nS6Dyp3/JmdNt+qj7LdX944uVQdxiEFzBIz5wkaEMlOAvl F93eCVKUiH79MUTh+6DNgFs10vwAkPaervVoz8fB4yM3ldU/Is2IwY1HOhPRFLeZhTgF FQxj7djNHdCAp97e0LQ/JwhN+8CInUtr4utphjRPDruqzyJ/PomeulyB95xELBWEXmsb kxD9xj1+FD9HC34tGiqAjFYI9RukUjzBZVBcKJpSFB+M3K0HG3gWo20AC6hUb1DfWH74 LHaBvqQlicUy4VuGJMNUCT2xMFo3KCk+l7kAC4MHKWx3kPzrogC1iIPD8ouvCqJyjU+R U9kg== X-Received: by 10.49.101.105 with SMTP id ff9mr106664551qeb.34.1388367181154; Sun, 29 Dec 2013 17:33:01 -0800 (PST) Received: from [10.137.14.179] (mobile-198-228-204-074.mycingular.net. [198.228.204.74]) by mx.google.com with ESMTPSA id d1sm63330525qai.7.2013.12.29.17.32.59 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Sun, 29 Dec 2013 17:32:59 -0800 (PST) References: <74CBD601-C1B3-4A0A-9896-929866D5135F@gmail.com> <59A9DD4B-9F91-4C9A-A46C-14BC61094F3C@gmail.com> Mime-Version: 1.0 (1.0) In-Reply-To: Content-Type: multipart/alternative; boundary=Apple-Mail-700CB125-10BE-4970-A0BF-DB543627BD1C Content-Transfer-Encoding: 7bit Message-Id: Cc: "user@hive.apache.org" X-Mailer: iPhone Mail (11A465) From: Jay Vyas Subject: Re: Hive, datanucleus, jdbc, localmode. Date: Sun, 29 Dec 2013 20:32:58 -0500 To: "user@hive.apache.org" X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-700CB125-10BE-4970-A0BF-DB543627BD1C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Yes this blog + hive_test should be merged into a jira and then officially i= ntegrated into hive in some way I think. > On Dec 29, 2013, at 8:44 AM, Edward Capriolo wrote= : >=20 > This article describes exactly what hive test does. >=20 > :) >=20 >=20 >> On Sat, Dec 28, 2013 at 9:18 PM, Jay Vyas wrote: >> Anyone try this yet :=20 >>=20 >> http://hadoop-pig-hive-thejas.blogspot.com/2013/04/running-hive-in-local-= mode.html >>=20 >> ? >>=20 >>=20 >>> On Sat, Dec 28, 2013 at 8:09 PM, Jay Vyas wrote: >>> -Local mode should have clear instructions on how to run fully local hiv= e jobs, with no hadoop installation. >>>=20 >>> -I like the hive_test repo but I'm not yet sure hive_test is 100% up to d= ate with the simplest strategy for testing hive workflows on the JVM. >>>=20 >>>=20 >>>> On Dec 28, 2013, at 4:19 PM, Lefty Leverenz w= rote: >>>>=20 >>>> This sounds like something the documentation should cover.=20 >>>> What information should be added to the Local Mode section?=20 >>>> Should the wiki have a link to hive_test (for example, in Hive Develope= r FAQ)? >>>>=20 >>>> -- Lefty >>>>=20 >>>>=20 >>>>> On Sat, Dec 28, 2013 at 8:02 AM, Edward Capriolo wrote: >>>>> I do not think so. Local mode, just implies the job tracker is local (= and some of the temp storage directories) it does not imply hive will use ha= doop without forking.=20 >>>>>=20 >>>>>=20 >>>>>> On Sat, Dec 28, 2013 at 10:43 AM, Jay Vyas wro= te: >>>>>> Thanks... But are you sure this is the only way? Or is there some mag= ic way to run hive in local mode that we both are missing out on ?:)... >>>>>>=20 >>>>>> - isn't hive in local mode supposed to be run simply via the jdbc://h= ive URL which runs local mode... Or maybe by the fork config parameter? >>>>>>=20 >>>>>> - For example see the parameters in this file: >>>>>>=20 >>>>>> https://github.com/riptano/brisk/blob/master/resources/hive/conf/hive= -site.xml >>>>>>=20 >>>>>>=20 >>>>>>> On Dec 28, 2013, at 10:22 AM, Edward Capriolo wrote: >>>>>>>=20 >>>>>>> You can follow along to what I do here. >>>>>>>=20 >>>>>>> https://github.com/edwardcapriolo/hive_test >>>>>>>=20 >>>>>>> Essentially hive requires a HADOOP_HOME because it always wants to f= ork a bin/hadoop process. Hive-test helps you unpack hadoop inside target an= d change your hadoop_home to some other directory.=20 >>>>>>>=20 >>>>>>> It would be nice if there was some other way to do this. >>>>>>>=20 >>>>>>>=20 >>>>>>>> On Fri, Dec 27, 2013 at 10:27 PM, Jay Vyas w= rote: >>>>>>>> Hi Hive: >>>>>>>>=20 >>>>>>>> I'm attempting to create a robust eclipse based dev environment for= testing my hive jobs in localmode however I run into classnotfound errors d= epending on which maven dependencies I use. Also, it seems when I change the= se dependencies from hive 0.12 to hive 0.11, I get other errors related to h= ive trying to launch jobs via calling /usr/bin/hadoop. >>>>>>>>=20 >>>>>>>> This I am stuck: I can't run hive 12 in local java mode because of s= ubtle datanucleus class and API inconsistencies which are tough to resolve, a= nd when going to hive 11, it seems local mode is not natively detected via t= he jdbc URL... >>>>>>>>=20 >>>>>>>> So I have 2 questions: >>>>>>>>=20 >>>>>>>> 0) how does hive 12 versus 11 implement local mode differently ? >>>>>>>>=20 >>>>>>>> And >>>>>>>>=20 >>>>>>>> 1) What is the right way to in hive in pure java/ local environment= s? >>>>>>>>=20 >>>>>>>> The hive book suggests modifying configuration properties, for loca= l mode.. >>>>>>>>=20 >>>>>>>> but I also have found that in hive 0.12 , using the jdbc://hive co= nnection URL automagically launches jobs in local mode.. >>>>>>>>=20 >>>>>>>> However in 0.11 , I see calls to /usr/bin/hadoop when running java c= lasses in local eclipse environment. >>>>>>>>=20 >>>>>>>> Thanks! >>>>>>>>=20 >>>>>>>> FYI to see an example of my pom.xml, you can checkout the github://= jayunit100/bigpetstore pom.xml file. >>=20 >>=20 >>=20 >> --=20 >> Jay Vyas >> http://jayunit100.blogspot.com >=20 --Apple-Mail-700CB125-10BE-4970-A0BF-DB543627BD1C Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit
Yes this blog + hive_test should be merged into a jira and then officially integrated into hive in some way I think.

On Dec 29, 2013, at 8:44 AM, Edward Capriolo <edlinuxguru@gmail.com> wrote:

This article describes exactly what hive test does.

:)


On Sat, Dec 28, 2013 at 9:18 PM, Jay Vyas <jayunit100@gmail.com> wrote:


On Sat, Dec 28, 2013 at 8:09 PM, Jay Vyas <jayunit100@gmail.com> wrote:
-Local mode should have clear instructions on how to run fully local hive jobs, with no hadoop installation.

-I like the hive_test repo but I'm not yet sure hive_test is 100% up to date with the simplest strategy for testing hive workflows on the JVM.


On Dec 28, 2013, at 4:19 PM, Lefty Leverenz <leftyleverenz@gmail.com> wrote:

This sounds like something the documentation should cover. 

-- Lefty


On Sat, Dec 28, 2013 at 8:02 AM, Edward Capriolo <edlinuxguru@gmail.com> wrote:
I do not think so. Local mode, just implies the job tracker is local (and some of the temp storage directories) it does not imply hive will use hadoop without forking.


On Sat, Dec 28, 2013 at 10:43 AM, Jay Vyas <jayunit100@gmail.com> wrote:
Thanks... But are you sure this is the only way? Or is there some magic way to run hive in local mode that we both are missing out on ?:)...

- isn't hive in local mode supposed to be run simply via the jdbc://hive URL which runs local mode... Or maybe by the fork config parameter?

- For example see the parameters in this file:



On Dec 28, 2013, at 10:22 AM, Edward Capriolo <edlinuxguru@gmail.com> wrote:

You can follow along to what I do here.

https://github.com/edwardcapriolo/hive_test

Essentially hive requires a HADOOP_HOME because it always wants to fork a bin/hadoop process. Hive-test helps you unpack hadoop inside target and change your hadoop_home to some other directory.

It would be nice if there was some other way to do this.


On Fri, Dec 27, 2013 at 10:27 PM, Jay Vyas <jayunit100@gmail.com> wrote:
Hi Hive:

I'm attempting to create a robust eclipse based dev environment for testing my hive jobs in localmode however I run into classnotfound errors depending on which maven dependencies I use. Also, it seems when I change these dependencies from hive 0.12 to hive 0.11, I get other errors related to hive trying to launch jobs via calling /usr/bin/hadoop.

This I am stuck: I can't run hive 12 in local java mode because of subtle datanucleus class and API inconsistencies which are tough to resolve, and when going to hive 11, it seems local mode is not natively detected via the jdbc URL...

So I have 2 questions:

0) how does hive 12 versus 11 implement local mode differently ?

And

1) What is the right way to in hive in pure java/ local environments?

The hive book suggests modifying configuration properties, for local mode..

but I also have found  that in hive 0.12 , using the jdbc://hive connection URL automagically launches jobs in local mode..

However in 0.11 , I see calls to /usr/bin/hadoop when running java classes in local eclipse environment.

Thanks!

FYI to see an example of my pom.xml, you can checkout the github://jayunit100/bigpetstore pom.xml file.






--
Jay Vyas
http://jayunit100.blogspot.com

--Apple-Mail-700CB125-10BE-4970-A0BF-DB543627BD1C--