Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 62427200AE4 for ; Fri, 10 Jun 2016 06:58:22 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 60D04160A59; Fri, 10 Jun 2016 04:58:22 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 5FDE4160A58 for ; Fri, 10 Jun 2016 06:58:21 +0200 (CEST) Received: (qmail 67513 invoked by uid 500); 10 Jun 2016 04:58:20 -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 67503 invoked by uid 99); 10 Jun 2016 04:58:19 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Jun 2016 04:58:19 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 74C101A0664 for ; Fri, 10 Jun 2016 04:58:19 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.179 X-Spam-Level: ** X-Spam-Status: No, score=2.179 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_FONT_FACE_BAD=0.289, HTML_MESSAGE=2, LOTS_OF_MONEY=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, T_REMOTE_IMAGE=0.01] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=pass (2048-bit key) header.d=gmail.com Received: from mx2-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id AYLqpq1mEJ_F for ; Fri, 10 Jun 2016 04:58:16 +0000 (UTC) Received: from mail-yw0-f173.google.com (mail-yw0-f173.google.com [209.85.161.173]) by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id E9D655F19D for ; Fri, 10 Jun 2016 04:58:15 +0000 (UTC) Received: by mail-yw0-f173.google.com with SMTP id c72so57025223ywb.1 for ; Thu, 09 Jun 2016 21:58:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:from:date:message-id:subject:to; bh=gfB9u03LiPhmMOLwTelW9WibK5MUo6QOMfsrfRgLUG8=; b=zZJUgVXy2SZ0ueNeIhQRWDY9IbYIMq+R2bDq0U3F5nHUQ7L+H8Tk+rcxPtBfQzh1rH 34EocTl5nHcoM8twPe2brZVDVzeilbzlRPs61SJofxOTt9CQy77OqOJnhkqSGlAulm5a 2Px3iDsIXqGUh3bCiILvSNQIOXwl7lk9e0s0UJSqqknz6ifyfF7YY5dEBnWywNNn2zFB 07537xFHBhVV1HryfaTdsIFkGdiXVvLYXn3OTbFTScAbvN3jgAh7AI/gU76EjQK7vqwc wBuN9s7edxY/Wmq+41Y6ILuN242+P/P3YO29xeD1BidfECNJRnlCFtO752WysAC4qnDN 2bqA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to; bh=gfB9u03LiPhmMOLwTelW9WibK5MUo6QOMfsrfRgLUG8=; b=KfY2O5iQ4IGAlvKu/VjXMMwBKsa6L1tPW3UrtLa5PKTApljLqBkFSooFgKzGIbyhkj dfRYg651yUX2V79WMNxNlx+2boqYHxiV5sFczEzun6op8FPzDrZjW9K8dS8OsXicvO3O DP9VCl3jZcJyP94MekkNzqtm4Z/qJ1BIVqkEWjYa2eVp34I/uvJhYJGztv827rpwck9b oE3J7Cy6SzqITDu4CC+S83WOQE7GbOkK6jK2CQxovtrrWVBXxgc3Zmz3jEQ0vMakob8W oS1/I4gbTD5kIufIz17nfT+l1fTvsoZ1zFKBaig2H3PBNkpUOaqwBZr0HJk5iciSebup 7HLg== X-Gm-Message-State: ALyK8tIXiunGkKVzBYmTk7aObJAgPRAcASkBzzjM3RoUIDFxT3PaS8BioPsdkL7zcciaNmrlJP5ZrRfMB5uHtA== X-Received: by 10.13.206.67 with SMTP id q64mr37545ywd.28.1465534694799; Thu, 09 Jun 2016 21:58:14 -0700 (PDT) MIME-Version: 1.0 Received: by 10.37.192.145 with HTTP; Thu, 9 Jun 2016 21:58:14 -0700 (PDT) In-Reply-To: <1465505453605.7705@hortonworks.com> References: <1465505453605.7705@hortonworks.com> From: dhruv kapatel Date: Fri, 10 Jun 2016 10:28:14 +0530 Message-ID: Subject: Re: Where are jars stored for permanent functions To: user@hive.apache.org Content-Type: multipart/alternative; boundary=001a114daface3c8c20534e5625e archived-at: Fri, 10 Jun 2016 04:58:22 -0000 --001a114daface3c8c20534e5625e Content-Type: text/plain; charset=UTF-8 In order to add it permanently recommended ways are as follows. 1. add in hive-site.xml hive.aux.jars.path file://localpath/yourjar.jar 2. Copy and paste the JAR file to the ${HIVE_HOME}/auxlib/ folder (create it if it does not exist). Source: Apache hive essentials book On 10 June 2016 at 02:20, Jason Dere wrote: > Hive doesn't currently handle storing of the JARs. Doing ADD JAR only > adds the jars to the current session, but won't help for other sessions. > > The permanent functions syntax allows you to specify JAR paths when you > create the function. These should be on HDFS or other non-local path. > > > create function ST_GeomFromWKT as 'com.esri.hadoop.hive.ST_GeomFromWKT' > using jar 'hdfs:/path/to/spatial-sdk-hive-1.1.jar', jar 'hdfs:/path/to/ > esri-geometry-api-1.2.1.jar'; > > > ------------------------------ > *From:* Marcin Tustin > *Sent:* Wednesday, June 08, 2016 1:10 PM > *To:* user@hive.apache.org > *Subject:* Where are jars stored for permanent functions > > Hi All, > > I just added local jars to my hive session, created permanent functions, > and find that they are available across sessions and machines. This is of > course excellent, but I'm wondering where those jars are being stored? What > setting or what default directory would I find them in. > > My session was: > > add jars /mnt/storage/spatial-sdk-hive-1.1.jar > /mnt/storage/esri-geometry-api-1.2.1.jar; > > create function ST_GeomFromWKT as 'com.esri.hadoop.hive.ST_GeomFromWKT'; > > > Then that function was available via the thriftserver. > > > Thanks, > > Marcin > > Want to work at Handy? Check out our culture deck and open roles > > Latest news at Handy > Handy just raised $50m > led > by Fidelity > > -- *With Regards:Kapatel Dhruv vmobile:+919909214243* --001a114daface3c8c20534e5625e Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

In order to add it per= manently recommended ways are as follows.

  1. add = in hive-site.xml

    <property> <name>hive.aux.jars.path</name> <value>file://localpath/yourjar.jar</value> </property>

  2. Copy and paste the JAR file to the=C2=A0${HIVE_HOME}/auxlib/=C2=A0folder (create it if it does not ex= ist).

    Source: = Apache hive essentials book

<= br>
On 10 June 2016 at 02:20, Jason Dere <jd= ere@hortonworks.com> wrote:

Hive doesn't currently handle storing of the JARs.=C2=A0Doing ADD JAR only adds the jars to the current session= , but won't help for other sessions.

The permanent functions syntax allows you to specify JAR paths when you = create the function. These should be on HDFS or other non-local path.


create function ST_GeomFromWKT as 'com.esri.hadoop.hive.ST_GeomFromWK= T' using jar 'hdfs:/path/to/spatial-sdk-hive-1.1.jar', jar 'hdfs:/path/to/esri-geometry-api-1.2.1.jar';


From: Marcin Tustin <mtustin@handybook.com>
Sent: Wednesday, June 08, 2016 1:10 PM
To: user@h= ive.apache.org
Subject: Where are jars stored for permanent functions
=C2=A0
Hi All,

I just added local jars to my hive session, created permanent function= s, and find that they are available across sessions and machines. This is o= f course excellent, but I'm wondering where those jars are being stored= ? What setting or what default directory would I find them in.

My session was:

add jars /mnt/storage/spatial-sdk-hive-1.1.jar /mnt/storage/esri-g= eometry-api-1.2.1.jar;

create function ST_GeomFromWKT as 'com.esri.hadoop.hive.ST_Geo= mFromWKT';


Then that function was available via the thriftserver.=C2=A0


Thanks,

Marcin


Want to work at Handy? Check out our=C2= =A0culture deck and open roles
Latest=C2=A0ne= ws=C2=A0at Handy
Handy=C2=A0just = raised $50m=C2=A0led by Fidelity




--
With R= egards:
Kapatel Dhruv v
mobile:+919909214243
<= font color=3D"#000099" face=3D"'comic sans ms', sans-serif" size=3D= "4">

=C2=A0= =C2=A0=3D""=C2=A0=C2=A0=C2=A0
=C2=A0

<= /div>
--001a114daface3c8c20534e5625e--