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/>* >