Page History

...

When using the HCatalog CLI, you cannot specify a permission string without read permissions for owner, such as -wxrwxr-x, because the string begins with "-". If such a permission setting is desired, you can use the octal version instead, which in this case would be 375. Also, any other kind of permission string where the owner has read permissions (for example r-x------ or r--r--r--) will work fine.

Hive CLI

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. Note these differences:

• "hcat -g" and "hcat -p" for table group and permission settings are only available in the HCatalog CLI.
• hcat uses the -p flag for permissions but hive uses it to specify a port number.
• hcat uses the -D flag without a space to define key=value pairs but hive uses -d or --define with a space (also --hivevar).
  For example, "hcat -DA=B" versus "hive -d A=B".
• hcat without any flags prints a help message but hive uses the -H flag or --help.

The Hive CLI is documented here.

HCatalog DDL

HCatalog supports all Hive Data Definition Language except those operations that require running a MapReduce job. For commands that are supported, any variances are noted below.

...