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 EE3751098E for ; Fri, 16 Jan 2015 19:30:02 +0000 (UTC) Received: (qmail 84258 invoked by uid 500); 16 Jan 2015 19:30:03 -0000 Delivered-To: apmail-hive-user-archive@hive.apache.org Received: (qmail 84185 invoked by uid 500); 16 Jan 2015 19:30:02 -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 84175 invoked by uid 99); 16 Jan 2015 19:30:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Jan 2015 19:30:02 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS,T_REMOTE_IMAGE X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of grimaldi.vincenzo@gmail.com designates 209.85.223.171 as permitted sender) Received: from [209.85.223.171] (HELO mail-ie0-f171.google.com) (209.85.223.171) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 16 Jan 2015 19:29:38 +0000 Received: by mail-ie0-f171.google.com with SMTP id ar1so22469364iec.2 for ; Fri, 16 Jan 2015 11:27:21 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=SJ86DWiQ2KIBwYOeOF+yQX/E/OBpxKxvIZwgXttbbTQ=; b=ZbFir4uWcdYLg8SI4g+sY9MdmDlaHAxUFg/7bSVVgOV5pJST1O+cSQDPiaYX2VaZBU y8QGjxVNUhyXTiRLlhS0xO5OyVKRIXgyh1VfxYZ8znDfxPmAiWLsHsSDmNueqc766y9i Fnj42C+HYl8aQ2e9TSgNYISBpyfDREE0095SpFxjDqo6GJisp50+gjxGHLamzhOSVbeL R3llPcThYTxrU6+O8G3btOpOrTM/FGGyhcmaAXWmupoAfzurLyhtMyhWFkcUJbbWAwhB qalzleFmRuOmY7ZMDcwR0vvuszbftgmv3UsWGVErV97linm9+dfiuc+lhAyk0lpuY0hJ zyqg== MIME-Version: 1.0 X-Received: by 10.107.17.72 with SMTP id z69mr10605791ioi.90.1421436441337; Fri, 16 Jan 2015 11:27:21 -0800 (PST) Received: by 10.64.121.5 with HTTP; Fri, 16 Jan 2015 11:27:21 -0800 (PST) In-Reply-To: <2044949186.535174.1421435123479.JavaMail.yahoo@jws10713.mail.gq1.yahoo.com> References: <2044949186.535174.1421435123479.JavaMail.yahoo@jws10713.mail.gq1.yahoo.com> Date: Fri, 16 Jan 2015 19:27:21 +0000 Message-ID: Subject: Re: Writing Hive Query Output to local system From: "grimaldi.vincenzo@gmail.com" To: user@hive.apache.org, Sanjay Subramanian Content-Type: multipart/alternative; boundary=001a113ed61828274b050cc9f659 X-Virus-Checked: Checked by ClamAV on apache.org --001a113ed61828274b050cc9f659 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable In your hive-site.xml remove the block corresponding to the parametere=C3=A7 hive.metastore.local That's hit. Is a deprecated parameter and is not necessary anymore. Regards, [image: photo] *Vincenzo Grimaldi* Senior Business Intelligence Consultant p:00 39 380 52 22 218 | m:00 353 851 69 84 58 | e: grimaldi.vincenzo@gmail.com | a: Aprt. 148A, Smithfield Market, Smithfield, Dublin 7, Ireland Get a signature like this: Click here! 2015-01-16 19:05 GMT+00:00 Sanjay Subramanian = : > hey guys > > I recall this did not happen in the days of 0.9.x version > > But I use 0.13.x now and when I run a hive query > > hive -e "select * from tablename" > ./myfile.txt > > The first line in myfile.txt is as follows > > 2015-01-16 10:48:13,091 WARN [main] conf.HiveConf > (HiveConf.java:initialize(1491)) - DEPRECATED: Configuration property > hive.metastore.local no longer has any effect. Make sure to provide a val= id > value for hive.metastore.uris if you are connecting to a remote metastore= . > > How do I avoid this ? > > thanks > > sanjay > --=20 [image: photo] *Vincenzo Grimaldi* Senior Business Intelligence Consultant p:00 39 380 52 22 218 | m:00 353 851 69 84 58 | e: grimaldi.vincenzo@gmail.com | a: Aprt. 148A, Smithfield Market, Smithfield, Dublin 7, Ireland --001a113ed61828274b050cc9f659 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
In your hive-site.xml remove the <property> blo= ck corresponding to the parametere=C3=A7

hive.metastore.local<= br>
That's hit. Is a deprecated parameter and is = not necessary anymore.

Regards,



3D"photo"
Vincenzo Grimaldi
Senior Business Intelligence Consultant
p:00 39 380 52 22 21= 8 | m:00 353 851 69 84 58 | e:grimaldi.vincenzo@gmail.com | a: Aprt. 148A, Smith= field Market, Smithfield, Dublin 7, Ireland
=C2=A0

2015-01-16 19:05 GMT+00:00 Sanjay Subramanian <sanjaysubrama= nian@yahoo.com>:
hey guys

=
I recall this did not happen in the days of 0.9.x ve= rsion

But I use 0.13.x now= and when I run a hive query=C2=A0

hive -e "select * from tablename" > ./myfile.txt

The first line in myfile.txt i= s as follows

2015-01-16 10:48:13,091 WARN=C2=A0 [main] conf.HiveConf (H= iveConf.java:initialize(1491)) - DEPRECATED: Configuration property hive.me= tastore.local no longer has any effect. Make sure to provide a valid value = for hive.metastore.uris if you are connecting to a remote metastore.=

How do I avoid this ?

thanks

sanjay



--
3D"photo"
Vincenzo Grimaldi
= Senior Business Intelligence Consultant
p:00 39 380 52 22 218 | = m:00 353 851 69 84 5= 8 | = e:grimaldi.vincenzo@gmail.com= =09 | a: Aprt. 148A, Smit= hfield Market, Smithfield, Dublin 7, Ireland
=09
=C2=A0=C2=A0
=09
--001a113ed61828274b050cc9f659--