Writing Hive Query Output to local system
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
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, [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/
Re: Writing Hive Query Output to local system
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 |