Re: Why hive 0.13 will initialize derby database if the metastore parameters are not set in hive-site.xml?

2015-03-06 Thread Jim Green
Hi Edward, No matter if I set hive.stats.autogather=false in hive-site.xml or .hiverc, when I run “hive”, the derby database is still created. # hive hive set hive.stats.autogather ; hive.stats.autogather=false # ls -altr|grep metastore_db drwxr-xr-x 5 root root 4096 Mar 6 18:34

Re: Why hive 0.13 will initialize derby database if the metastore parameters are not set in hive-site.xml?

2015-03-06 Thread Jim Green
And Starting from hive 0.13, hive.stats.dbclass=fs by default. So I am thinking autostats may not be related here. Could be some other features need derby…. On Fri, Mar 6, 2015 at 6:37 PM, Jim Green openkbi...@gmail.com wrote: Hi Edward, No matter if I set hive.stats.autogather=false in

Re: Why hive 0.13 will initialize derby database if the metastore parameters are not set in hive-site.xml?

2015-03-06 Thread Edward Capriolo
Make sure hive autogather stats is false . Or aetup the stats db On Friday, March 6, 2015, Jim Green openkbi...@gmail.com wrote: Hi Team, Starting from hive 0.13, if the metastore parameters are not set in hive-site.xml, but we set in .hiverc, hive will try to initialize derby database in

Why hive 0.13 will initialize derby database if the metastore parameters are not set in hive-site.xml?

2015-03-06 Thread Jim Green
Hi Team, Starting from hive 0.13, if the metastore parameters are not set in hive-site.xml, but we set in .hiverc, hive will try to initialize derby database in current working directory. This behavior did not exist in hive 0.12. Is it a known bug? or behavior change? I have the repro as below: