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 wrote:
> Hi,
>
> I have checked my hive-site.xml ; it i
tabase 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 :
>
> Hi,
>>
>> I am facing this situation for the below m
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 c
> igor
> > decide.com
> >
> >
> > On Thu, Jun 13, 2013 at 11:31 AM, Naga Vijay wrote:
> >>
> >> Sure, Will do
> >>
> >>
> >> On Thu, Jun 13, 2013 at 10:42 AM, Stephen Sprague
> >> wrote:
> >>>
> >>
dt
>> FROM
>> ( SELECT
>> item_id, create_dt
>> FROM
>> A
>> WHERE
>>item_id = 'I001'
>>AND
>> category_name = 'C001'
>>
Hi,
Which of the two query options is better?
SELECT a.item_id, a.create_dt
FROM a JOIN b
ON (a.item_id = b.item_id)
WHERE a.item_id = 'I001'
ANDa.category_name = 'C001';
- or -
SELECT a.item_id, a.create_dt
FROM a JOIN b
ON (a.item_id = b.item_id AND a.item_id = 'I001')
WHERE
