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.vince...@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 <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 > -- [image: photo] *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 <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/>