Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Hive 0.11 & Hive 0.12 - Hive MySQL Metastore is not used for INSERT


Copy link to this message
-
Re: Hive 0.11 & Hive 0.12 - Hive MySQL Metastore is not used for INSERT
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
<[EMAIL PROTECTED]>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 <[EMAIL PROTECTED]>:
>
> 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/>*
>