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.

HCatalog DDL

...

HCatalog does not support the following Hive DDL commands:

• IMPORT FROM ...
• EXPORT TABLE
• CREATE TABLE ... AS SELECT
• ALTER TABLE ... REBUILD
• ALTER TABLE ... CONCATENATE
• ANALYZE TABLE ... COMPUTE STATISTICS
• ALTER TABLE ARCHIVE/UNARCHIVE PARTITION

Create/Drop/Alter Table

CREATE TABLE

If you create a table with a CLUSTERED BY clause you will not be able to write to it with Pig or MapReduce. This is because they do not understand how to partition the table, so attempting to write to it would cause data corruption.

CREATE TABLE AS SELECT

Not supported. Throws an exception with the message "Operation Not Supported".

DROP TABLE

Supported. Behavior the same as Hive.

ALTER TABLE

Supported except for the REBUILD and CONCATENATE options. Behavior the same as Hive.

Create/Drop/Alter View

Note: Pig and MapReduce cannot read from or write to views.

CREATE VIEW

Supported. Behavior same as Hive.

DROP VIEW

Supported. Behavior same as Hive.

ALTER VIEW

Supported. Behavior same as Hive.

Show/Describe

SHOW TABLES

Supported. Behavior same as Hive.

SHOW PARTITIONS

Not supported. Throws an exception with message "Operation Not Supported".

SHOW FUNCTIONS

Supported. Behavior same as Hive.

DESCRIBE

Supported. Behavior same as Hive.

Create/Drop Index

CREATE and DROP INDEX operations are supported.

Note: Pig and MapReduce cannot write to a table that has auto rebuild on, because Pig and MapReduce do not know how to rebuild the index.

Create/Drop Function

CREATE and DROP FUNCTION operations are supported, but created functions must still be registered in Pig and placed in CLASSPATH for MapReduce.

"dfs" Command and "set" Command

Supported. Behavior same as Hive.

Other Commands

Any command not listed above is NOT supported and throws an exception with the message "Operation Not Supported".

CLI Errors

Authentication

...

Error Log

If other errors occur while using the HCatalog CLI, more detailed messages are written to /tmp/<username>/hive.log.