I have modified the title of the JIRA to properly reflect the issue faced -
Hive 0.11 & Hive 0.12 - derby.log and TempStatsStore are created when using MySQL Metastore Regards Naga On Sun, Feb 2, 2014 at 2:15 PM, Naga Vijay <nagah...@gmail.com> wrote: > Hi, > > I have checked my hive-site.xml ; it is fine ; hive metastore service is > running as well. > > I have logged this - https://issues.apache.org/jira/browse/HIVE-6352 > > Regards > Naga > > > On Sun, Feb 2, 2014 at 9:11 AM, Matouk IFTISSEN < > matouk.iftis...@ysance.com> wrote: > >> Hello, >> see your hie-site.xml file, and check the database connexion( connexion >> string) because in this file, that happend connexion to the metastore when >> you start Hive. >> >> Hope this helps you. >> regards. >> Matouk >> >> >> 2014-02-02 Naga Vijay <nagah...@gmail.com>: >> >> Hi, >>> >>> I am facing this situation for the below mentioned hql file - >>> >>> > Hive MySQL Metastore is used for table t1 >>> >>> > Hive MySQL Metastore is not used for table t2 (derby.log is created in >>> the directory) >>> >>> ---------- >>> >>> >>> -- database pp_test_hive_metastore >>> >>> drop database if exists pp_test_hive_metastore cascade; >>> >>> create database pp_test_hive_metastore; >>> >>> use pp_test_hive_metastore; >>> >>> -- table t1 >>> >>> create table t1 ( id int, name string ); >>> >>> LOAD DATA LOCAL INPATH 'testHiveMetastore.txt' OVERWRITE INTO TABLE t1; >>> >>> select * from t1; >>> >>> select count(*) from t1; >>> >>> -- table t2 >>> >>> create table t2 ( id int, name string ); >>> >>> INSERT OVERWRITE TABLE t2 SELECT t.* FROM t1 t; >>> >>> select * from t2; >>> >>> select count(*) from t2; >>> >>> -- done >>> >>> quit; >>> >>> --------------- >>> >>> Testing Procedure : Comment/Uncomment the lines for table t2 >>> >>> Can someone throw some light on this? >>> >>> Thanks >>> Naga >>> >>> >> >> >> -- >> >> *Matouk IFTISSEN | Consultant BI & Big Data [image: >> http://www.ysance.com] * >> 24 rue du sentier - 75002 Paris - www.ysance.com <http://www.ysance.com/> >> Mob : +33 6 78 51 18 69 || Fax : +33 1 73 72 97 26 >> *Ysance sur* :*Twitter* <http://twitter.com/ysance>* | Facebook >> <https://www.facebook.com/pages/Ysance/131036788697> | Google+ >> <https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts> >> | LinkedIn >> <http://www.linkedin.com/company/ysance> | Newsletter >> <http://www.ysance.com/nous-contacter.html>* >> *Nos autres sites* : *ys4you* <http://wwww.ys4you.com/>* | labdecisionnel >> <http://www.labdecisionnel.com/> | decrypt <http://decrypt.ysance.com/>* >> > >
