setup
set hcatalog/bin to path and source ~/.bashrc
#hcat -h
Note:Many hcat
commands can be issued as hive
commands, including all HCatalog DDL commands. The Hive CLI includes some commands that are not available in the HCatalog CLI.
HCatalog DDL
HCatalog supports all Hive Data Definition Language except those operations that require running a MapReduce job.
HCatalog does not support the following Hive DDL and other HiveQL commands:
- ALTER INDEX ... REBUILD
- CREATE TABLE ... AS SELECT
- ALTER TABLE ... CONCATENATE
- ALTER TABLE ARCHIVE/UNARCHIVE PARTITION
- ANALYZE TABLE ... COMPUTE STATISTICS
- IMPORT FROM ...
- EXPORT TABLE
----------------------
The following commands are supported by hcat
CREATE TABLE
DROP TABLE
ALTER TABLE
Create/Drop/Alter View
Show/Describe
Create/Drop Index
Create/Drop Function
"dfs" Command and "set" Command
Reference
https://cwiki.apache.org/confluence/display/Hive/HCatalog+CLI