hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <leftylever...@gmail.com>
Subject Re: Difference between Hive and HCat table?
Date Tue, 05 Aug 2014 19:32:31 GMT
Perhaps this documentation will help:  HCatalog CLI -- Hive CLI
<https://cwiki.apache.org/confluence/display/Hive/HCatalog+CLI#HCatalogCLI-HiveCLI>
.

Also note the section that follows it, which begins "HCatalog supports all
Hive Data Definition Language except those operations that require running
a MapReduce job."

-- Lefty


On Tue, Aug 5, 2014 at 5:00 AM, Andrew Mains <andrew.mains@kontagent.com>
wrote:

> André,
>
> To my knowledge, your understanding is correct--given that both Hive and
> HCatalog are pointing to the same metastore instance, all HCatalog table
> operations should be
> reflected in Hive, and vice versa. You should be able to use the Hive CLI
> and hcat interchangeably to execute your DDL.
>
> Andrew
>
>
> On 8/5/14, 12:23 AM, André Hacker wrote:
>
>> Hi,
>>
>> a very simple question: Is there a difference between a table in Hive and
>> a table in HCat?
>> In other words: Can I create a table in Hive that is invisible in HCat,
>> or vice versa?
>> (Assuming that Hive and HCat point to the same metastore)
>>
>> From my understanding, HCat is just a wrapper around the Hive metastore,
>> so there should be no major difference. This is in line with my experience:
>> If I create a table via the Hive CLI, it will be shown in HCat too when
>> running hcat -e "show tables;". And vice versa.
>>
>> I ask because some online documentation makes me feel that I have to run
>> my DDL in HCat to make it visible there. At least I didn't find documents
>> that say that I can use either Hive CLI or HCat.
>>
>> Thanks,
>>
>> André Hacker
>>
>>
>

Mime
View raw message