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.ma...@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 >> >> >
