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