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
