HIVE - hive.metastore.local (DEPRECATED)

http://community.cloudera.com/t5/Batch-SQL-Apache-Hive/WARN-main-conf-HiveConf-HiveConf-java-initialize-1488/m-p/23136#M462

$ hive --version
Hive 0.13.1-cdh5.3.0
Subversion git://ubuntu64-12-04-mk1/var/lib/jenkins/workspace/generic-package-ubuntu64-12-04/CDH5.3.0-Packaging-Hive-2014-12-16_19-00-17/hive-0.13.1+cdh5.3.0+306-1.cdh5.3.0.p0.29~precise -r 8e266e052e423af592871e2dfe09d54c03f6a0e8
Compiled by jenkins on Tue Dec 16 19:03:14 PST 2014
From source with checksum d065deb124f4d43fc970e0b8fd659236

A WARN message in HIVE is currently piped to STDOUT (not to STDERR). This is not good because if you are doing something like:

hive -e "somequery" > something.csv

the warning error msg will go to the something.csv also.

===

quick fix:

to comment out / remove :

<property>
<name>hive.metastore.local</name>
<value>false</value>
</property>

in /etc/hive/conf/hive-site.xml.