hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "grimaldi.vincenzo@gmail.com" <grimaldi.vince...@gmail.com>
Subject Re: Writing Hive Query Output to local system
Date Fri, 16 Jan 2015 19:27:21 GMT
In your hive-site.xml remove the <property> block corresponding to the
parametereƧ

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
 <http://facebook.com/vgrimaldi2>
<http://ie.linkedin.com/pub/vincenzo-grimaldi/14/422/bb1/>
   Get a signature like this:
<http://ws-stats.appspot.com/r?rdata=eyJydXJsIjogImh0dHA6Ly93d3cud2lzZXN0YW1wLmNvbS8/dXRtX3NvdXJjZT1leHRlbnNpb24mdXRtX21lZGl1bT1lbWFpbCZ1dG1fY2FtcGFpZ249cHJvbW9fNDUiLCAiZSI6ICJwcm9tb180NV9jbGljayJ9>
Click
here!
<http://ws-stats.appspot.com/r?rdata=eyJydXJsIjogImh0dHA6Ly93d3cud2lzZXN0YW1wLmNvbS8/dXRtX3NvdXJjZT1leHRlbnNpb24mdXRtX21lZGl1bT1lbWFpbCZ1dG1fY2FtcGFpZ249cHJvbW9fNDUiLCAiZSI6ICJwcm9tb180NV9jbGljayJ9>

2015-01-16 19:05 GMT+00:00 Sanjay Subramanian <sanjaysubramanian@yahoo.com>:

> 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 valid
> value for hive.metastore.uris if you are connecting to a remote metastore.
>
> How do I avoid this ?
>
> thanks
>
> sanjay
>



-- 
[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
 <https://mail.google.com/mail/u/0/facebook.com/vgrimaldi2>
<https://mail.google.com/mail/u/0/ie.linkedin.com/pub/vincenzo-grimaldi/14/422/bb1/>

Mime
View raw message