hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Naga Vijay <nagah...@gmail.com>
Subject Re: Hive 0.11 & Hive 0.12 - Hive MySQL Metastore is not used for INSERT
Date Mon, 03 Feb 2014 01:02:51 GMT
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 <nagahive@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.iftissen@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 <nagahive@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/>*
>>
>
>

Mime
View raw message