hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lefty Leverenz <>
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

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

> 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

View raw message