I am using Cloudera Manager and I know how to add a param thru Safety Valve I don't know how to ignore a param thru Safety Valve :-) Actually I will put the question on the CDH groups as well... Any thoughts guys ? thanks
sanjay From: "grimaldi.vince...@gmail.com" <grimaldi.vince...@gmail.com> To: user@hive.apache.org; Sanjay Subramanian <sanjaysubraman...@yahoo.com> Sent: Friday, January 16, 2015 11:27 AM Subject: Re: Writing Hive Query Output to local system 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, | | Vincenzo Grimaldi Senior Business Intelligence Consultant p:00 39 380 52 22 218 | m:00 353 851 69 84 58 | e:grimaldi.vince...@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 <sanjaysubraman...@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 -- | | Vincenzo Grimaldi Senior Business Intelligence Consultant p:00 39 380 52 22 218 | m:00 353 851 69 84 58 | e:grimaldi.vince...@gmail.com | a: Aprt. 148A, Smithfield Market, Smithfield, Dublin 7, Ireland |